Location of stream data

[murugappan]

The stream data in espocrm is fantastic. It provides the users the facility to determine the events and changes. While it is good on UI, we need to access this information so that we can produce a number of reports external to escpocrm. We need help to locate the structure and name of the table for the stream data. We think the data is in the Note table but very vague on the contents.

Appreciate help on getting the details structure and contents for the stream data. Thank you in advance.

[yuri]

You are right, all needed stored on 'note' table.

https://github.com/espocrm/espocrm/blob/stable/application/Espo/Resources/metadata/entityDefs/Note.json

fields you might need:

type - can be Post, Update, Create, Assign.
parentId, parentType - record note is related to
data - additional data in json

[murugappan]

Thank you so much.