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

What is wrong with this query

Bonnie Lopes

project = MOM AND component = "D. Delivery excellence (governance & risk)" and (issueFunction in issuesInEpics (Component in ('D. Delivery excellence (governance & risk)'))) or issueFunction in subtasksOf("issueFunction in issuesInEpics(component ="D. Delivery excellence (governance & risk)")) ORDER BY "Epic Link" , key DESC

I am trying to return all issues with they subtasks, by epic, for project: MOM and Component: D. Delivery excellence (governance & risk)

Accepted answers

Parvaneh Zand

Hi @Bonnie Lopes ,

first part (before OR) is true, but you should remove component = ... , because the query contains it's name.

second part is actually trying to get the subtasks of the first part,

so I saved this query as a Filter (e.g. Filter = issues)

issueFunction in issuesInEpics(Component in ('D. Delivery excellence (governance & risk)'))

then I used this Filter in JQL :


project = MOM AND ((issueFunction in issuesInEpics(Component in ('D. Delivery excellence (governance & risk)'))) or (issueFunction in subtasksOf("Filter = issues"))) ORDER BY "Epic Link" , key DESC

All comments

Parvaneh Zand

Hi @Bonnie Lopes ,

first part (before OR) is true, but you should remove component = ... , because the query contains it's name.

second part is actually trying to get the subtasks of the first part,

so I saved this query as a Filter (e.g. Filter = issues)

issueFunction in issuesInEpics(Component in ('D. Delivery excellence (governance & risk)'))

then I used this Filter in JQL :


project = MOM AND ((issueFunction in issuesInEpics(Component in ('D. Delivery excellence (governance & risk)'))) or (issueFunction in subtasksOf("Filter = issues"))) ORDER BY "Epic Link" , key DESC

wonga

Struggled with a similar JQL yesterday had to understand the in instead of =

Parvaneh Zand

When you know the exact value of a field, use '=',

 issuetype = Task

otherwise use 'in' to search within multiple specified values or sub-queries.

issuetype in (Task,Story)

issueFunction in hasSubtasks()

which provides all the issues with sub-tasks.

Bonnie Lopes

First I want to say thank you for the responses, this is a critical ask of me and I just can't seem to get the syntax correct.

Tried creating the first filter as suggested: issueFunction in issuesInEpics(Component in ('D. Delivery excellence (governance & risk)')) and received this syntax error: Error in the JQL Query: Expecting ')' or ',' but got 'in'. (line 1, character 42), which is the same error I was getting.

Tried changing to use = instead of in, but received the same error in the same place: Error in the JQL Query: Expecting ')' or ',' but got '='. (line 1, character 42)

Couldn't even try the second part as I could not get the first query to save

Welcome!

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

Quick Links

Find more posts tagged with

server

jira

jira-server