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]'='')