On Tue, May 31, 2011 at 10:02 PM, Felipe Agnelli Barbosa <[email protected]> wrote: > How can I tell how many comments had every ticket via sql queries?
SELECT t.id AS id, txn.Type AS type, COUNT(txn.id) AS counter
FROM Tickets t
LEFT JOIN Transactions txn
ON txn.ObjectType = 'RT::Ticket'
AND txn.ObjectId = t.id
AND txn.Type IN ('Create', 'Comment', 'Correspond')
GROUP BY t.id, txn.Type;
> thanks in advance,
>
> Felipe
> BR
> --
> " A dúvida é o principio da sabedoria "
--
Best regards, Ruslan.
