[rt-users] Query about Tickets table

[Raed El-Hames]

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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>