On The Service Desk Manager usq Table, What Do obj_persid And role_persid Signify, And How Are They Related?

Document ID : KB000115510
Last Modified Date : 25/09/2018
Show Technical Document Details
Question:
What values can users expect to see in the obj_persid and role_persid columns on the usq table in the Service Desk Manager MDB, and how are they related? 
Answer:
The item obj_persid will show either the contact uuid or role id, based on what the scoreboard query was created for.
The item role_persid will show the role related to the contact or role the scoreboard query was created for.
 
For example, if you create a query for a specific contact, it'll show their uuid as obj_persid, and their role as role_persid.

A visual example of creating test Scoreboard Queries and viewing related information on the usq table:

Test Scoreboard Queries and Their References 
 
Additional Information:
The following articles provide examples of how one could leverage the obj_persid and role_persid columns with regards to stored queries

Most Common Issues When Working with Scoreboard
https://comm.support.ca.com/kb/most-common-issues-when-working-with-scoreboard/kb000023072

Cannot save my personal search filter
https://comm.support.ca.com/kb/cannot-save-my-personal-search-filter/kb0001152973

Procedure to reset user scoreboard
https://comm.support.ca.com/kb/procedure-to-reset-user-scoreboard/kb000027219