Scripting : Update Ticket Owner from custom field

Update Ticket Owner from custom field

I have rules that pulls the Manager info from LDAP all the way into a custom field (HD_TICKET.CUSTOM_FIELD_VALUE3) in a ticket. I'm looking for some query help as I'm wanting to create an update query that will update the ticket owner to the manager listed in the custom field. I'm a little rusty on my scripting so some help would be appreciated.

2 Comments [ + ] Show comments

Is HD_TICKET.CUSTOM_FIELD_VALUE3 storing the user ID of the manager or something else (name, username, etc.)? - chucksteel 10 years ago
It's storing the managers Full name. I've created the below which seems to do what I need. (Note I'm also moving the ticket to a different queue)

update HD_TICKET
SET HD_TICKET.HD_QUEUE_ID = 7,
HD_TICKET.OWNER_ID = (select USER.ID from USER where FULL_NAME = CUSTOM_FIELD_VALUE3)
where
(HD_TICKET.ID in (<TICKET_IDS>)) - mds1981 10 years ago

Answers (0)

Be the first to answer this question

Answer this question

Posted by:

View more:

Scripting Questions

question

Update Ticket Owner from custom field

Answers (0)

Posted by:

View more:

Related Questions

Related Links

Related Posts

Scripting

Update Ticket Owner from custom field

Answers (0)

Posted by:

Don't be a Stranger!

View more:

Related Questions

Related Links

Related Posts

Share