You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
When we used the issuefunction in datecompare("", updated>created) this seems to be working in the jira server. When tried to replicate same in Jira cloud, the issuefunction is missing in the JQL. Is there a way to compare two custom Timestamp fields.
I can confirm that ScriptRunner for Jira Cloud provides the dateCompare() JQL function as documented here that can be used for searching against dates and the documentation page linked provides examples of how to use this query in Jira Cloud.
Also it is worth noting in Jira Cloud the enhanced search queries can only be run on the enhanced search page as documented here.
I hope this information helps.
I can confirm you will need an App as Nic has said as this kind of query is not possible out of the box in Jira Cloud.
If you do not want to purchase the full ScriptRunner for Jira Cloud App then you can look at our Enhanced Search app which provides just the JQL functions.
I hope this helps.
Checked in the settings and found that the script runner is added to the system but somehow we are unable to find the issuefunction in (datecompare("","") functions and expressions in jira cloud. Any suggestion as to how I can get it working in the advanced search.
Can you please confirm are you running these on the Enhanced Search page inside your instance at the URL of <JiraCloudBaseURL>/plugins/servlet/ac/com.onresolve.jira.groovy.groovyrunner/jql-search-view as the JQL functions can only be run on the Enhanced Search Page in Jira cloud as described here.
You can then see details of how these filters can be used to power Agile boards or dashboards inside of the Knowledge Base Article located here.
Should I have the enhanced search plugin also to run the query in the script runner enhanced page. Because tried to navigate to scriptRunner enhanced page but could not locate the same. and the above url that you provided is also not working. (<JiraCloudBaseURL>/plugins/servlet/ac/com.onresolve.jira.groovy.groovyrunner/jql-search-view). it is not loading
Yes script runner is installed in JIRA however I and Esther found that "the date compare function in the middle of the expression is not natively supported by JIRA Cloud. "
mentioned in below link.
Still unable to understand how we can use it as subquery as alternate solution provided in above link . Can someone please assist on this.
To expand on a previous suggestion, here is how to do it with automation, without ScriptRunner:
Now you can use JQL to compare the two number fields.
An alternative option is to create a Smart Value that compares the fields (using the "compareTo()" function), set it to a new number field called 'CreatedVsUpdated' and then you can use it in the JQL. See here .
With both soultion you need to decide when to trigger the automation, and that depends on your needs.
The simplest triggering would be on an update of either of those two fields.
Caveat: I have not tested the above solutions.
Sorry for bothering you with the question but can you please give me an example of how issueFunction in dateCompare("", updated>created) worked? I am trying to use this but get the error:
Error in the JQL Query: Expecting ')' or ',' but got '>'. (line 1, character 67)
I mean the whole JQL line as an example so I can repeat with my data.