Unable to Compare timestamps fields in JIRA cloud

Question

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_ · Answer

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

Neha Dua · Answer

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_ · Answer

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