You’re on the right track with your current approach.
In IIQ, QueryOptions only supports filtering on indexed and top-level attributes of the object model. Unfortunately, attributes like approverSpecific1 (which are typically stored in the attributes map of a ManagedAttribute) aren’t directly filterable in the query itself.
Thank you, that is what I figured.
This in itself is an optimization process to populate a custom object with information regarding workgroups, their members and what entitlements they are assigned to. So this task will be running quite sparsely, the performance will likely not be a big issue.
I’ll stick to filtering on requestable for now, and if it turns out it takes way too long time, I’ll think of optimization concerns at that point. Thank you