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

[HardikJa3]

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 solution]

@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]

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

[Sukrity_Wadhwa]

Hi @HardikJa3,

Were you able to resolve this query with the help of the provided solutions, or do you still need further assistance? Please let us know. If any of the answers were helpful in moving you closer to a resolution, even partially, we encourage you to mark the one that helped the most as the 'Correct Reply.'
Thank you!