Advanced Filtering on a Datagrid

Vivian shared this question 6 years ago
Answered

I want to create a datagrid that does the advanced filtering like they have in excel for a column. Any suggestions on how to build this to look authentic? a19acfdfe0b302dca64bd688db3d645e

Comments (8)

photo
1

You mean something like in this example http://www.justinmind.com/prototyper/... it's the one called 'Design Patterns'.

photo
1

Hi Victor, Not exactly, I would like to do multiple selections like Volkswagon, Ford and Chrslyer would all be selected.

photo
1

On another point it does not have to be a data grid it could be a container with a table

photo
1

Oh sorry. Then I'd use a check box group widget with the options, mark it as hidden and show it when the user clicks on the drop down. Then define an onchange event on the check box group that hides/shows the desired values on the table.

photo
1

Victor, thank you for your explanation, but it left out the most important part; how do you filter out the 2 or more selected checkbox items from the datagrid?


I'm only able to filter one selected checkbox.


Multiple selection clears out the datagrid totally meaning it doesn't work.

photo
1

Hi Markku,


Instead of filter the datagrid by one attribute that has some checkbox selected, you have to filter the datagrid by some checkbox selected has the attribute. Take a look to the image.


777d53202af6f5eaf15be647f8d229a1


I hope it helps.

photo
1

This really helped, thank you!

photo
1

Should someone need a more thorough textual explanation, here is what Albert wrote to me.


- - - - - - - -


Select the checkbox list and create an "on change" event. Select "set value" action and select the data grid. Then, click on calculate.


Drag the filter function into the expression builder. On the first field drag the name of the datamaster and on the second one drag the text fuction "has". On the left of "has" drag the checkbox list and on the right the attribute of the datamaster.


- - - - - - - -