Hi,
Not a pro in using OQL, so mine are fairly simple ones, but I did not expect following result.
Displaying critical priority tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("1")
--> This works fine
Displaying high priority tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("2")
--> This works fine
Displaying normal priority tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("3") --> This results in no tickets displayed at all ???
Displaying normal low tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("4")
--> This works fine
I must be overseeing something: I'm cycling through the priority codes, copying the OQL code for each one of them and for 3 (which should have the largest number of tickets, there's no result at all.
A bug?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
My bad - I did a manual search (could not believe the result) and saw that most tickets are low prio. The ones that do have normal prio, are either closed or resolved and I am filtering those tickets...
(non) Issue resolved !
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
Not a pro in using OQL, so mine are fairly simple ones, but I did not expect following result.
Displaying critical priority tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("1")
--> This works fine
Displaying high priority tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("2")
--> This works fine
Displaying normal priority tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("3")
--> This results in no tickets displayed at all ???
Displaying normal low tickets:
SELECT UserRequest AS i WHERE status NOT IN ("closed", "resolved") AND priority IN ("4")
--> This works fine
I must be overseeing something: I'm cycling through the priority codes, copying the OQL code for each one of them and for 3 (which should have the largest number of tickets, there's no result at all.
A bug?
My bad - I did a manual search (could not believe the result) and saw that most tickets are low prio. The ones that do have normal prio, are either closed or resolved and I am filtering those tickets...
(non) Issue resolved !