[rt-users] Cross table queries - transaction

[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 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20111215/3714d850/attachment.sig>