I created the following query, but I can not make it work.
SELECT user.*, group.* FROM [rep:User] AS user
INNER JOIN [rep:Group] AS group
ON ISDESCENDANTNODE(user, [/home/users])
WHERE user.[jcr:uuid] IN (group.[rep:members])
and user.[rep:principalName] = 'usertest'
I get the following error: expected: static operand.
Regards,
Isrhael
Solved! Go to Solution.
Views
Replies
Total Likes
No worries, try below:
select * from [rep:User] as user inner join [rep:Group] as group on user.[jcr:uuid] = group.[rep:members] where user.[rep:principalName]="usertest"
Views
Replies
Total Likes
Hi,
You can do it without SQL-2.
with ResourceResolver
request.getResourceResolver().adaptTo(User.class).memberOf();
aem63app-repo/SimpleGetGroup.java at master · arunpatidar02/aem63app-repo · GitHub
Views
Replies
Total Likes
Thank you very much, but it is a requirement that is using SQL-2.
Views
Replies
Total Likes
No worries, try below:
select * from [rep:User] as user inner join [rep:Group] as group on user.[jcr:uuid] = group.[rep:members] where user.[rep:principalName]="usertest"
Views
Replies
Total Likes
This worked very well for me! Thank you!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies