Is your question answered, if yes then please verify the answers that helped
Thanks, Layan Jweihan Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
I assume you edited the question because now it's clearer.
let's assume your AOT query has table1. And you want to filter on field1 or field2.
what you need to do, is just add a range for one of those fields only. Let's say field1, then in the range value fill it with this: ((Field1 == "123") || (Field2 == "ABC"))
each range needs to be in parenthesis, and you can add more than one field in the range value even though you only added range for field1.
Try it and it will work
Thanks,
Layan Jweihan Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future