Avatar

Community Advisor

Thanks @Jonathon_wodnicki , I confirm your solution works. We ended up with the following workflow:

20200805-165234-screenshot-11.jpg

 

that updates the following fields:

  • [indicators/@dirty] = 0 (Up To Date)
  • [indicators/@sent]
  • [indicators/@success]
  • [indicators/@processed]
  • [indicators/@error]
  • [properties/@toDeliver]

The Enrichment activity creates 3 column, one for each stat with an Aggregate Count(@id):

20200805-165607-screenshot-12.jpg

 

This way, we are able to configure it with the standard query editor, instead of a db trigger.

 

It ends up with well formated delivery stats:

20200805-165806-screenshot-13.jpg

 

Thank you

Florian