Historical transactional event | Community
Skip to main content
L
LAR1985
Level 3
October 26, 2022
Question

Historical transactional event

  • October 26, 2022
  • 1 reply
  • 1041 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

B
Adobe Employee
bisswangAdobe Employee
Adobe Employee
October 28, 2022

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

L
LAR1985Author
Level 3
October 31, 2022

Thanks @bisswang 

 

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

 

B
Adobe Employee
bisswangAdobe Employee
Adobe Employee
November 8, 2022

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
Terms & ConditionsAccessibility statement

Loading footer...