What is the syntax for query for non-empty fields?

[dmichael]

The documentation in FileMaker says to use a *, but using a start for a field does not seem to do what I think it would. What then is the syntax for finding all records where a field is not empty? Thanks!

http://www.filemaker.com/help/12/fmp/html/find_sort.5.10.html

[ginjo]

The star character should work, but I usually use the equals '=' character to omit all records with nothing in the field. In Rfm, that would look like this...

Reservation.find(:some_field => "=", :omit => true)

I do remember, long ago, having some issues with the star technique, but I don't remember why.

You might also double-check your request logic. If you have multiple find requests in a single find operation, remember that 'omit' requests will filter preceding requests. So something like

Reservation.find([{:some_field => '*'}, {:some_field => "b",  :omit => true}])

will find all records with something in some_field, unless some_field contains a word starting with 'b'.