Home

How to join the table between user and usergroup

Answered

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

Agile User Asked on November 27, 2015 in Agile PLM (v9),   Product Collaboration.
Add Comment
Cancel
2 Answer(s)
Best answer

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.

Cancel
Agile Angel Answered on November 28, 2015.
Add Comment
Cancel

Dear Kevin

Thanks a lot for your support. 
Your answer can satisfy our requirement.

Best Regards
Tony

Cancel
Agile User Answered on December 2, 2015.

MyAgilePLM

Hi Tony,

Can you please use the voting system and mark the question as “answered”? This will allow everyone to see this question was answered to your satisfaction. 

MyAgilePLM team

on December 2, 2015.
Cancel

tonyyu

Got it, thanks a lot for your mentioned.

on December 3, 2015.
Cancel
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.