UUID values with Additional Search Arguments

Products

• CA Service Desk Manager
• CA Service Management - Service Desk Manager

Issue/Introduction

When developing a where clause syntax for Additional Search Arguments, there is a specific syntax needed to write the necessary where clause, which differs slightly from the syntax one may use in developing a stored query.

Environment

Release :  All releases which leverage the MDB database (since release 11.x)

Component : SERVICE DESK MANAGER

Resolution

Using an example of searching for a Change Order based on the affected_contact field, one could run:

active = 1 AND affected_contact = U'D89C98878F99FD428BBA4A9DB87FA8BE'

If one is  searching for Change Orders and drops down the search box to access the "Additional Search Arguments" field, one could use the above query to return all active CO's who name the given affected_contact by its UUID field.

It is important to note that there are no slashes required when using Additional Search Arguments to escape the single quotes. The slashes are needed if you are defining a stored query.  

If one were writing a stored query that returns the same content on a scoreboard node, the where clause on the scoreboard may read as:

active = 1 AND affected_contact = U\'D89C98878F99FD428BBA4A9DB87FA8BE\'

Additional Information

UUID values are often attained by examining for the id field of a given table.  For contact records, one could run the following command from an admin command prompt on the SDM Server to locate the UUID value:

pdm_extract -f "Select id, userid from ca_contact where userid = 'JSmith'"

Substitute "JSmith" for the userid of interest.