Report Select Parameter Dynamically by Query

[joe_s66]

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.

[Albin_Issac · Accepted solution]

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

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

Configure the required Result Columns

Regards

Albin I

www.albinsblog.com

[joe_s66]

Thanks Albin. Also useful blog post.