How to Create a Report Based on Stream (Audited Field Changes)

[Laimonas]

Hello,

I have a question regarding the Stream in EspoCRM. I see that when a field is marked as "audited", any changes to its value are recorded in the Stream of the record.

Is there a way to create a Report based on these Stream entries, so that I can track changes to audited fields across records?

Any suggestions or guidance would be greatly appreciated.

Thank you in advance!

[yuri]

Hi,

It's not possible as audited data is stored as JSON.

You can create a hook for the Note entity that will create entries of a custom entity type. Then, create a report for that entity type.