Find Tickets Submitted by users in certain user label.
We have a Label called 'Mac Users' and we want to run a report to find all tickets that have been submitted by members of that Label. I am pretty new to SQL and am having trouble getting it set up.
1 Comment
[ + ] Show comment
Answers (0)
Please log in to answer
Be the first to answer this question
Select
ORG1.HD_TICKET.TITLE,
ORG1.HD_TICKET.OWNER_ID,
ORG1.HD_TICKET.SUBMITTER_ID,
ORG1.LABEL.NAME,
ORG1.HD_QUEUE_SUBMITTER_LABEL_JT.HD_QUEUE_ID,
ORG1.HD_QUEUE_SUBMITTER_LABEL_JT.LABEL_ID
From
ORG1.HD_TICKET,
ORG1.LABEL Inner Join
ORG1.HD_QUEUE_SUBMITTER_LABEL_JT On ORG1.HD_QUEUE_SUBMITTER_LABEL_JT.LABEL_ID
= ORG1.LABEL.ID
WHERE ORG1.LABEL.NAME = 'Mac Users' - nshah 10 years ago