Avatar

Correct answer by
Level 6

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

View solution in original post