Developer’s Guide

B-8 Developer’s Guide
–max (Maximum records)
Name/Value Type: Parameter
What it does: Specifies the maximum number of records that should
be returned.
Value is: A number from 1 through 2147483647, or the word "All".
The default value is 25.
Optional with: –find requests
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–max=10&–find
–skip (Skip records)
Name/Value Type: Parameter
What it does: Tells FileMaker Pro how many records to skip in the
found set.
Value is: A number from 0 through 2147483647, or the word "All".
If the value is greater then the number of records in the found set or
the value is "All" then the last record is displayed. The default value
is 0.
Optional with: –find requests
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–skip=10&–max=5&–find
In this example, the first 10 records in the found set are skipped and
records 11 through 15 are returned.
–sortfield (Sort field)
Name/Value Type: Parameter
What it does: Specifies the field that will be used for sorting. The
–sortfield parameter can been used multiple times to perform
multiple field sorts. The position in which –sortfield appears in the
CGI command will determine the sort order of the fields.
Value is: Name of a FileMaker Pro field.
Optional with: –find or –findall requests
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–sortfield=First+Name&–find
–sortorder (Sort order)
Name/Value Type: Parameter
What it does: Indicates the direction of a sort. If used, –sortorder
must directly follow the –sortfield parameter it applies to.
Value is: The sort order. Valid sort orders are as follows, where
Custom is the value list name:
Optional with: –find or –findall requests
Requires: The –sortfield parameter
Example:
FMPro?–db=employees.fp5&–format= –fmp_xml&
–sortfield=First+Name&–sortorder=descend&–find
Keyword (short) Keyword (long)
FileMaker Pro
Equivalent Operator
Ascend Ascending Sort a to z, –10 to 10
Descend Descending Sort z to a, 10 to –10
Custom Sort using the value list associated
with the field on the layout