Name | CNS Query Find Records |
---|
Description | Performs a find, returning all matches.
|
---|
Format | CNS Query Find Records ( Select entire contents ; Field Separator ; Record Separator ; Target ; File Name ; Table Name ; Find Criteria ; Return As ; Case Sensitive ; Field Names ; Sort Fields ) |
---|
Required Parameters | Find Criteria A return- or paragraph mark-separated list of “FieldName=FieldValue” pairs used to find the records. [Use “” to separate multiple values for a single field.]
Return AsChoose “Text”, “JSON”, or “RecordData” to determine how you want the result returned to you. If you choose “RecordData”, this function will return a blank response when successful and you can use the CNS Query Get Record Data script step to retrieve any data.
Case SensitiveIf True, the plug-in will preserve the case in the find criteria. [Default is False.]
|
---|
Optional Parameters | - Select entire contents
If checked, the target field or variable will be replaced by the result of this script step.
- Field Separator
When UseRecordData is False, use this to specify what to insert between the values of each field. [This can be more than one character; Default is a comma.]
- Record Separator
When UseRecordData is False, use this to specify what to insert between each record. [This can be more than one character; Default is a return.]
- Target
Specify the field or variable to receive the file path.
- File Name
The database file name.
- Table Name
The name of the table occurrence in which to find the records. [Specify “” to use the current layout TO.]
- Field Names
A return- or paragraph mark-separated list of field names for the fields you want returned. [Include “rowid” to return FileMaker’s internal record IDs; Default is to return all fields.]
- Sort Fields
A return- or paragraph mark-separated list of “FieldName=SortDirection” pairs to sort the found records. [Use “Asc” and “Desc” to sort ascending or descending; Default is creation order.]
|
---|