Here I am again searching for a help.
I am trying to use issueFunction in dateCompare in my JQL request and I am repeatedly getting errors instead of what I want.
For example I try to find issues that had not been commented within one week of creation:
project = Operations AND issueFunction in dateCompare("created +1w < firstCommented")
and I get:
Scripted function "dateCompare" compilation failure. Contact administrator and check logs. Message: The comparison must contain exactly one comparison operator which is either >, <, =, <= or >=.
Can someone give me a whole line of successful JQL request so I can repeat it with my own data?
Just cannot get how it works. Please help. Thank you!
Hi @Daria Pavlova ,
you forgot something in your syntax.
The JQL query works as follows:
dateCompare(Subquery, date comparison expression)
You added the subquery in front of the issuefunction, and jumped right to the date comparison.
You can do what you want in 2 ways:
project = Operations AND issueFunction in dateCompare("", "created +1w < firstCommented")
issueFunction in dateCompare("project = Operations", "created +1w < firstCommented")
Hope this helps!
I'm having a bit of trouble with the formatting when you try and put things with two words in the subquery
issueFunction in dateCompare("Issuetype = Planned Change AND created >= startOfYear()", "Scheduled End < Scheduled Start")
Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'Change'. (line 1, character 21)
Hi @Steve Letch,
if you want to use multi word strings, you always need to quote them, if you are already using double quotes as you are now, you can use single quotes within them.
This would look like that for you:
issueFunction in dateCompare("Issuetype = 'Planned Change' AND created >= startOfYear()", "'Scheduled End' < 'Scheduled Start' ")
Could you confirm this works for you?