Two filters in a form

Applications Forms
#1

I want to insert two filters in a form

Form_Filter.jpg

#2

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?

#3

The user must be able to filter the column “KW Linea” and “Area” …

#4

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

#5

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.

form_select.jpg

#6

[QUOTE=es@interga.it;39417]

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.[/QUOTE]

That would be nice indeed but currently not possible. But if these two fields are the only one you can easy setup a form containing these and use the method described here above.

#7

[QUOTE=jsbinca;39416]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[/QUOTE]

That’s too complicated for me