QuestionQ4

VerifiedJourney Orchestration

An AJO Developer needs to determine whether a particular profile has entered the journey. The developer uses the following query to retrieve the data:

SELECT count(_id) FROM journey_step_events  
where  
_experience.journeyOrchestration.stepEvents.journeyVersionID = 'ec9efdd0-8a7c-4d7a-a765-b2cad659fa4e' AND  
_experience.journeyOrchestration.stepEvents.profileID = '[email protected]' AND  
_experience.journeyOrchestration.stepEvents.nodeType-'start'  

If a profile enters the same journey more than once, how does that affect the query result?

Explanation

count(_id) counts every matching journey-step event record. A profile re-entering a journey receives a new journey instance, and each matching start event has its own _id; therefore, the result includes every time that profile entered the journey.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!