Report Select Parameter Dynamically by Query

joe_s66

17-09-2020

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.

Accepted Solutions (1)

Accepted Solutions (1)

Albin_Issac

MVP

17-09-2020

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

Answers (0)