Custom Web Publishing Guide

Valid names used in query strings 83
Required with: –edit query command
Optional with: –new and –find query commands
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&-op=eq&FirstName=Sam&-max=1
&-find
fieldname.op (Comparison operator) query parameter
Specifies the comparison operator to apply to the field name that precedes the operator. Comparison operators
are used with the –find query command.
Value is: The operator you want to use. The default operator is “begins with”. Valid operators are as follows:
Optional with: –find query command
Requires: A field name and a value
The syntax for specifying a comparison operator is:
table-name::field-name=value&table-name::field-name.op=op-symbol
where:
1 table-name is the table that contains the field and is only required if the field is not in the source table of the
layout specified in the query string.
1 op-symbol is one of the keywords in the preceding table, such as cn.
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&name=Tim&name.op=cn&-find
You can use any FileMaker Pro find operator by specifying the bw keyword. For example, to find a range of
values using the range operator (...), you would specify the bw keyword and then you would place the
characters “...” before the search criteria.
Example:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=departments&IDnum=915...925&IDnum.op=bw
&-find
For more information on the operators you can use to find text, see FileMaker Pro Help.
Keyword FileMaker Pro equivalent operator
eq =word
cn *word*
bw word*
ew *word
gt > word
gte >= word
lt < word
lte <= word
neq omit, word