需要用于从各种条件中选择案例状态的存储过程或功能. [英] need store procedure or function for selecting case status from various condition.

问题描述

xyz表中的案件状态如下:

Having below case status in xyz table :

Assigned 
Completed 
Case Closed
Ready To Release
Released
Review In Process
Reviewed
Reviewed-Commented
Reply In Process
InProgress	
Audited
Re-Perform
Audit Re-Performed	
UNASSIGNED

需要根据以下条件选择以上案例状态

need to be select above case status as per the below conditions

select completed if case status 
 Completed in( Case Closed,completed) as completed

select READY TO RELEASE if case status READY TO RELEASE 
in(Released,Review In Process,Reviewed,Reviewed-Commented,Reply In Process) as READY TO RELEASE 
					

select INPROGRESS if case status 
INPROGRESS 
 in(
                 InProgress,	OR	[Assigned	AND	   Ready To Release,
                 Audited,				                Released,
                 QC In Process,				            Review In Process,
                 Re-Perform,				           Reviewed,
                 Audit Re-Performed,				   Reviewed-Commented,
				                                   Reply In Process,
				                                   Case Closed,
				                                   Completed ]
												   ) as INPROGRESS
select ASSIGNED if case status 											   
ASSIGNED in	(Assigned ) as assigned

如果案例状态未达到上述任何条件，则选择案例状态UNASSIGNED

条件基函数或存储过程，用于从xyz表中从上述条件中选择案例状态.

if case status not falling in any of above condition then select case status UNASSIGNED

condition base function or store procedure for selecting case status from above condition from xyz table.

推荐答案

SELECT 
  INPROGRESS = CASE WHEN Status IN 
                            (
                            'InProgress','Assigned', 'Ready To Release',
                            'Audited', 'Released', 'QC In Process', 'Review In Process',
                            'Re-Perform', 'Reviewed', 'Audit Re-Performed',	 'Reviewed-Commented',
                            'Reply In Process', 'Case Closed', 'Completed' 
                            )
                      THEN 'INPROGRESS'
                  ELSE NULL
                 END
 , ASSIGNED =  CASE WHEN Status IN( 'Assigned' ) 
                       THEN 'ASSIGNED'
                    WHEN Status NOT IN( 
                                    'InProgress','Assigned', 'Ready To Release',
                                    'Audited', 'Released', 'QC In Process', 'Review In Process',
                                    'Re-Perform', 'Reviewed', 'Audit Re-Performed',	 'Reviewed-Commented',
                                    'Reply In Process', 'Case Closed', 'Completed' 
                                    )
                         THEN 'UNASSIGNED'
                END
FROM XYZ

这篇关于需要用于从各种条件中选择案例状态的存储过程或功能.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！