issueFunction in dateCompare example

Daria Pavlova_43pf7r

Dear community!

 

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! 
 

Tessa Tuteleers

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:

• keep your project conditon in front and use an empty subquery (better)

  project = Operations AND issueFunction in dateCompare("", "created +1w < firstCommented")

• add your condition as subquery (less performant)

   issueFunction in dateCompare("project = Operations", "created +1w < firstCommented")

Hope this helps!

• Tessa