Hi,
I cannot find the empty search option in grid and form applications. All records are retrieved when no filter is set. I do not want to use the required field/s since it would limit the search flexibility…
That’s by design … Change your select statement and you have what you want.
I don’t understand your answer RHS. How am I supposed to change my SELECT statement? If I include a WHERE clause for a condition that doesn’t exist, in an effort to prevent my users from pulling back 7000 records, then none of my Advanced Searches will work, because the SQL contains a condition that will never resolve to true. What was wrong with the simple setting that disallowed this from happening? We are beginners in this forum, we need simple choices and if you say “change …” then you should include a sample code snippet.