Skip to main content
October 28, 2022
Question

How to hide a row in a grid based upon condition

  • October 28, 2022
  • 4 replies
  • 0 views

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.

    4 replies

    harshitb6843
    October 28, 2022

    Filter the data in your query entity and directly get only the desired data?

    sunilnaikb0002
    October 28, 2022

    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 :)

    October 28, 2022

    Hi Snbanavath,

    Can you please elaborate,

    can you provide some sample codes that could be helpful

    sunilnaikb0002
    October 28, 2022



    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