Two filters in a form

[es@interga.it]

I want to insert two filters in a form

Form_Filter.jpg

[aducom]

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?

[es@interga.it]

The user must be able to filter the column "KW Linea" and "Area" ...

[jsbinca]

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

[es@interga.it]

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.

[aducom]

[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.

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.

[es@interga.it]

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

That's too complicated for me