I was trying to create a Quick Filter in a Sprint Board to show issues that have been added to the Sprint after it started.
I couldn't find a way to do it with regular JQL functions.
I was able to create a filter using Script Runner that does exactly what I want.
issueFunction in addedAfterSprintStart("Aida") where Aida is the name of my Sprint Board.
It works great as a Filter.
But when I try and use it as a Quick Filter for my board it doesn't like it.
Hi @stephan_lewis,
You can share an enhanced search from Scriptrunner so you can use it as a filter in a board. From Scriptrunner documentation:
If you need to use the results of your Enhanced Search filter inside a standard Jira filter such as a dashboard, Scrum, or Kanban board, then you can do this as follows:
- Create the filter on the enhanced search page.
- Save the filter and share it (This creates a copy of the filter as a standard Jira filter where we synchronise the list of issue keys returned by the enhanced search filter.)
- While you save it, select the option to sync the filter (so it remains more or less up to date)
Use the JQL below to access the results of this filter in the feature where you need to reference it (as the JQL for your quick filter, e.g.).
filter=‘NameOfHisSharedESFilter’
Hope this helps!
Hi Walter,
Thank you!!! It works like a charm.
Need to find a source for all these JQL commands that I don't know
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @stephan_lewis
ScriptRunner for Jira Cloud's out-of-the-box JQL functions are available to all users but can only be used on the Enhanced Search screen under Apps > Enhanced Search.
Below are just some examples of how you can use ScriptRunner JQL functions:
Use issuesInEpics to find all stories for open epics in a project, and then look specifically at the status of issues, such as ‘in progress.’
This indicates that this cannot be used as a quick filter.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.