User list with pending, unapproved users only

Client doesn't want to use the normal approve/decline function until users are ready to be approved/declined but would like to see a list of users pending approval as a user list. This list will show other registration information etc.

I can't seem to find the correct filter to show them so is there a specific function or am I looking at a db query?

Thanks

Edit your userlist this under Parameters > Display ensure you've set the following.

Show Blocked: Yes
Show Unapproved: Yes
Show Unconfirmed: Yes

Next use the following Advanced Filter.

That should give you a list of unapproved users.

That works greatly. Thanks.

Sorry, how about including users with unconfirmed email addresses also?

Advanced Filters let you directly add to the userlist query. So you can use that to basically filter down to whatever you like. The _comprofiler table alias is "ue" and the _users table alias is "u". For unconfirmed you'd have the below.

Then combining the two so it shows for unapproved or unconfirmed you'd have the below.

Excellent. Works brilliantly.