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; } } }

Filter that will return a list of US that do not have a specific sub-task field?

Margaret Hodges

I am looking for some help with creating a filter that uses ScriptRunner to return results of all User Stories that do not have a sub-task with a category of QA on it.

The purpose of this filter is to help show me any US that needs a QA sub-task added to it. As of right now here is what I have started with: issueFunction in parentsOf("issuetype = Sub-task AND "Category[Dropdown]" not in ("Quality Assurance")") - but I know it is incorrect because it keeps pulling US that do have a QA sub-task on the US already.

Things to know:

This needs to work with cloud
created a custom field for subtasks called "Category[Dropdown]"

Accepted answers

Margaret Hodges

I have figured out the JQL query for this filter. Here is what I am using:
project = DEMO AND issuetype = story AND Sprint in (##) AND NOT issueFunction in parentsOf("issuetype = Sub-task AND "Category[Dropdown]" in ("Quality Assurance")")

All comments

Florian Bonniec

Hello

Have you try something like that ?

issueFunction not in parentsOf("issuetype = Sub-task AND "Category[Dropdown]" in ("Quality Assurance")") and type = Story

Margaret Hodges

Yes, I have tired that JQL query and "issueFunction not in parentsOf" is not supported in cloud. I get this error:

found "not in parentsOf(", was expecting "issueFunction in parentsOf("

Florian Bonniec

Hi,

I think on cloud, scriptrunner has his own search bar.

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

It's not dynamic either, you run the query in script runner then save it, it will store the results but will not be updated automatically if an new issue match your query.

Margaret Hodges

Yes, you are correct and I tried that JQL query in the ScriptRunner Enhanced Search and it does not like "not in parentsOf("

Margaret Hodges

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud