Show Records filtered to usergroup

Hello everyone,

iam new to table jx, i tried to set up a userlist view, which Shows usernames adresses and so on. This is very simple an runs perfect for me, but i cannot figure out how to filter the view that only user from a Special usergroup are shown.

I searched for this in the Forum, read something about SQL View and phpmyadmin, i will trie to merge the two tables to a view which Shows the Profile of the user and the usergroupmap. I think i can do this, if i trie. But, how can i say to the tool jx grid, that he should only Show the users with the user_group id 17 for example.

Have you any idea how to do this?

Figured it out!

Its quiet simple, if you have the right type of mysql-view. You can filter it with the Additional Condition like this:

group_id = 17
(Table-field = oder <> Wert)