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

JQL Query

Matthew_1tb4t1

Can anyone correct the "and belongs to" syntax for the following (2) JQL queries:

project = "IT " AND issuetype = Story not in (Done, Canceled)
and belongs to Epics in (Done, Canceled)

project = "IT " AND issuetype = Epic not in (Done, Canceled)
and belongs to Initiatives in (Done, Canceled)

Accepted answers

All comments

Hitesh_ym5avq

Hello @Matthew

The JQL would look like this.

issuetype in (Story, Task, Sub-task) AND status = Open AND "Epic Link" in (done, canceled)

NOTE: That the Epic Link field should be the exact name of the field in your Jira instance that links issues to epics.

Let me know if this helps.

Reagrds,

Hitesh.

Matthew_1tb4t1

Hi Hitesh,

I really appreciate your prompt reply

I confirmed "Epic Link" is the correct syntax in our Jira.

There seems to be a problem with the "in" at the end of the query, where it wants to point to a specific Epic, instead of a status:

Matthew_1tb4t1

please disregard

Hitesh_ym5avq

I apologize for the confusion. You are correct that the in operator cannot be used with a status value. Instead, we can use the OR operator to search for issues that belong to Epics that are either done or canceled. Here's an updated query that should work: