Unable to Compare timestamps fields in JIRA cloud

[Neha Dua]

Hi I need to compare two time stamps fields in Cloud JIRA  and I got script runner installed When I used the  JQL issuefunction in datecompare("", updated>created) this seems to be working in the jira server.

When tried to replicate same in Jira cloud, its throwing error- Field 'issueFunction' does not exist or you do not have permission to view it.

I checked script runner docs its saying  "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

So looking for any other way to compare 2 time stamp fields , Can someone please assist on this.

[Kristian Walker _Adaptavist_]

Hi Neha,

Thank you for your question.

I can confirm that you can only use the ScriptRunner for Jira Cloud functions on the Enhanced Search page as described in the Knowledge Base Article here.

Also, I can confirm you can see examples of how to use this query in the cloud version in the documentation page located here.

I hope this information helps.

Regards,

Kristian

[Neha Dua]

Hi Kristian ,

Thanks for quick response but we tried all options and unable to see the enhanced search page . It looks like enhanced search addon  is needed to buy separately from this script runner.We dont have that .

I can see script runner under apps , checked with admin as well.

Moreover I need to use this query in  JIRA REST API calls .

Could you please assist how I can write this query in any other way so that I can get it worked .

[Kristian Walker _Adaptavist_]

Hi Neha,

I can confirm the enhanced search add on is not needed.

Scriptrynner provides the *enhanced search* page as long as it has been turned on the Settings page which is located in your instance at <JiraCloudURL>plugins/servlet/ac/com.onresolve.jira.groovy.groovyrunner/settings?s=com.onresolve.jira.groovy.groovyrunner__settings by toggling on the ScriptRunner Enhanced Search Setting as described here.

Once this enabled you will then see this as an option In the Apps dropdown menu.

Regards,

Kristian