Skip to main content
added 364 characters in body
Source Link
Thor
  • 1
  • 1
  • 2

I'm trying to make a select that returns the journeys where a certain user is inserted, but I'm getting this error, does anyone know why?

Select Distinct J.JourneyId, J.JourneyName, S.SubscriberID,SUB.SubscriberID
FROM _Journey J
INNER JOIN _JourneyActivity JA ON JA.VersionID = J.VersionID 
INNER JOIN _Sent S ON JA.JourneyActivityObjectID = S.TriggererSendDefinitionObjectID
INNER JOIN _Subscribers k ON S.SubscriberID = k.SubscriberID
WHERE SUB.SubscriberID='0016g00001AEHcyAAH'

enter image description here

I'm trying to make a select that returns the journeys where a certain user is inserted, but I'm getting this error, does anyone know why?

enter image description here

I'm trying to make a select that returns the journeys where a certain user is inserted, but I'm getting this error, does anyone know why?

Select Distinct J.JourneyId, J.JourneyName, S.SubscriberID,SUB.SubscriberID
FROM _Journey J
INNER JOIN _JourneyActivity JA ON JA.VersionID = J.VersionID 
INNER JOIN _Sent S ON JA.JourneyActivityObjectID = S.TriggererSendDefinitionObjectID
INNER JOIN _Subscribers k ON S.SubscriberID = k.SubscriberID
WHERE SUB.SubscriberID='0016g00001AEHcyAAH'

enter image description here

Source Link
Thor
  • 1
  • 1
  • 2

Error: Unable to create temporary data extension: A field named VersionID already exists on object QueryStudioResults

I'm trying to make a select that returns the journeys where a certain user is inserted, but I'm getting this error, does anyone know why?

enter image description here