Service Desk Practitioners Forum
cancel

Hidden Object ID for Person Records

SOLVED
Go to solution
Highlighted
Iceman_1
Valued Contributor.

Hidden Object ID for Person Records

Object ID for Person Records are currently hidden in HP Service Desk, I can pull this information using Westbury reports. Is there a way to make this visible in Service Desk and the client? The reason is the Person Records doesn't have a definitive unique identifier and we are in the process of updating address / telephone number, as well as Organizational structure. I welcome any suggestions you may have...
3 REPLIES
Chris Bailey_3
Outstanding Contributor.

Re: Hidden Object ID for Person Records

Hi Wilson,

To make the OID visible in the client, you can use a Database Rule and a custom field.

Create a custom field called "OID" or "Unique ID" or whatever you'd like. Then create a new database rule for person records. Add a "Data Update" action whenever a new record is saved that sets your custom field to the attribute "OID" in the dropdown list of fields.

To get the OID to be visible for existing records, you will have to run an UPDATE query against the database that copies the "per_oid" field value into the custom field you create.

If you need some more specific instructions about any of those steps, just post back.

Thanks,
Chris
Jasper Verweij
Acclaimed Contributor.
Solution

Re: Hidden Object ID for Person Records

Wilson,

Another option than performin a database update would be a simple web-api code to copy OID to field X of a person.

Jasper
Chris Bailey_3
Outstanding Contributor.

Re: Hidden Object ID for Person Records

Jasper's right that webAPI is a safer option if you know how to write Java code. If you're not comfortable with that, you won't harm anything by copying the values directly to a custom field through SQL. However, the webAPI is extrememly useful, so it could be a good opportunity to learn more about it.