[pilot-db-list] Query for usage tips

[Craig B. <sys...@ca...>]

I'm sure enjoying the power and flexibility of the filters, sort, global
scripts, calculated fields, et al...

But a query for how others might be handling a few issues I'm struggling
with.

How might one filter out, or filter for records based on empty string
fields?  Other field types I have no problem with, but I'm not sure what
the pilot-db equivalent of null quotes would be.  And one can't seem to
be able to turn it into an integer with INT and query on a zero or
non-zero value, at least at this point with the intended functionality of
INT thus far.  Does anyone have filter examples for all records where a
string field is empty, and for all records where a string field is
non-empty?  I'd prefer not to have to resort to an extra boolean field
just for this purpose.  Or an extra non-visible string field than I could
perhaps do an SEQ comparison with.

Lastly, does anyone have any tricks for determining Field numbers quickly
for use in filters and sorts?  The only way I see is to pop into the Edit
Database Design.  If there isn't an easier way that I've been
over-looking, I wonder if it might be a useful header in the Sort popup
when a field column is tapped on, or maybe an addition to the Report
Plugin available from the same pop-up.

Am I missing the obvious in these?