story with at least two subtasks with certain fields

[Caro]

Hello I need JQL help.

Story with at least one subtasks with issueFunction in subtasksOf ("cf [10229] = xx") and at least one subtasks with issueFunction in subtasksOf ("cf [10229] = xy")

Thank you so much!

[Suvarna Gaikwad · Accepted solution]

@Caro Please use below JQL

type=Story AND issueFunction in parentsOf("project = projectname and type = Sub-task and cf[10229] in (xx,xy)")

[Caro]

Throughout the whole, I'm looking for subtasks with a specific field where the parent story has at least one subtask with a specific other field.

Idea:

Filter 1: issuetype = Story AND issueFunction in subtasksOf("cf[10229] = xy") 

Filter 2: issueFunction in subtasksOf("filter = 'Filter1'") AND cf[10229] = xx