This content has been marked as final. Show 3 replies
I thought the white paper at least mentioned OR conditions, but perhaps it doesn't go into enough detail.
You have two choices.
1) Scan all records and filter them using the two conditions.
2) Do two queries, one for each condition, and union the results.
In other words, there is nothing built-in that helps you with this. You have to implement the query yourself. And you have to decide which approach will perform best, preferably based on testing.
For example, a full scan (option 1) can be very expensive if you have a large number of records, so option 1 is usually more expensive than option 2. But on the other hand, if the majority of all records qualifies (will be selected by the query), then a full scan may be the most efficient option.