CA Service Management

Hi Team

We have custom field Change Owner in Change ORder Form and we need this in scoreboard . 

Like, If CO contain ChangeOwner name then we can directly spool those CO's via scoreboard.

what type of stored query should i create for it. Please guide

La-Qa 

You should be able to use the custom field within the WHERE CLAUSE of a stored query, which can they be used for a Scoreboard query.

Have you attempted this?

Can you share you custom attribute schema here so we can see if you can write regular stored queries on it?

HI ChiChen

Below attribute in change order table. Please  help

Stored Query detail:

Code: CHGOWNER

Scoreboard Usage: Yes

Type: Change Order

Label: Change Orders with Owner

Where Clause: active = 1 AND zChangeOwner IS NOT NULL

Many Thanks

Hi Lindsay Lindsay_Estabrooks

the above whereclause fetching the ticket with whoever the change owner is present in the 'change owner' field.

i want this like Any Analyst logged in servicedesk can see only his CO ticket which has change owner field with his/her name.

for example

analyst 'Aamir' logged into servicedesk and can see only those CO tickets from scoreboard which have  ChangeOwner field set to 'Aamir' and not any other. 

from the above stored query you provided, is fetching all the CO ticket having different change owners. So i have modified the query like below. but its fetching based on assignee. How can i modify this query to my need. can yo please help?

assignee.id = @cnt.id AND active = 1 AND zChangeOwner IS NOT NULL 

i think i need to intact change owner field id with contact id so then it may work??? please advise

I'm not sure why you designed your zChangeOwner attribute on the chg object as an SREL to your custom object z_changeOwner. It appears that the entries in your z_changeowner table have no reference back to the cnt object (except for a manually entered name in the owner attribute of the z_changeOwner object). As a result, you have no easy way to relate the zChangeOwner attribute on the chg object back to the logged-in user's cnt record.

Hi Aamir,

Have you tried this below query

log_agent.id = @zChangeOwner.id AND active = 1 AND zChangeOwner IS NOT NULL

Note: The assume that the zChangeOrder table holds the uuid value of the user and referenced to ID.

Thanks