[rt-users] Query to usein dashboard for timeworked

[Ruslan Zakirov]

On Tue, May 8, 2012 at 5:00 PM, Alex Rhys-Hurn <alex at itworx.co.ke> wrote:

> Hello,
>
> I am really struggling with the query builder.
>
> I would like to build a query that is as follows:
>
>    1. Works for a specific queue i.i. Queue = 'queuename'
>    2. Applies to all activity in the queue since the 1st of the CURRENT
>    calendar month
>    3. Outputs the total timeworked for the queue in that period.
>
> So, I should get output that says something like
>
>
> queue = queuename
>
> timeworked (for all tickets, totalled) since 1st of current month = xx
> minutes
>
>
> I will then make a saved search and use a dashboard notification to send
> that around.
>
>
> Is what i am asking even possible?
>
Now it's only possible with custom code. There is a branch in the
repository that makes implementation much easier, but still need some minor
tweaks.

Many thanks,
>
> Alex
>
> --
> *Alex Rhys-Hur*n  |  ITworX Limited
> P.O. Box 1649, 00502, Karen, Kenya
> Tel: +254 (0) 20 2444824 | Cell: +254 (0) 724 972541
> Web: www.itworx.co.ke
>
> **
>



-- 
Best regards, Ruslan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120508/0cba4b21/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: webmail_logo.png
Type: image/png
Size: 1057 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20120508/0cba4b21/attachment.png>