Historical transactional event

[LAR1985]

Hi all,

We need to do a query in a workflow on historical transactional event, we don't find that those input data are stored in any resource. do you know how can we do it? It would be the same information that it is in "Latest transactional events", how it is displayed in the screenshot

Thanks

[ramon_bisswanger]

The events are stored in the EVTTest_Historical or the generic rtEvent type.

You should be able to query that in a workflow

Note: there is some retention there and data will be removed automatically after a while

[LAR1985]

Thanks @ramon_bisswanger 

The problem is that when we choose EVTTest_Historical in a query, we have the following fields but not any of the ones that we have created as inputs in the event:

Thank you

[ramon_bisswanger]

The search indeed won't allow you to directly address the fields as they are not stored as DB columns but rather XML data inside the database.

You may address that with some common workaround:

• Query for all events
• Use a file export activity which stores event ID + the fields you want to filter on
• Use a read file activity to load the content from the file exported just before
• Afterwards you have the data accessible in the targetData and can filter using a segmentation activity