Product Logo

CNS Query

Query your databases without relationships.

Script Steps

CNS Query Find Records

NameCNS Query Find Records
Description

Performs a find, returning all matches.

FormatCNS 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 As

Choose “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 Sensitive

If 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.]