Skip to Content
0
Former Member
Apr 16, 2014 at 04:26 AM

Query for service call

458 Views

Hi,

Below is the query written to display all the service call records with customized field.

However I found out that not all the records will be displayed, the missing records will be the service call that without solution.

Can anyone please help to refine the query? So that the query will display records even the one without any solution.

Thanks

SELECT T0.[callID], T0.[U_CASEID],T0.[createDate] as 'Case No Created Date', T0.[U_RMAID],T0.[U_RMADATE] as 'RMA No Created Date', T0.[U_RMAID2], T1.[name] as 'Status', T0.[custmrName],T0.[U_CustomerName], T0.[itemcode], T0.[internalSN], T0.[subject], T3.[Subject] as 'Solution', T0.[updateDate], T0.[closeDate], T0.[assignee] FROM OSCL T0 INNER JOIN OSCS T1 ON T0.status = T1.statusID INNER JOIN SCL1 T2 ON T0.callID = T2.srvcCallID INNER JOIN OSLT T3 ON T2.solutionID = T3.SltCode WHERE (T0.[customer] =[%0] OR '[%0]'='') AND (T0.[U_CASEID] >=[%1] OR '[%1]'='') AND (T0.[U_CASEID] <=[%2] OR '[%2]'='') AND (T0.[U_RMAID] >=[%3] OR '[%3]'='') AND (T0.[U_RMAID] <=[%4] OR '[%4]'='') AND (T0.[U_RMAID2] >=[%5] OR '[%5]'='') AND (T0.[U_RMAID2] <=[%6] OR '[%6]'='')