Not sure why Filters wouldn’t work? They are used to limit the amount of data pulled to Realm Cloud to perform your Rule function. Also, you may want to investigate adding an index to your collection to speed up query performance.
Have you taken a look at the query profiler to see how the query is performing?