You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

SQL query to show the Journey and Journey Task details

in Journeys

Summary:

Hello! I'm asking if anyone here has a sample SQL query that shows the values showing the details in the Journeys Redwood Page. The main concern I have is that the status values in the Redwood page don't exactly match what's in the CHECKLIST_STATUS column in the PER_ALLOCATED_CHECKLISTS table. Is there a different table that stores the status value from the Redwood page?

Content (please ensure you mask any confidential information):

For example, the available status values in the Redwood Page are "Deferred", "Completed", "Overdue", "Open" while the available values from the CHECKLIST_STATUS column are "Completed", "Dependent", "Expired", "Forced Closed", "Initiated", "In Progress", "Outstanding", etc. Need help if there's another table to use aside from the PER_ALLOCATED_CHECKLISTS that I can use to get the Journey status and Journey Task status.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!