Announcement
Collapse
No announcement yet.
Two filters in a form
Collapse
X
-
Uhm... what do you want to do? YOu can easily add a ' and ' to the sql and filter your data in more detail. But is that what you need/want?Albert Drent
aducom software netherlands
scriptcase partner, reseller, support and (turn-key) development
www.scriptcase.eu / www.scriptcase.nl
-
In the SQL section of your form put a global variable in the 'Where Condition' field.
Make sure the variable always contains a valid where condition (onScriptInit).
Create a control application and place all the fields you need on it.
In the onValid event of the control application:
-Assemble the where clause for the sql statement and stick in the before mentioned global variable.
-Reload the form with JS: echo "<script>parent.window.location.href += '';</script>";
Place a button of type link on the form and call the control application in a modal window.
You could also place a second button on the form (which is only shown when the filter is active)
to reset the form.
That's it.
jsb
Comment
-
form_select.jpg
Have with Dynamic search found this solution, but so you have every time you open the application to add the fields.
These settings should be possible to save.
Comment
-
Originally posted by es@interga.it View Post[ATTACH=CONFIG]2305[/ATTACH]
Have with Dynamic search found this solution, but so you have every time you open the application to add the fields.
These settings should be possible to save.Albert Drent
aducom software netherlands
scriptcase partner, reseller, support and (turn-key) development
www.scriptcase.eu / www.scriptcase.nl
Comment
-
Originally posted by jsbinca View PostIn the SQL section of your form put a global variable in the 'Where Condition' field.
Make sure the variable always contains a valid where condition (onScriptInit).
Create a control application and place all the fields you need on it.
In the onValid event of the control application:
-Assemble the where clause for the sql statement and stick in the before mentioned global variable.
-Reload the form with JS: echo "<script>parent.window.location.href += '';</script>";
Place a button of type link on the form and call the control application in a modal window.
You could also place a second button on the form (which is only shown when the filter is active)
to reset the form.
That's it.
jsb
Comment
Comment