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

Unreadable data Fields when exporting

Highlighted
Juan J Padilla
Super Collector

Unreadable data Fields when exporting

Hi All,

I'm using OV 4.5 (SP12).

When i'm exporting data from the database - via SQL statements - I'm getting certain fields with a weird format. An example:

When extracting the field "Item_Type", instead of, for example, "Problem", we get a number like "717488173". I guess it would be the same, but with a different number when trying to get Service Calls.

Is there a specific table which I have to use in order to get the proper information extracted?

Thanks!!
//Add this to "OnDomLoad" event