- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hello,
Group id stored in DB in this format - CD4B792D-06CA-6A82-416A-7C1758B0F839. You can directly put this id to query.
This is query for taking data by group name:
SELECT prin.COMMONNAME, prin.EMAIL FROM EDCPRINCIPALENTITY prin
INNER JOIN EDCPRINCIPALGRPCTMNTENTI gr ON prin.id = gr.REFCHILDPRINCIPALID
AND gr.REFPARENTPRINCIPALID = (SELECT prinGr.id from EDCPRINCIPALENTITY prinGr where pringr.commonname ='Group name');
Best regards
Views
Replies
0 Likes
Total Likes