[rt-users] Query about Tickets table

[Alberto Villanueva]

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