Usage of Operators

[mtozlu]

Hi,
Thanks for this great gem. It has helped me save (and possibly many developers worldwide) weeks (possibly months) of coding time.

I would like to find records in FM server that have a date field greater than my value.
How can i achieve this?
It is stated in FM XML documentation that you send the "field.op" as query string. Here is a passage from docs:

For example, the following request searches for values greater than 100,000 in the “Salary” field
on the “Budget” layout. The resulting data is displayed using the “ExecList” layout, which does not
include the “Salary” field.

http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees
&-lay=Budget&Salary=100000&Salary.op=gt&-find&-lay.response=ExecList

In RFM i can only use ".find(:field => value)". How can i use comparison operators?
Thanks.

[mtozlu]

Actually i have experienced that one can send operators in the current rfm like this:

MyLayout.find({'my_field' => '1000', 'myfield.op' => 'gte'})

This would fetch all records that have "my_field" value greater then or equal to 1000.
Other operators can be found in FileMaker Custom Web Publishing documentation. You can also find not null, null, etc. other records. All of them are documented in FileMaker.

But again, it would be better to just write

MyLayout.find('my_field >= 1000')