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