Yan Naing Oo:
HI all,
I just want write a query for which users are in the specific organisation roles ? what table should I have to join the table ?
I just want similar example as below
User Name Organization / Community Role
John doe - Marketing Dept - Organization/Community Administrator/Reviewer etc
thanks
Hi Yan,
If you want to link the user_ and organization table this is the query to do it :
select name,type_ from lportal.dbo.Organization_ where organizationId in
(select organizationId from lportal.dbo.Users_Orgs where userId in
(select userId from lportal.dbo.User_ where userId=11135))
to get specific role you might need to link the query above with 'role_' table through the companyId
the username you got to specify to get the exact specific role
Regards,
Hery
