How to hide a row in a grid based upon condition

Question

Hi All, I have a scenario, say, for example, I have 20 rows in the paging grid, based on a condition I need to hide a few of the rows in a Grid.

snbanavath · Answer

You can apply filters while getting data either from a database or a record type for the "data" parameter of the a!gridField() component. You can specify the desired condition in filters. If this doesn't seem like what you want please drop some specific queries :)

snbanavath · Answer

If you look at the code in the image above, I have applied filters to avoid rows which I don't want to see in my paging grid. In this case I want the rows in which the startdatetime is between gtStartDateTime and ltStartDateTime. see the paging grid tutorial here for more reference to build the grid https://docs.appian.com/suite/help/22.3/Paging_Grid_Component.html and also have a look at this to see more about filtering data from a!queryEntity or a!queryRecordType, filters works in both the functions in a same way. https://docs.appian.com/suite/help/22.3/fnc_system_a_queryfilter.html

How to hide a row in a grid based upon condition

Top Replies