Extend ep_user_query_db_args filter

[yarovikov]

Is your enhancement related to a problem? Please describe.

Hi there.

Is it possible to add WHERE ID IN ($placeholders) for SQL Query here depends on args (ep_user_query_db_args filter)?

https://github.com/10up/ElasticPressLabs/blob/develop/includes/classes/Indexable/User/User.php#L647-L653

The problem is i'v got > 1 000 000 users, but i need only 10k in the index based on some postmeta value. Each time a full indexing is performed, it takes several hours 😅

Designs

No response

Describe alternatives you've considered

No response

Code of Conduct

• I agree to follow this project's Code of Conduct

[felipeelia]

We could introduce two filters there: one to short-circuit the entire function if people already know the IDs they need and another to filter the SQL query directly.

[yarovikov]

@felipeelia sound good. actually currently i don't need that because i use full index to get count of each role. But i think this would like useful option in the feature