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)")

[Udo Brand · Accepted solution]

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'")

[Michelle Larson]

That worked great thank you.

[Ryan An]

super helpful!!