Is is possible in Query Builder to search by Group Name?
For example - I have Queues A and B, and Groups C and D. Users from
group C are responsible for tickets in Queue A but can subbmit tickets
to Queue B, and viceversa - users from group D are responsible for
tickets in Queue B but can subbmit tickets to Queue A.
Now I want to search how many tickets from users in group C was
submitted to Queues that they are not responsible for, like: Queue="B"
and Status=“new” and Requestor is in group=“C”.
BM
Now I want to search how many tickets from users in group C was
submitted to Queues that they are not responsible for, like:
Queue=“B” and Status=“new” and Requestor is in group=“C”.
RequestorGroup.Name = ‘foo’ should work
-kevin
Unfortunettly it’s not working.
What I understood is this "RequestorGroup.Name = ‘foo’ " should be added
in Search/Edit.html?NewQuery=1 (Advenced on Query Builder)
I tried Queue=foo and RequestorGroup.Name=“MO Mechanicy Strefa”
0 tickets found
then Queue != ‘General’ AND RequestorGroup.Name = ‘MO Mechanicy Strefa’
0 tickets found
then just RequestorGroup.Name = ‘MO Mechanicy Strefa’
also 0 tickets found.
Could it be other variable or some problems with spaces in name of Group?
W dniu 2014-03-07 17:44, Kevin Falcone pisze:> On Fri, Mar 07, 2014 at 02:25:34PM +0100, Bartosz Maciejewski wrote:
Now I want to search how many tickets from users in group C was
submitted to Queues that they are not responsible for, like:
Queue=“B” and Status=“new” and Requestor is in group=“C”.
RequestorGroup.Name = ‘foo’ should work
-kevin
http://agriplus.pl/
Bartosz Maciejewski/ IT Administrator
grafika1 (1.24 KB)
Ok, as a workaround this works
RequestorGroup.Id = 105 AND Queue != ‘MO.Mechanicy.Strefa’
(id 105 is group “MO Mechanicy Strefa” which maitain tickets in Queue
MO.Mechanicy.Strefa")
Thanx.
W dniu 2014-03-11 12:36, Bartosz Maciejewski pisze:
Unfortunettly it’s not working.
What I understood is this "RequestorGroup.Name = ‘foo’ " should be
added in Search/Edit.html?NewQuery=1 (Advenced on Query Builder)
I tried Queue=foo and RequestorGroup.Name=“MO Mechanicy Strefa”
0 tickets found
then Queue != ‘General’ AND RequestorGroup.Name = ‘MO Mechanicy Strefa’
0 tickets found
then just RequestorGroup.Name = ‘MO Mechanicy Strefa’
also 0 tickets found.
Could it be other variable or some problems with spaces in name of Group?
W dniu 2014-03-07 17:44, Kevin Falcone pisze:
Now I want to search how many tickets from users in group C was
submitted to Queues that they are not responsible for, like:
Queue=“B” and Status=“new” and Requestor is in group=“C”.
RequestorGroup.Name = ‘foo’ should work
-kevin
BM
Ok, as a workaround this works
RequestorGroup.Id = 105 AND Queue != ‘MO.Mechanicy.Strefa’
(id 105 is group “MO Mechanicy Strefa” which maitain tickets in Queue MO.Mechanicy.Strefa")
Hmm, on 4.2.3, RequestorGroup.Name = ‘foo bar’ is returning tickets.
-kevin