on 07-26-2017 4:37 PM
Hi, I am creating a new query to see all open service calls for a particular user. I'm using the oscl table. But rather than displaying a number for the 'status' or 'handled by' field, it is possible to display the actual name for each of these values instead in the results.
SELECT T0.[callID], T0.[status], T0.[subject], T0.[customer], T0.[custmrName], T0.[assignee], T0.[descrption] FROM OSCL T0 WHERE T0.[assignee] = 11 and T0.[status] != -1 ORDER BY T0.[createDate] desc
Thanks, Eoin
From doing more research I have found the answer I needed. Putting this here in case it helps anyone else.
This will list all open calls in a query & show the Status description & the user name instead of the numbers on the results displayed.
SELECT T0.[callID], T1.[NAME], T0.[subject], T0.[customer], T0.[custmrName], T2.[USER_CODE], T0.[descrption] FROM OSCL T0 inner join OSCS T1 on t0.[status] = T1.[statusid] inner join ousr T2 on T0.assignee=T2.uSERID WHERE T0.[assignee] = 11 and T0.[status] != -1 ORDER BY T0.[createDate] asc
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.