Hopefully this will be quick and easy:

In the Service Desk when viewing a ticket I'd like to display the name of the queue to which a ticket belongs. I imagine a Custom Field is the answer, but need a little guidance on how to get it to represent the queue relationship.
0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity


I doubt you can do the query in a custom field but you can create a custom field and call it Queue.
Then you create a ticket rule to update that field for you.

For example, this select statement will show the queue for the specified ticket. I'm sorry, I don't have the time at the moment to implement this for you but hope this helps you out.

select Q.NAME from HD_TICKET T 
left join HD_QUEUE Q on Q.ID = T.HD_QUEUE_ID 
where T.ID in (<TICKETS_IDS>)

You'd have to select your desired tickets (all or new,etc...) and run an update query to pull the HD_QUEUE.NAME that is associated with the HD_TICKET.HD_QUEUE_ID of the ticket and update the CUSTOM_VALUEx value with it.
Answered 12/17/2014 by: h2opolo25
Red Belt

Please log in to comment