Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

STATUS field in OVSD 4.5

SOLVED
Go to solution
Highlighted
Eric Ung
Frequent Visitor

STATUS field in OVSD 4.5

Anyone know which Database table holds the Status field for all ServiceCalls and perhaps how its linked to ITSM_ServiceCalls table. Thanks
4 REPLIES

Re: STATUS field in OVSD 4.5

It's in the codes_locale table for Service Calls.

It's related by the Status_oid value
Eric Ung
Frequent Visitor

Re: STATUS field in OVSD 4.5

Darren, don't seem to locate the fields that you suggested. I am running Version 4.5 SP17.
Attached is the table fields from ITSM_ServiceCalls and Status_oid is not part of it.
Solution

Re: STATUS field in OVSD 4.5

apologies Eric, gave an incorrect term for the OID reference.

The field containing the reference to the status oid is SER_STA_OID.

hope this info serves you better.

cheers,
Darren HP
Eric Ung
Frequent Visitor

Re: STATUS field in OVSD 4.5

Found it........

select *
from itsm_servicecalls,
ovsd_rep.rep_codes,
ovsd_rep.rep_codes_text
where rep_codes.rcd_oid = itsm_servicecalls.ser_sta_oid
and rep_codes.rcd_oid = rep_codes_text.rct_rcd_oid
//Add this to "OnDomLoad" event