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?
Discussion posts and replies are publicly visible
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?
Yes Stefan. I agree on that and I do not want to use that scenario. I found the issue and I have fixed it.Thank you.
Would you mind describing the solution? Someone in the future might run into the same issue and you could help them.
It was a casting issue. I used touniformstring() and then used IN Operator and it worked.
Ah yep those casting issues are always tricky - thanks for following up!