It seems that quick find is case sensitive when working with an ess table. Is there a way to change this? If I type "boat" I'd like it to return records with "boat" or "BOAT" or "Boat"
Ok I found a solution that works. I created an extra calculation field that converts the field in question to lower case. I then added this field to the form. Then under 'Hide Object When' I then added 'not isempty (somefieldnonnull)'. So now the field won't display on the form but will work in the quick find.
If I recall correctly, there's a setting in SQL for whether to do case-insensitive searches. I'm not positive, but I have a vague recollection of encountering this setting in Oracle. I also vaguely recall that FM will respect the settings, in effect, because the SQL database will apply the search using the SQL configuration.
All pretty vague recollections, so I apologize if this doesn't answer your question, but since it's been a few hours since you posted, perhaps this meager contribution will give you something to try?
Which DBMS are you using with ESS (i.e. MySQL, Oracle, Postgres, etc)?
I'm using Postgres
Is it possible to include an option in the ESS driver so that the SQL operating behind the scenes is using something like the lower function or if easier the ILIKE expression (although there would likely be a performance hit with the latter). It looks like I could install the CITEXT module to provide a current workaround but I'd rather not as it complicates matters if I need to port to another machine.
I just tried using the CITEXT module with postgres. Works fine in postgres but not with the ESS driver. No difference in the search results being returned.
Then under 'Hide Object When' I then added 'not isempty (somefieldnonnull)'.
Small point, but you could just set the Hide When to 1. This evaluates as "true" and will always hide, so you don't need to unnecessarily reference a field.
Good point. I was stuck in the box thinking it had to directly access a field on the form. Thanks
You can put the field for quick find on outer area right side edge of layout, it never be shown.
Retrieving data ...