Hi experts,
Request suggestions on the below scenario.
Need to implement an user filter on a record type object, with logic including multiple columns of the table being queried.
userFilter condition : column1 = value1 AND column2=(value2 OR value3)
Presently using a!recordFilterList.
Thanks
Discussion posts and replies are publicly visible
Unfortunately it isn't possible to create a user filter that has a complex filter like a!queryLogicalExpression(). One option you have is to create a database view that combines those two columns into a single field and filter on that combined field. Also, is it possible to just create two different user filters (one for column 1 and one for column 2)?
Thanks Peter for the reply. I'll work on the view option and check.
Creating two different filters is something that I tried, but its not serving the requirement.