cancel
Showing results for 
Search instead for 
Did you mean: 

how to get servicecall status field on report?

vinayak_chavan
Participant
0 Kudos

how to get servicecall status field on report?

View Entire Topic
Former Member
0 Kudos

Hi,

Try:

SELECT T0.CallID, T0.Customer, T1.Name 'Status'

FROM OSCL T0

JOIN OSCS T1 ON T1.StatusID=T0.Status

WHERE T0.customer LIKE '[%0]%'

Thanks,

Gordon