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?

Accepted Solutions (1)

Accepted Solutions (1)

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

Answers (1)

Answers (1)

former_member186095
Active Contributor
0 Kudos

Hi,

The report must have field status from OSCL table. The field status indicates the service call status.

Rgds,

JimM