Skip to main content
S
swetas0001
August 18, 2022
Question

Query Record Type in a grid

  • August 18, 2022
  • 8 replies
  • 0 views

Hi Team,

We have a grid which shows data from record type where we pull data from DB table.

We have a column which is integer in DB table but in the grid we have shown the value with a text prefix. We want to search the grid with the value shown in grid.

Example -- In table the value is stored as 123, we are showing in grid as TXT123. I want to search the grid with the value "TXT123". While searching it does not show any value but with 123 it returns me the row.

Please let me know if we can search the grid with value TXT123 and how to do it. We would want inbulit feature of Appian grid search.

Thanks in advance

    8 replies

    harshitb6843
    harshitb6843
    August 18, 2022

    Hi, 

    What about creating a user filter with all of these distinct values appearing in a dropdown and then letting user choose one or many out of them?

    S
    swetas0001Author
    August 18, 2022

    Hi Harshit,

    Thank you for your reply!!

    Actually the table has huge data and it is dynamic. Every min rows get added. So creating user filter and showing in dropdown is practically not possible.

    Is there any other way to handle this?

    D
    deepakg681722
    August 18, 2022

    why not you are using QueryEntity into the interface and show the data to the grid. In that interface, create a dropdown field to show all the records to filter out the data by concatinating the TXT or XYZ value and Once user try to filter out use to integer to filter the data based on the selected value?

    Terms & ConditionsAccessibility statement