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
34
Views
1
Comments

Summary:


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'  
THEN 
	CASE WHEN "Checklist Task Details"."PER_PERSON_ALLOCATED_TASKS_DFF_CRIMINAL_CHECK_" = 'Validated' AND "Checklist Task Details"."Status" = 'Completed'    
	THEN 'Cleared'    
	ELSE 'Pending'    
	END 
WHEN "Checklist Task Details"."Status" = 'Completed' AND "Checklist Task Details"."Task Name" NOT IN ('Criminal Check') 
THEN 'Cleared' 
ELSE 'Pending' 
END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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