Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Experience Manager Champion Program are open!
SOLVED

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

Avatar

Level 2

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

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

@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/6e88e55789ed72cd8433f7482343812f85...

 

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

 

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

@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/6e88e55789ed72cd8433f7482343812f85...

 

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