Extend Reporting framework

[Nitish_Jain01]

Hi All,

We have a requirement to extend the current reporting framework of AEM.

We need to send emails to all the person's who have any review pending with them. The mail will be send to official mail-ids and will have complete information about the assets/resources need to be reviewed by them This mail needs to scheduled to be send once weekly.

Say if author has authored the content and send it for review but reviewer does not acknowledges it...we need to send email on timely basis reminded that some action item is pending for them.

To send email once a week, we can use Scheduler. But to generate the report we have requirement to use Reporting framework of AEM and customize it to send emails.

Adobe documentation suggest about creating new report but not about customizing it.

Any guidance in this regard would be helpful.

Thanks and Regards,

Nitish Jain

[smacdonald2008]

I do not believe you can configure Report to send emails. 

Another approach you can use is to write a custom workflow step that generates an Excel report dynamically and emails that report to the applicable users. You will have full control over the data you want to inject into the report and customize as required. 

Then from your scheduler server - invoke the workflow. 

To learn how to invoke a workflow from an API - see: 

http://helpx.adobe.com/experience-manager/using/invoking-experience-manager-workflows-using.html.

To learn how to use Excel API to generate a cusotm AEM service - see: 

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

To learn how to write a cusotm workflow step - see: 

http://helpx.adobe.com/experience-manager/using/creating-custom-aem-workflow-steps.html. 

We use this for custom tools we use on our team.,..

Hope this helps...

[Nitish_Jain01]

Thanks for the reply. Surely this helps. Have shared the details with architect for further actions.

[smacdonald2008]

I will add this use case to Helpx article list. Buildind custom tools with AEM is an important use case.

[Nitish_Jain01]

Hi smacdonald2008,

There's workflow instance report at "http://localhost:4502/miscadmin#/etc/reports/wfinstances". when I open it (http://localhost:4502/etc/reports/wfinstances.html?cq_ck=1476258125413), blank page comes up. Though i have few workflows completed and few in pending state. Do i need to do some configurations to get the result in the report?

[smacdonald2008]

Are you seeing errors in a log file. If a blank page comes up - this typically indicates that an error has occurred such as a Java Null error. 

[Nitish_Jain01]

Sorry for late response.

I have not done any changes in the report.

Error in error.log is attached.

[Nitish_Jain01]

Thanks smacdonald2008. Using your suggestion we are able to implement the solution.