hello, Has anyone with SQl knowledge know how to get an export of all the items listed in Catagories of a service desk queue?

Thanks


0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

0
Here you go:
SELECT C.NAME, Q.NAME
FROM ORG1.HD_CATEGORY C
JOIN HD_QUEUE Q on Q.ID = C.HD_QUEUE_ID
ORDER BY Q.NAME, C.NAME
Answered 11/27/2017 by: chucksteel
Red Belt

  • WOW, great work a treat. Many Thanks however another quick question if i have multiple queues where would i select the name of the queue in the syntax?
    • You need to add a where clause:
      SELECT C.NAME, Q.NAME
      FROM ORG1.HD_CATEGORY C
      JOIN HD_QUEUE Q on Q.ID = C.HD_QUEUE_ID
      WHERE Q.NAME = "My Queue"
      ORDER BY Q.NAME, C.NAME
Please log in to comment
Answer this question or Comment on this question for clarity