Custom Web Publishing Guide

94 FileMaker Server Advanced Custom Web Publishing Guide
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