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' ; Regards; Roy 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 = > 'resolved'; > > 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 > Consultor > ____________________________________________ > 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 > www.altran.es > > > _______________________________________________ > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users > > Community help: http://wiki.bestpractical.com > Commercial support: sa...@bestpractical.com > > > Discover RT's hidden secrets with RT Essentials from O'Reilly Media. > Buy a copy at http://rtbook.bestpractical.com > _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com