[rt-users] Cross table queries - transaction

[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, so that's
probably why they were removed in 4.0.  But I found that these reports
provided a useful template for making your own custom reports, which
can easily perform searches on transactions.  If you know some perl,
you can grab the code for these pre-made reports from 3.8 and use it
on 4.0.  I definitely had success with this approach.

Dan

On Thu, Dec 15, 2011 at 3:16 PM, Kevin Falcone
<falcone at bestpractical.com> wrote:
> 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 updated is yesterday, but if someone else
>> updates it after it doesn't show as lastupdatedby is changed.
>
> Unfortunately, the Query Builder concentrates on Ticket fields, and
> what you want is a Transaction search, which you can't do from the UI.
> You might be able to use the My Day link under Tools to point you in
> the right direction.
>
> -kevin
>
> --------
> RT Training Sessions (http://bestpractical.com/services/training.html)
> * Boston — March 5 & 6, 2012