Query about Tickets table

RT Users
1

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

2

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: