ECE SQL

SET ARITHABORT OFF SET ANSI_WARNINGS OFF SET NOCOUNT ON 
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
 
SELECT 
CREATED = EGPL_ROUTING_QUEUE.WHEN_CREATED,
QUEUE_NAME = EGPL_ROUTING_QUEUE.QUEUE_NAME,
QUEUE_ID= EGPL_ROUTING_QUEUE.QUEUE_ID,
ACTIVITY_ID  = EGPL_CASEMGMT_ACTIVITY.ACTIVITY_ID,
QUEUE_STATE = EGPL_ROUTING_QUEUE.QUEUE_STATE,
CASE EGPL_ROUTING_QUEUE.QUEUE_STATE 
WHEN '0' THEN 'Inactive'
WHEN '1' THEN 'Active'
ELSE 'unknown'
END AS QUEUE_STATE_NAME
--,EGPL_CASEMGMT_ACTIVITY.*
--,EGPL_ROUTING_QUEUE.*
 
FROM     
 EGPL_CASEMGMT_ACTIVITY 
,EGPL_ROUTING_QUEUE
 
WHERE 
EGPL_CASEMGMT_ACTIVITY.QUEUE_ID = EGPL_ROUTING_QUEUE.QUEUE_ID
--AND EGPL_ROUTING_QUEUE.QUEUE_NAME = 'Default exception queue'
This website uses cookies. By using the website, you agree with storing cookies on your computer. Also you acknowledge that you have read and understand our Privacy Policy. If you do not agree leave the website.More information about cookies