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
Discussion posts and replies are publicly visible
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?
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?
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?
Hi Deepak,
Thank you.
We have some record actions to be performed on that grid and also we have record views for the same. So, we cannot go for query entity feature.
Then another way to do it is by adding a new column in the table and storing the exact value you would like to filter on. Do not show this column on the front end but only use it for filtering. BTW, are the prefix different for every value?
As of now the values are same but may be different.
Is there no in-built function of appian with which we can do this? Like if we don't have the option of adding any new column then can't we meet the requirement?
I'd suggest using Custom Record Fields - this allows you to concatenate extra text to create a field that you could search on. Then, just use the out-of-the-box search box and you should be able to find it!
Hey Peter,
Thank you for your response.
With custom record fields, I can do the searching but the issue is Custom Record Fields are enabled only when Record Type's DB Sync is enabled. We can not enable the sync as our rows would be more than 1,000,000 and also we have fields where character limit exceeds the prescribed character limit of 4000 for enabling data sync.
So this would not work as a solution for us.
Can we have any other workaround for resolving the issue like if we can have the custom record field enabled even if DB sync is disabled in Record type?