Displaying data on any element using a WHERE clause

Can’t we view information with a certain condition/restriction like in SQL?


VIEW name
WHERE job_id = ‘IT Admin’;

This is to display people from the DB that work only as IT Admins.

This should be possible with filtered advanced option? I don’t know any way from the database except for typing in the search field.

You can also use a plugin that connects to the database.

Thank you for the response, I will try out your suggestions.