Custom Web Publishing Guide

Appendix A
|
Valid names used in query strings 99
–skip (Skip records) query parameter
Specifies how many records to skip in the found set
Value is: A number. If the value is greater than the number of records in the found set, then no record is
displayed. The default value is 0.
Optional with: –find query command
In the following example, the first 10 records in the found set are skipped and records 11 through 15 are
returned.
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–skip=10&–max=5&–findall
–sortfield (Sort field) query parameter
Specifies the field to use for sorting
Value is: field name
Optional with: –find or –findall query commands
The –sortfield query parameter can been used multiple times to perform multiple field sorts. The syntax for
specifying the precedence of the sort fields is:
–sortfield.precedence-number=fully-qualified-field-name
where the precedence-number in the –sortfield.precedence-number query parameter is a number (starting
with 1) that specifies the precedence to use for multiple sort fields.
In the following example, the dept field is sorted first, and then the rating field is sorted. Both fields are sorted
in ascending order because the
–sortorder query parameter is not specified.
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=performance&–sortfield.1=dept
&–sortfield.2=rating&–findall
–sortorder (Sort order) query parameter
Indicates the direction of a sort
Value is: The sort order. Valid sort orders are as follows, where <value-list-name> is a value list name such
as
Custom:
Optional with: –find or –findall query commands
Requires: –sortfield query parameter
Keyword FileMaker Pro Equivalent Operator
ascend Sort a to z, –10 to 10
descend Sort z to a, 10 to –10
<value-list-name> Sort using the specified value list associated with the field on the layout