[rt-users] searching resolved ticket dependancies

2008-10-08 Thread Alex Young
Hi, I'm trying to do a search of tickets that are new and open, but only if they don't depend on any other tickets or the tickets they depend on has been resolved. I had this so far: ( Status = 'new' OR Status = 'open' ) AND FinalPriority 0 AND Due '2 days' AND DependsOn = 'NULL'

[rt-users] Occasional Approvals

2008-10-06 Thread Alex Young
Hi, I have been reading the wiki on the approval system. I managed to get it all setup and working. Just wondering if I have it right. Looks like I have to create two queues, one for the user to make an approval ticket, and the other for the actual approval ticket (___Approvals).

[rt-users] Search results for TimeTaken for time sheets

2008-10-03 Thread Alex Young
Is it possible to get search results with a sum of the TimeTaken values from the Transactions table? Our internal developers need to fill out time sheets each week. At the moment this is labour intensive so I have been trying to work out a way to pull the time out of the tickets for the

<    1   2