Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Report Select Parameter Dynamically by Query

joe_s66
Level 3
Level 3

I'm creating a new content report in ACS AEM commons and I'd like to utilize the "Report Select Parameter Dynamically by Query" component. Specifically I'd like to query all the content authors under " /home/users" and display their name in the dropdown with their rep:authorizableId as the option value. Thanks for any tips.

1 Accepted Solution
Albin_Issac
Correct answer by
Community Advisor
Community Advisor

You can try something like below

Search Parameters - "ACS Commons Report Builder Select Parameter Dynamically by Query"

Label - User Id

Name - userid

Query Language - JCR SQL2

Dropdown Query - SELECT * FROM [rep:User] AS user WHERE ISDESCENDANTNODE([/home/users])

Allowed Property Names: rep:authorizableId

acs-commons-report.png

Configuration:

Query - SELECT * FROM [rep:User] AS user WHERE ISDESCENDANTNODE([/home/users]) {{#if userid}} AND [rep:authorizableId] like '{{userid}}' {{/if}}

Query Language - JCR SQL2

Page Size - e.g. 50

 

acs-commons-report.png

Configure the required Result Columns

Regards

Albin I

www.albinsblog.com

View solution in original post

2 Replies
Albin_Issac
Correct answer by
Community Advisor
Community Advisor

You can try something like below

Search Parameters - "ACS Commons Report Builder Select Parameter Dynamically by Query"

Label - User Id

Name - userid

Query Language - JCR SQL2

Dropdown Query - SELECT * FROM [rep:User] AS user WHERE ISDESCENDANTNODE([/home/users])

Allowed Property Names: rep:authorizableId

acs-commons-report.png

Configuration:

Query - SELECT * FROM [rep:User] AS user WHERE ISDESCENDANTNODE([/home/users]) {{#if userid}} AND [rep:authorizableId] like '{{userid}}' {{/if}}

Query Language - JCR SQL2

Page Size - e.g. 50

 

acs-commons-report.png

Configure the required Result Columns

Regards

Albin I

www.albinsblog.com

View solution in original post