Where are dv_ values stored?

[Andrew_TND]

We have an ODBC plugin which without going into too much depth pulls data from our instance of ServiceNow to an access database.

We've successfully managed to get it to work however, any custom referenced fields we have are coming across as sys_id's. Out of the box fields such as assignment_group have a duplicated option with the prefix - dv_assigment_group which pulls the display value.

Before I go ahead and start creating new fields on the table to duplicate the display value is there a place the dv_ values are stored where I can configure this?

[Community Alums]

Hi @Andrew Robinson ,

Below post has answers to your questions for Display value DV_ uses.

A few Random Tips for ServiceNow Reporting | Jason Dove's Business Intelligence Rants

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Andrew_TND]

Hello,

Thanks for this article, its helpful as it explains it but not how I can configure new dv_ fields if I even can.