[rt-users] Query about Tickets table
rfh at vialtus.com
Tue May 5 05:38:53 EDT 2009
2 possible causes:
1- Merged tickets .. RT will assume 1 ticket for merged ones
2- You do n't have permission on all queues
in Mysql try:
select count(EffectiveId) as TOTAL From Tickets where Status = 'resolved' ;
Alberto Villanueva wrote:
> Good morning,
> Several days ago, I have been executing some queries from mysql.
> I have obtained results that web interface doesn't generate. I
> would like to know if someone knows it's happening.
> The simpler sentence is next:
> RT --> Status = 'resolved'
> MySQL --> SELECT COUNT(id) as 'TOTAL' FROM Tickets WHERE Status =
> The result in RT is: 28.536
> The result in MySQL is: 28.659
> Any idea?
> Thanks a lot!!
> Best regards,
> ALBERTO VILLANUEVA DEL VAL
> Altran Technologies
> ParqueEmpresarial Las Mercedes, Edificio 1
> C/ Campezo, 1. 28022 Madrid
> Tel: + 34 91 744 46 00 - Ext: 2205
> Fax: + 34 91 415 24 57
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> Buy a copy at http://rtbook.bestpractical.com
More information about the RT-Users