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.
Any thoughts?
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.
Any thoughts?
Sent from my iPhone
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
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.
DanOn Thu, Dec 15, 2011 at 3:16 PM, Kevin Falcone falcone@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