ACS AEM Common Report Builder: Add report column with value of "NOW"

Question

Anyone know how to add a column to the output of a ACS AEM Commons Report where the value of the output column is based off the current date, not off the returned data. The reason why i need this is I'm using the report excel output as input to a SQL database and I plan on running this report monthly and want to be able to distinguish between runs so adding a "Report Date" field to the output would be the easiest way. I know i could add it during the ingest, but it would take more work then just adding it to the default output from AEM.

I tried adding a "Report Date Column" with:

Heading: Report Date

Property: now()

Date Format: dd-MM-yyyy

But that just resulted in an empty column. I also tried another suggestion of "Property = currentPage/jcr:createDate" with the same result. Any help would be greatly appreciated

Saravanan_Dharmaraj · Accepted Answer

@shaggyspfld It looks like you need to write the custom code to extend the report column functionality.

please check this documentation for adding new column(Creating a Report Column)

https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/extending.html

Example given in code: https://github.com/Adobe-Consulting-Services/acs-aem-commons/blob/6e88e55789ed72cd8433f7482343812f85a35cf1/ui.apps/src/main/content/jcr_root/apps/acs-commons/components/utilities/report-builder/columns/containing-page/results.jsp

in the result.jsp, you can print the current date and it should be shown in column.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded