Profile details of those who went to end journey after a condition

Question

Hi Team, Can you please let me know how to find out the exact details of these profiles (profile id) of the profile who went to end after a condition box rather than proceeding ahead to an action.

As this end box doesn't have any action id or step id, I am even unable to query out these profiles.

SatheeskannaK · Accepted Answer

@hardikja3 Below query should give you all details including the records that went to end activity.

SELECT
timestamp,
_experience.journeyOrchestration.stepEvents.journeyVersionID,
_experience.journeyOrchestration.stepEvents.profileID,
_experience.journeyOrchestration.stepEvents.nodeName,
_experience.journeyOrchestration.stepEvents.journeyNodeProcessed,
_experience.journeyOrchestration.serviceType,
to_json(_experience.journeyOrchestration.profile),
to_json(_experience.journeyOrchestration.serviceEvents)
FROM journey_step_events
WHERE _experience.journeyOrchestration.stepEvents.journeyVersionID='<<id>>'
ORDER BY timestamp;

Mohan_Dugganab · Answer

You can add an additional filter based on nodeId and the Id can be retrieved by clicking on the end node.

SELECT to_json(_experience),
timestamp 
FROM journey_step_events 
WHERE _experience.journeyorchestration.stepevents.journeyVersionID = <journeyVersionId>
and _experience.journeyOrchestration.stepEvents.nodeID = '<NodeId in the UI corresponding to the respective node>'
order by TIMESTAMP DESC

Sign up

Login with SSO

Login to the community

Login with SSO