privacy_profile and userlists

I have published a user list that contains profiles that have the privacy_profile field on "private". These profiles are not published on the user list but it seems that this is not taken into account in paging.
For example, pages 1 and 2 are empty, while on page 3 the first profile is published with privacy_profile on "public". I've tried to filter this out but this field is not available for filtering?

Unfortunately there's no way around that at this time. CB Privacy simply removes their rows from the row sets. It's not able to recount and redo paging to avoid this. Privacy at this time can't extend the userlist query to pre-filter them from the results avoiding this issue, but will be looking into fixing that in a later release as some of the privacy controls can be used in queries easily. The below Advanced filter for example should remove anyone with their profile set to Private and help with the issue some.


The below can be used if you only want to display users who set their profile to Public.

Thanks Kyle,

For me this should be OK for now. Unfortunately this query returned an error: "1054 Unknown column 'p.type' in 'where clause'".

Fixed the queries. Please give the updated queries above a try.

Error is gone now. Like you said, without a recount and redo paging the result is the same as in the basic filter. So now i've disabled paging and added the possibility to search for profiles in the list. Looks like the best option for now.

So you still have paging issues even after filtering out private profiles? That should remove the majority of problem rows. Some privacy rules just won't be able to extend the query very well, but I've a feature ticket to implement extending the userlist query as best as possible.