Scriptrunner query wrong

[Yury Ked]

Hi everybody!

Could someone explain what is the wrong with that query?

Thanks a lot in advance!

issueFunction in dateCompare("", "resolutionDate > dueDate")

[Seifallah Bellassoued · Accepted solution]

Dear @Yury Ked

Welcome to the community!

You have 2 issues in your query:

• Sensitivity: It looks scriptrunner search is case sensitive
• Datecompare require a subquery for the first parameter

To solve that, I guess the following example:

issueFunction in dateCompare("project = TP", "resolutiondate > duedate")

Best Regards,

[Yury Ked]

Hi dear @Seifallah Bellassoued Thanks a lot! Now it works! 

How can I implement it for all projects instead particular one in account?

Instead 

project = TP

smth like 

project = *

[Seifallah Bellassoued]

project = TP is just an example of a subquery. If you want a query giving all tickets in your jira I guess the following:

issueFunction in dateCompare("created > 2000-01-01", "resolutiondate > duedate")

If my answer resolve your issue, kindly accept it!

 Best Regards,

[Kristian Walker _Adaptavist_]

Hi Yury,

The first part of the function where you have "" is an empty subquery and this is not valid in ScriptRunner for Jira Cloud.

The function expects a value to be entered in the subquery to restrict how man issues are returned.

If you enter a subquery, such as to search for specific projects, then the query will be valid.

One tip to make sure the query is valid is to click the + button at the end of the search bar and use the query builder, which will ensure you fill in the valid fields.

I have attached a screenshot of the query builder for the date compare function, which shows that a value must be entered for the subquery.

I hope this helps.

Regards,

Kristian

[Yury Ked]

Hi Kristian!
Could you please provide right subquery for that command?

issueFunction in dateCompare("", "resolutionDate > dueDate")

[Duc Thang TRAN]

Hello @Yury Ked 

It works fine in my instance data center with your query.

Can you try with  "resolved" instead of resolutionDate 

issueFunction in dateCompare("", "resolved > dueDate")

[Yury Ked]

Hi dear friend, the same error