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 to pull subtasks when status of parent in "Seeking Approval"

Michelle Larson

I am trying to get a list of subtasks that are in open or reject only when the parent is in "seeking approval" I tried the following but keep getting errors on it. (I do have scriptrunner)

Error in the JQL Query: Expecting ')' or ',' but got 'TCRM'. (line 1, character 141)

project = TEST AND issuetype = Enhancement AND status = "Seeking Approval" AND issueFunction in subtasksOf("project = TEST AND issuetype = "TCRM - Dev Approval" AND status in (Open, Rejected)")

Accepted answers

Udo Brand

Use single quotes within double quotes or vice versa

project = TEST AND issuetype = Enhancement AND status = "Seeking Approval" AND issueFunction in subtasksOf("project = TEST AND issuetype = 'TCRM - Dev Approval' AND status in (Open, Rejected)")

All comments

Udo Brand

Use single quotes within double quotes or vice versa

project = TEST AND issuetype = Enhancement AND status = "Seeking Approval" AND issueFunction in subtasksOf("project = TEST AND issuetype = 'TCRM - Dev Approval' AND status in (Open, Rejected)")

Michelle Larson

This does not give me an error however it is not returning the subtasks that are either open or rejected when the parent is in seeking approval

Michelle Larson

I also tried this and it still does not return anything

project = TEST AND issuetype = 'TCRM - Dev Approval' AND status in (Open, Rejected) AND issueFunction in parentsOf("project = TEST AND issuetype = Enhancement AND status = 'Seeking Approval'")

However if i just use the sub queries they each return tickets.

Udo Brand

Is Enhancement a subtask and "TCRM - Dev Approval" the parent issue? If not try:

project = TEST AND issuetype = 'TCRM - Dev Approval' AND status in (Open, Rejected) AND issueFunction in subtasksOf("project = TEST AND issuetype = Enhancement AND status = 'Seeking Approval'")

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira