[rt-users] Query about Tickets table

2009-05-05 Thread 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

Re: [rt-users] Query about Tickets table

2009-05-05 Thread 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