Announcement

Collapse
No announcement yet.

Two filters in a form

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Two filters in a form

    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?
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


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

      Comment


      • #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

        Comment


        • #5
          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


          • #6
            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.
            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.
            Albert Drent
            aducom software netherlands
            scriptcase partner, reseller, support and (turn-key) development
            www.scriptcase.eu / www.scriptcase.nl

            Comment


            • #7
              Originally posted by jsbinca View Post
              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

              Comment

              Working...
              X