Getting groups and father group

[Former Community Member]

Hi!!

In my process:

1. I need get the group name given a username (userId)

2. If I have the groupName I can get the Father group name, right?

3. If I have a father group name I can get the member of a group. right?

Well, I can't find the operations that I need for to do my algoritm to assign task.

Somebody can Help Me ?

Thanks a lot

María

[Former Community Member · Accepted solution]

Hi Maria,

you can get the group name from userId.

For this you have to access the Adobe database.

select refparentprincipalid from EDCPRINCIPALGRPCTMNTENTI where refchildprincipalid  = "userID"

The output for this would be refparentprincipalid.

Now,

select commonname from EDCPRINCIPALENTITY where id = "refparentprincipalid"

This will give you the group name.

Hope this will Help.

Regrads--

Chalukya

Message was edited by: chalukya

[grndragon]

You can retrieve group members via the operation findGroupMembers in the

User Lookup service. No similar operation is available for retrieving parent

group so you may need to search the database directly via the JDBC service.

[Former Community Member]

Thanks a lot... then with those 2 tables I can get all information about group and parentgroup?

Thanks

[Former Community Member]

Thanks... Is recommended access database ?

[Former Community Member]

Hi,

No harm in accessing the Adobe Database, but dont not modify any data.

All the Best.

Regards--

Chalukya.

[Former Community Member]

Thanks a lot