Custom Web Publishing Guide

86 Custom Web Publishing Guide
–script.prefind (Script before Find) query parameter
Specifies the FileMaker script to run before finding and sorting of records (if specified) during processing of
the –find query command
Value is: Script name
Optional with: all query commands, except –dbnames, –layoutnames, –process, and –scriptnames
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.prefind=myscript&-findall
–script.presort (Script before Sort) query parameter
Specifies the FileMaker script to run after finding records (if specified) and before sorting records during
processing of the –find query command
Optional with: all query commands, except –dbnames, –layoutnames, –process, and –scriptnames
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-script.presort=myscript
&-sortfield.1=dept&-sortfield.2=rating&-findall
–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