[Rt-devel] How to write a query to select all Correspondence Added Tickets

[Todd Chapman]

On Wed, Mar 01, 2006 at 01:46:53PM -0600, Marco Moreno wrote:
> I should have clarified, i would like to query this directly against the
> database but I don't know how the associations between a ticket and its
> history are stored that reflect the Correspondence Added section of the
> history.
> 
> Thanks.
> 

I recommend you use the Perl API. But if you insist on SQL
you will need to join Tickets and Transactions.  The fields
of interest are Transactions.Type = 'Correspondence' and
Transactions.Created > 'something'

-Todd