Expand my Community achievements bar.

AEM 6.0 User Report - Adding a generic column to the report

Avatar

Community Advisor

Hello..

I am trying to set a generic column to userreport page. To the generic column, while setting the properties, the 'Type' option provide four dropdown options (String. Number, Integer, Date). This column is supposed to be based on property under profile node which is a type 'Boolean' (Eg: isPlayer - Boolean - true. This property is set under profile node of user)

If I look at https://docs.adobe.com/docs/en/aem/6-0/develop/operations/dev-reports.html#User Report under 'COLUMN SPECIFIC DEFINITIONS' I see there are other available options(diff, sortable etc) that I could use if I overlay the 'genericcol' node under 'userreport' folder. But still there is no option where I could set the property type as boolean. 

I tried selecting String (and other options too) but in that case under the newly created generic column I do not see the result updated after pressing finish. 

Apart from the option of changing the property isPlayer type to String itself under profile node, is there any other option that can be used in this scenario?

Thanks 

1 Reply

Avatar

Level 4

Looks like this option is not available. If you want to create reports that contain JCR data, you can build a custom Excel service and write out the data to Excel. This option gives you way more control and flexibility. See: 

https://helpx.adobe.com/experience-manager/using/aem-reporting-service.html