In a Support category discussion regarding Trust Levels, stephtara asked how to view members who are specifically TL1, noting that the standard group view includes all higher levels. NateDhaliwal initially suggested using Data Explorer. chapoi confirmed that while not immediately obvious in the UI, it is possible using a specific Data Explorer query to filter by trust_level. JammyDodger provided a simpler alternative: navigating to the Admin Dashboard to the “Users per Trust Level” section, where clicking on TL1 reveals the list. stephtara thanked JammyDodger for the solution. The group then briefly discussed the utility of the Data Explorer for more complex queries, with JammyDodger and stephtara agreeing that mastering these tools is valuable once the basics are understood.
I went to look at the groups in my community to see who amongst my members was TL1 and not yet TL2, but there doesn’t seem to be a simple way to do that – am I missing something? Seems like it would be helpful (viewing the members of the TL1 group doesn’t give very useful information as it also contains everybody in the TL above TL1!)
Thanks for any tips.
Perhaps some Data Explorer query?
I think at the moment that’s impossible in the UI. Turns out it is, in a roundabout way – Discourse secrets
A data explorer query like this should work:
-- [params]
-- int :trust_level = 0
SELECT id as user_id from users where trust_level = :trust_level
Thanks, that’s what I needed!
Who would have thought it would be in the Users per Trust Level section 
As long as one knows such section exists! 
Very true. Everything is much easier when you know the answers.
Though I’m also a big fan of data explorer. You might find the inbuilt lists don’t have all the info you want, and that can be where a custom query could come in really handy. 
I’m certain I will be too in time, once I’ve got all the basics sorted out!
