Announcement

Collapse
No announcement yet.

Dropdown Filter

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

  • Dropdown Filter

    Any examples or DOCs on how to implement a dropdown filtering ?
    I woul like to have a dropdown on a toolbar with some pre-defined values, so the user can select from the list , then the grid would filter accordingly.

    Arthur
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    this would be in a Grid? If yes, use the Quick search application and then set the fields you want to filter...

    Comment


    • #3
      The problem is that the filter must work without user entering any data but rather selecting.
      Another words thewre should be a list of items in a dropdown list, and only this list (nothing else could be used for selection). Better yet if this list would be provided as a lookup from another table

      Art
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment


      • #4
        In this case would create an app custom control and would do anything, then it would create a label and turned it into an iframe calling app control. Will be too much work.

        Comment


        • #5
          Why not just add a dropdown with your filter in it, create an ajax onchange event on it, fill a global variable with the select depending on the selected item and do a sc_redir to the same application. Add the global variable to the where clause. After you select a new value from the list and fill the filter to the global variable the form is reloaded and the sql with your global where clause get's executed.
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment


          • #6
            thanks 'aducom'
            I will try and test your suggestion

            I wonder also if there is a way to display more than one column in a SELECT type drop down list.
            I see when I do this in SC, then the drop down selects values from both columns and combines them into one string (which is not what I want).
            For example I want to lookup a product list and see the list in 2 columns (i.e. ProductCode | ProductName), but after the selection I want ony the ProductCode selected into the field

            Arthur
            -----------------------------------------
            Arthur Klisiewicz
            dATA POINT SOFTWARE
            www.datapointsoftware.com

            Comment


            • #7
              Yes, I would like that too, but it's a html issue. You don't have a drop down in columns. But in this case you can consider creating a modal caption link. This can be a grid and that has columns.
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                Hi, since I have the same wish, I found this page via Google. I follow the suggestion of aducom, that works, thanks a lot. My question is: can I open the grid in iframe under the control app?

                Comment


                • #9
                  in some sense you can, but when I have had an App with Tabs the method for selecting using Modal Window doesn't work very well because the scrolling is screwed up. If you have no Tabs on the form it works fine.
                  Arthur
                  -----------------------------------------
                  Arthur Klisiewicz
                  dATA POINT SOFTWARE
                  www.datapointsoftware.com

                  Comment


                  • #10
                    Hey Alber - have you done something like assigning a local Var from dropdown list ?
                    I have 2 fields on the FORM
                    1. Country
                    2. Region

                    I also have 2 tables
                    1. Countries (ID, Country)
                    2. Regions (ID, Country, Region)

                    I want on this same form allow user to select Country then when opening Regions dropdown filter only regions for that particular country.
                    I think this is pretty common behavior. I'[m not sure however where to go to assign Country to some Var so I can filter Regions later... ?

                    Arthur
                    -----------------------------------------
                    Arthur Klisiewicz
                    dATA POINT SOFTWARE
                    www.datapointsoftware.com

                    Comment

                    Working...
                    X