Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

We are trying to compare two date/timestamp fields using the JQL/ advanced search

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.

3 answers

3 accepted

2 votes
Answer accepted

Hi Esther,

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.

Regards,

Kristian

Hi Kristian, 

Thanks for the understanding, Seems like we don't have the script runner in our Jira cloud and is there any way where I could some kind of date comparison logic for the JQL directly without having to add the script runner.

Regards,

Esther. V

You will need an app to provide a function like that.  Scriptrunner is the only one I know off the top of my head, but I've not looked for others (As an adaptavist, I tend to have SR on tap, so I haven't needed to look)

Hi Esther,

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.

Regards,

Kristian

Hi Kristian, 

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.

Thanks.

Hi Esther,

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.

Regards,

Kristian

Hi Kristian,

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

Thanks.

0 votes
Answer accepted

issuefunction is a function in Scriptrunner, have you installed that?

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.

https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html#_troubleshooting_tips

 

Still unable to understand how we can use it as subquery as alternate solution provided in above link  . Can someone please assist on this.

0 votes
Answer accepted
Jack Brickey Community Leader Feb 01, 2021

JQL does not provide date compare capabilities. Maybe you could achieve your goal using automation. if this is a common need consider automation + custom field.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you