I have the following and dunno how to resolve it.
I want to filter record by Column A & Column B using OR condition. The output SQL should look like this WHERE ColumnA = 'xxx' OR ColumnB = 'xxx'
But the SETRANGE can only generate WHERE ColumnA = 'xxx' AND ColumnB = 'xxx' (not OR condition); SETFILTER is for the same column.
What is the best way to handle this?
Would greatly appreciate if anyone can help?