I understand your answer, and I acknowledge it is possible to do so. Maybe I haven’t explained myself well.
As far as I know Secondary Index are made using B-trees, as seen in https://www.aerospike.com/docs/architecture/secondary-index.html . Therefore it is very quick to access them.
I use your approach,I would be filtering the first set of records using the Secondary Index in the query, but the remaining records will be filtered one by one by inside the UDF. However, you have to go through the whole set.
If you are able to use two Secondary Indexes in your filters you wouldn’t have to go through the first subset fully. Am I correct?
Also, I think it is very confusing to provide a method in Java allowing multiple filters to be passed when only one of them works. I started developing a solution using multiple filters only to find out in forums that they don’t work yet. If the method only accepted one filter and then later a new method for multiple filters is added, it would not be so confusing.
Thank you for your reply.
EDIT: In my previous comment I was also asking if you know about the time-frame for this function to be implemented. Is there any approximate date available for this?