/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I have seen other posts online about including all comments in a report, but I can't seem to figure out how to place the proper syntax into the query.

Any help would be much appreciated

Danny

SELECT HD_TICKET_CHANGE.COMMENT AS HD_TICKET_CHANGE_COMMENT, HD_TICKET.CREATED AS HD_TICKET_CREATED, O.FULL_NAME AS OWNER_NAME, HD_STATUS.NAME AS STATUS, S.FULL_NAME AS SUBMITTER_NAME, HD_TICKET.ID AS HD_TICKET_ID, HD_TICKET.TITLE AS HD_TICKET_TITLE FROM HD_TICKET LEFT JOIN HD_TICKET_CHANGE ON (HD_TICKET_CHANGE.HD_TICKET_ID = HD_TICKET.ID) LEFT JOIN USER O ON (O.ID = HD_TICKET.OWNER_ID) JOIN HD_STATUS ON (HD_STATUS.ID = HD_TICKET.HD_STATUS_ID) LEFT JOIN USER S ON (S.ID = HD_TICKET.SUBMITTER_ID) WHERE (HD_TICKET.HD_QUEUE_ID = 1) AND ( (1 in (select 1 from HD_CATEGORY where HD_CATEGORY.ID = HD_TICKET.HD_CATEGORY_ID and HD_CATEGORY.NAME LIKE '%network%')) AND HD_TICKET.TITLE LIKE '%new hire%' AND (DATE(HD_TICKET.CREATED)> DATE_SUB(NOW(), INTERVAL 1 year) AND DATE(HD_TICKET.CREATED)<= NOW())) GROUP BY HD_TICKET.ID ORDER BY HD_TICKET.CREATED asc
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
Does this help:
http://www.kace.com/support/kb/index.php?action=artikel&id=954

If not what is it missing? Can you mock up an example of what you want?
Answered 10/13/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
I think I may have figured it out. I was shown a tool called FlySpeed, and it seems to have helped.

Thanks,
Danny
Answered 10/14/2011 by: dannyv
Yellow Belt

Please log in to comment
0
this: http://www.activedbsoft.com/overview-querytool.html ?

Sounds cool. How do you like it?
Answered 10/14/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
It's actually pretty sweet... make the queries visual, and easier to understand.
Answered 10/14/2011 by: dannyv
Yellow Belt

Please log in to comment