What's new in Customer Journeys?

Connect and learn more! ×
How to use a dashboard prompt in Case When query for a field — Cloud Customer Connect
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

How to use a dashboard prompt in Case When query for a field

Received Response


Content (please ensure you mask any confidential information):

We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below is the analysis that shows Person Number is prompted:

The 'Status' field is a custom field that uses a CASE WHEN syntax. Below is the syntax:

CASE WHEN "Checklist Task Details"."Task Name" IN ('Criminal Check') AND "Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_CRIMINAL_CHECK_" = 'Validated'  
	CASE WHEN "Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_CRIMINAL_CHECK_" = 'Validated' AND "Checklist Task Details"."Status" = 'Completed'    
	THEN 'Cleared'    
	ELSE 'Pending'    
WHEN "Checklist Task Details"."Status" = 'Completed' AND "Checklist Task Details"."Task Name" NOT IN ('Criminal Check') 
THEN 'Cleared' 
ELSE 'Pending' 

Howdy, Stranger!

Log In

To view full details, sign in.


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