You can find SQL CUSTOM WHERE parameter in Easy Profile Menu item settings.
- Go to Administration->Menus->Menu Manager->Main Menu
- Select the menu item for list of users
- Search SQL CUSTOM WHERE in list tab (or table tab if you use Table List menu)
With this method you can create many menu item with different users (example list of Male, list of Female).
As I am an non technical guy, can you explain me where in Sql database I have to write this code. Like SQL Database ---> abcd_modules ------> Easy Profile - User List.
And also how to write the code in the Params please.