Paged list of filtered users
I am trying to display a paged list of users which includes only active, non-blocked, and good emails (per Kickbox). I can filter in the db query with 'user_active = 1' but if I try to include the other conditions (e.g. 'user_blocked != 1') the resulting join fails since the key 'user_blocked' is sporadic.
I have attempted to use a db_search_items_listener to perform the remaining filters but unfortunately this is triggered after the count is determined. Thus when I filter out the bad users (violating the count), the content runs out before the paging logic thinks it should.
I need a way to filter the content before the paging metadata is determined.
Looks to me as though there is no way to filter content in a paged display unless the filtering is done upfront in the db query itself. Is there a way to do this?
updated by @tig: 01/23/24 01:14:50AM