[rt-users] Question about generating a report

[Chris Hall]

Hello,

My rt users have hit me with a rather.. unusual request. I'm not exactly
sure how to get RT to do what they're asking.

Basically they want to generate a monthly report of times a comment was
made on tickets in a queue. This alone I'm almost able to achieve through a
mysql query. But they've thrown me a curve ball in that they also want
listed the value of a custom field. Basically what they're looking for is
something like this...

--------------------------------------------------------------
| Queue 1 | datetime | value of custom field |
| Queue 1 | datetime | value of custom field |
| Queue 1 | datetime | value of custom field |
| Queue 2 | datetime | value of custom field |
| Queue 3 | datetime | value of custom field |
| Queue 3 | datetime | value of custom field |
--------------------------------------------------------------

Could anybody give me any type of direction as to how I could get this
information from the database in the form of a mysql query?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140708/b41018ea/attachment.htm>