Let’s say I have some filters for Name, UserID and Daterange (two popup calendars). I also have some check box components I want to use to enable/disable these filters. I have a table to display the resulting dataset. I can write the sql so that it resolves any of the above in the where clause.
How can I dynamically change my sql statement when I toggle the check boxes on or off?