How to join the table between user and usergroup
Dear Sir
I want to know how to use sql to join the table between agileuser and usergroup, can any one help me? I can’t use API because the other system need our system to use. I search the much table but I can’t find their relationship.
Best Regards
Tony
select u.loginid, ug.name from agileuser u, user_group ug, user_assignment ua
where u.id=ua.user_id and ua.class=11885 and ua.objectid = ug.id;
Basically, USER_ASSIGNMENT holds the sites, user groups and roles that are assigned to a user. USER_ID links to AGILEUSER.ID, CLASS is how you determine which of the 3 is being referenced (11885 = user group, 11640 = roles and 11760 = sites), and then OBJECTID is the ID of the referenced object, as in, what is the ID of the object that is linked to the user.
