I want to create a filter (or select) with optional user inputs. The issue is the optional nature of the user input.
I can easily create a filter where the user must put in a value. The issue is where I have several parameters and I want to make some of them optional.
For example I would like to filter a maintenance job database on one or more of the following parameters: Job assigned to (person name), site (name of location), Open (job open or closed, ie Yes / No), Start Date (input begin date range for due date of job), and End Date (input end date for due date of job).
If I force all to be input filter (or select) works fine. If I leave them optional it is an issue. How can I build a filter condition on the fields with data in them and leave out from the filter where there is no user input?