Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Getting groups and father group

Avatar

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

1 Accepted Solution

Avatar

Correct answer by
Former Community Member

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

View solution in original post

6 Replies

Avatar

Correct answer by
Former Community Member

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

Avatar

Level 2

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.

Avatar

Former Community Member

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

Thanks

Avatar

Former Community Member

Hi,

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

All the Best.

Regards--

Chalukya.

The following has evaluated to null or missing: ==> liqladmin("SELECT id, value FROM metrics WHERE id = 'net_accepted_solutions' and user.id = '${acceptedAnswer.author.id}'").data.items [in template "analytics-container" at line 83, column 41] ---- Tip: It's the step after the last dot that caused this error, not those before it. ---- Tip: If the failing expression is known to be legally refer to something that's sometimes null or missing, either specify a default value like myOptionalVar!myDefault, or use <#if myOptionalVar??>when-present<#else>when-missing. (These only cover the last step of the expression; to cover the whole expression, use parenthesis: (myOptionalVar.foo)!myDefault, (myOptionalVar.foo)?? ---- ---- FTL stack trace ("~" means nesting-related): - Failed at: #assign answerAuthorNetSolutions = li... [in template "analytics-container" at line 83, column 5] ----