Workflow Activity Report

This is a real-world application developed with Estrelica.Core for a customer who needed monthly reports regarding which Advanced Workflow activities had taken place across several applications, and what changes resulted to the records as a result of those activities.

To implement this we added a new History Log field configured for "advanced workflow auditing" and "field value change auditing" to each application, with the specific fields in question included in "Track selected fields":

When the application executes, it searches the application for all records having a "Last Updated" date later than or equal to the start date of the reporting period, evaluates each record's IArcherContentAccess.ContentHistory for the single History Log field in question, then iterates that history looking for workflow activities and content changes that occurred before the end date of the reporting period. With this information it is able to gather the output needed for the monthly activity report.

It is important to understand that this application is a prototype for an eventual production application that was delivered to a specific customer, so it has dependencies on specific applications and fields that won't exist in your Archer instance. Therefore this application will almost certainly fail if you attempt to run it in your environment. It is merely presented here for educational purposes, to demonstrate how easily all of the information tracked by History Log fields may be accessed via Estrelica.Core.