Hey. First of all, I'm new here, so I apologize in advance if my question
has already an answer.
So, basically, here's the fact: the company I work in would like a report to
reveal all the notes that were created regarding a ticket. I couldn't find
anything like it in OTRS, so I went to another reporting tool and I ended up
with this query:
SELECT
ticket.tn, COUNT(ticket_history.history_type_id)
AS '# of Notes'
FROM
ticket_history
LEFT JOIN ticket ON (ticket_history.ticket_id = ticket.id)
WHERE
ticket_history.history_type_id = 15 AND ticket_history.create_time
BETWEEN startDate AND endDate
GROUP BY
ticket.id;
It's part of a procedure, so that's why I have a startDate and an endDate.
My question is if anyone of you guys know what history_type_id's are used
when adding a note.
Thank you very much in advance.
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
