nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ScriptRunner: cannot seem to make this work in JQL

Mircea Craciun_bv6t97

Hello, I recently enable script runner and I'm trying to filter for ticket in epics with specific due date. I tried a few JQL like below

issue in allIssuesInEpic("duedate <= '2024-07-01'")

or

parent in issuesInEpics("duedate <= '2024-07-01'")

but jira complains there is no such function as the ones I named.
What do I need to do to enable script runner in JQL? And are those the actual functions for what I am trying to do?

Thank you

Accepted answers

All comments

Trudy P Claspill

Hello @Mircea Craciun

If you have just recently added the app to your instance, you must first execute the Synch function before you can successfully get results from your searches.

https://docs.adaptavist.com/es/latest/get-started/synchronising-keywords

Then, to create a filter that uses ScriptRunner functionality you must go to the Enhanced Search screen available from the Apps menu.

Screenshot 2024-06-07 at 8.45.59 AM.png

You can't use ScriptRunner functions directly in the View All Issues or other native Jira issue filtering screens.

https://docs.adaptavist.com/es/latest/run-a-search

Next, you need to use the correct function and syntax, which you can find in the app documentation.

https://docs.adaptavist.com/es/latest/run-a-search/jql-functions#issuesinepicssubquery

issuefunction in issuesInEpics("duedate <= '2024-07-01'")

Mircea Craciun_bv6t97

@Trudy P ClaspillThank you. I see on the enhanced search window "JQL Sync Status FULLY SYNCED" so I assume that is good.
Running your proposed query there though gets no results, yet we have a lot of epics with due date June 28th 2024 (some in progress, some todo, some done) and all our tickets (bugs, stories, tasks) are assigned to an epic. (also epics with Due Date later than July 1st 2024)

Any idea what could be wrong?

Thanks.

Trudy P Claspill

Run the keyword synch then try again.

https://docs.adaptavist.com/es/latest/get-started/synchronising-keywords

Mircea Craciun_bv6t97

@Trudy P Claspill

still no luck

Screenshot 2024-06-11 094304.png

Interestingly, if I try and add the same with the helper, it shows a partial result (there should be more) but when I added that to the list, it still results in 0.

Screenshot 2024-06-11 094655.png

Lígia Zanchet

hi Mirceao

I don't know if you follow this instruction here on how to add the functions to the JQL search:

https://docs.adaptavist.com/sr4js/latest/features/jql-functions

Thanks

Mircea Craciun_bv6t97

Yes, I have. But the documentation there is misleading/incorrect. If you read the page it clearly says "You can use ScriptRunner JQL functions anywhere you are able to use Jira JQL functions" So I go to issue search, where I can use Jira JQL, copy the code form their example on that very page that reads

Use issuesInEpic to find all stories for open epics in a project, and then look specifically at the status of issues, such as ‘in progress.’

And I get
Screenshot 2024-06-19 122712.png

If I go to `ScriptRunner Enhanced Search` as suggested by Trudy above, you can see my problem, with the helper showing 31 results but actually running it returning 0.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

cloud

jira-cloud