Expand my Community achievements bar.

Historical transactional event

Avatar

Level 3

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

 

LAR1985_0-1666798662586.png

 

Thanks

 

3 Replies

Avatar

Employee Advisor

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

Avatar

Level 3

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:

 

LAR1985_0-1667215505971.png

 

Thank you

 

Avatar

Employee Advisor

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