[rt-users] Cross table queries - transaction

2011-12-15 Thread Joe Harris
Is there any way to build a query within RT (4.04) to query more than the ticket table? Specifically I am trying to build a dashboard that will email users any ticket they updated yesterday. I have one that is current user and last updated is yesterday, but if someone else updates it after it

Re: [rt-users] Cross table queries - transaction

2011-12-15 Thread Kevin Falcone
On Thu, Dec 15, 2011 at 07:17:15AM -0500, Joe Harris wrote: Is there any way to build a query within RT (4.04) to query more than the ticket table? Specifically I am trying to build a dashboard that will email users any ticket they updated yesterday. I have one that is current user and last

Re: [rt-users] Cross table queries - transaction

2011-12-15 Thread Dan Madere
I was also trying to figure this out so I could make a report of which tickets entered a specific queue in a date range, even if the ticket is not in that queue currently. In RT 3.8, there were these 3 pre-made reports under tools reports in the interface. Admittedly, they weren't very useful,