<div dir="ltr">Hello,<div><br></div><div>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.</div><div><br></div><div>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...</div>
<div><br></div><div>--------------------------------------------------------------</div><div>| Queue 1 | datetime | value of custom field |</div><div><div>| Queue 1 | datetime | value of custom field |</div></div><div><div>
| Queue 1 | datetime | value of custom field |</div></div><div><div>| Queue 2 | datetime | value of custom field |</div></div><div><div>| Queue 3 | datetime | value of custom field |</div></div><div><div>| Queue 3 | datetime | value of custom field |</div>
</div><div>--------------------------------------------------------------</div><div><br></div><div>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?</div>
</div>