The below condition i used for SLA breched , completed , inprogress like that, but all fields areavailable in Database Side , but now "SLA" Column they removed in DB Side.
But SLA Contains list of values like --> 48,2,72,0,2,4 these values.
Seel the below condition --> time taken (24) > SLA(48/2/72/0/2/4) , based on the SLA Values the below condition worked previously.
But now these SLA Column not there, so what i need to do for condition checking..which steps i need to follow . please help me out..today i need to deliver the reports .
IF (UPPER([STEP_STATUS])="COMPLETED") THEN 'COMPLETED'
ELSEIF ([TIME_TAKEN_HRS]>FLOAT([SLA)) THEN 'BREACHED'
ELSE 'INPROGRESS' END
please help me ,i am facing this issue.
any one please help me, waiting for your valuable reply.