Need help with JQL query

Question

Hi Team,

Observing difference in results on Grouping issueFunction
Query#1 :
((project = cis AND type = "Change Request" OR project = "Digital Operations - PMO" AND type = Bug) AND created > 2018-01-03 ) AND issueFunction in dateCompare("", "created +14d > resolved ") AND priority in (High) -> Loaded 39 tickets

Query#2 :
((project = cis AND type = "Change Request" OR project = "Digital Operations - PMO" AND type = Bug) AND created > 2018-01-03 ) AND ( issueFunction in dateCompare("", "created +14d > resolved ") AND priority in (High)) -> Loaded 0 tickets

Not sure why there is difference when query with issueFunction is grouped with Priority.

Appreciate any help here!

Thanks in Advance!
Deepa

Deepa Tantry · Answer

Thanks for your time Steckler.
This was resolved when using the below JQL

(((project = cis AND type = "Change Request" OR project = "Digital Operations - PMO" AND type = Bug) AND created > 2018-01-03 ) AND issueFunction in dateCompare("", "created +14d > resolved ") AND priority in (High)) 
OR
(((project = cis AND type = "Change Request" OR project = "Digital Operations - PMO" AND type = Bug) AND created > 2018-01-03 ) AND issueFunction in dateCompare("", "created +7d > resolved ") AND priority in (Highest, Critical)

Regards,
Deepa

Josh Steckler · Answer

If you look just at this part:

( issueFunction in dateCompare("", "created +14d > resolved ") AND priority in (High))

Does it come up with any results?

Then this part:

((project = cis AND type = "Change Request" OR project = "Digital Operations - PMO" AND type = Bug) AND created > 2018-01-03 )

If there are any issues that show up in both, then that's your result.

Basically, looks like there were no high priority issues resolved more than 14 days after creation.