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?