Question regarding SAIL form filtering for grid with several columns

rishub356 over 8 years ago

hi,

I have a SAIL form with several columns. I want to add filters for each column on grid, where User can select values from dropdown of header that will have the values for filter. The values that User selects will be filtered in Grid. If nothing is selected, all the values will come up. Do we have this functionality in SAIL?

Discussion posts and replies are publicly visible

Parents

0 Sidhant Behura over 8 years ago

We do not have any OOTB functionality, but we can make one using query entities. An easy way is keep have a button after all the filters on clicking of which you can collect all the not null filter values and query the DB using a generic query entity and save the datasubset in the saveInto of the button. Then you can use this in the grid.

Attaching a sample report screenshot which uses this same scenario.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Sidhant Behura over 8 years ago

We do not have any OOTB functionality, but we can make one using query entities. An easy way is keep have a button after all the filters on clicking of which you can collect all the not null filter values and query the DB using a generic query entity and save the datasubset in the saveInto of the button. Then you can use this in the grid.

Attaching a sample report screenshot which uses this same scenario.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data