How do I add more options to a Search facility?

[Philip_J]

I just recently put together a fairly comprehensive set of search filters and I'm really happy with the result.

This post might point you in right direction. One note though, I'm not using a data view, just a paged query being displayed in a table.

Can you have query conditions that are based on a form POST variable?

Ah i thought you want to do something on the server side only. In your case you will need to use GET vars then and don’t really need a form/submit. In App Conenct create a variable for each of the filter you want to apply on clicking the button. In Server Connect create a GET variable for each of the filters On the page, in the App Structure bind variable values to the server connect GET variables. Select the button, add new dynamic event - on click -> select your variable(s) and select Set V…

The essence though is I use input fields and checkboxes, that on input or save, set the value of a number of variables that are connected to the server connect query as GET parameters.

Then it's just a matter of nesting the conditions properly in the query.