Need help with K1000 Helpdesk/ServiceDesk query to show all comments AND/OR Work Notes
Need help with K1000 Helpdesk/ServiceDesk query to show all comments AND/OR Work Notes for a given ticket and group and sort by Ticket_ID and maybe even on another report then sort by the Person entering the notes/comments.... depends on how im wanting to look at it.
Im basically trying to be able to create a report that will show me what was being done for a given time frame for all my techs. The canned reports seem to only show Work Notes and dont include Comments and we enter both. I would think this would be a pretty common request, but I cannot find another post on it.
Any help would be greatly appreciated.
I know comments come from the HD_Ticket_Change table and Work Notes from the HD_Work table, but I need to get all from each and group and sort probably by Ticket_ID, then date/time (and I know HD_Work uses either START field or MODIFIED field and the HD_Ticket_Change would use the TIMESTAMP field, so I dont know how to handle that either).
There are no answers at this time