Dynamicaly Filtering a grid

Applications Grid / Reports
#1

Hopefully someone can point me in the right direction before i explode :frowning:

I have a grid and i’d like my user to be able to filter the grid based on fixed criteria E.G ‘SHOW ISSUED’, ‘SHOW RETIRED’ etc.

So I thought why not put a block with some checkboxes, but it seems this can’t be done on a grid.

Now for me this is pretty fundamental to a grid.

Is this even possible ? if not then i’ve pretty much wasted my time with scriptcase and will have to go back to doing everything by hand.

Any and all help appreciated.

#2

You can do it with the module search. in GRID MODULES set INITIAL MODULE to GRID.
Then in SEARCH Set your criteria.

#3

Thanks for the reply.

Yes this does work but it requires A. the user to enter information and B. the user has to know the information to use as the filter which in this particular case is the status of a document and the exact wording of how that is recorded in the database.

What i’d like to do is filter on set information by turning a checkbox on or off, thus making the application of the filter idiot proof. :slight_smile:

Cheers

#4

Look at the refined search option.
Maybe this is the solution for you?

https://www.scriptcase.net/samples/php-reports/refined-search/

https://www.scriptcase.net/tutorials/using-the-refined-filter/

#5

Thankyou rik.

Refined search will very nearly do as I want, but is there a way to apply an initial filter automatically at start up ?

#6

DONT forget to enable the footer in LAYOUT/header&footer. Otherwise it won’t work