Display different datagrid columns based on selected filter value

Hello, I would like to have a datagrid that shows some data from the database. The grid has some filters too (choice filter) that should not only filter the data, but also change the displayed columns. For example, let’s say the list of all table columns are:

• ColumnA
• ColumnB
• ColumnC

And the filter values are:

• FilterA
• FilterB

The first column must always be shown, regardeless of the filter value. If I choose FilterA, then only the columns ColumnA and ColumnB should be visible. If I choose FilterB instead, only columns ColumnA, ColumnC should be visible. Is it possible to do something like this?

Topic

[Artem LiubeznyiSpectator]

Hi Stefano,

Looks like grid views might solve your case.

[Yevhen ShyshkinParticipant]

Hello.

Grid views allow you to save different grid states under some names.

If you require more flexible or dynamic logic – you should do that on JavaScript level. You can add your JS datagrid builder and put there your logic – e.g. you can listen to collection event (beforeFetch or sync), read collection’s state and show/hide some columns depends on filters value (see renderable option of a column).

[Author]

Replies