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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.