Default search in a Record.

Question

HI, 
I'm trying to use default search in an entity backed record. I want to show a list of records which are also stored in a different table on the grid. I tried to call the values in a local variable in Default filters(expression mode), and when I try to use the "IN" function,  I get an error saying "Cannot apply operator [IN] to field". So, I have used a for each and "=" function to achieve what I needed. Is this a good approach or do we have any other option to do it in Appian?

Note: I know it can also be done via a view and filter those in the backend. I would like to understand whether there is any other option that we can look into?

stefanhelzle0001 · Answer

Using multiple "=" instead of an "IN" is probably never a good idea as it increases load on DB. And the DB has a limit on values you can pass.

I would need more details. What data type is this field you want to filter on?

What do you mean with "I want to show a list of records which are also stored in a different table on the grid."?

Do you have some code snippets?

Sign up

Login with SSO

Login to the community

Login with SSO