Query to usein dashboard for timeworked

RT Users
1

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?

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

2

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-Hurn | 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.