I was creating a JQL query to fetch issues for an EPIC, The EPIC field called work type is not empty

saurabh.1.jain

Hi Team,

I want to create filter so was creating JQL query: to extract list of issues with issue type (Story, Spike, Enhancement, Defect) and with status "In Progress" and "To Do" and with Issue work type is blank but whose Epic's work type is non- blank and doesn't include "QA" and "Interruption" as work type. Please suggest.

Work Type is a customized filed used (similar to Label).

I created this but its not running:

issueFunction in issuesInEpics("'Work Type[Dropdown]' != Empty") and Project in (xxx, aaa) AND "Work Type[Dropdown]" = Empty and "Epic Link" != EMPTY AND type in (Story, Spike, Enhancement, Defect) and status not in (Done, Closed, Dropped, Rejected) and created<=120d  ORDER BY created DESC

Megha Rajanna

HI @saurabh.1.jain 

To create a JQL query that meets your criteria, you can use the following approach:

 

JQL QUERY:

project in (xxx, aaa)

AND type in (Story, Spike, Enhancement, Defect)

AND status in ("In Progress", "To Do")

AND "Work Type[Dropdown]" is EMPTY

AND "Epic Link" is not EMPTY

AND "Epic Link".[Work Type[Dropdown]] is not EMPTY

AND "Epic Link".[Work Type[Dropdown]] not in ("QA", "Interruption")

ORDER BY created DESC

This JQL query should retrieve issues that meet the following criteria:

 

Belong to projects with keys "xxx" or "aaa".

Have issue types Story, Spike, Enhancement, or Defect.

Are in status "In Progress" or "To Do".

Have an empty "Work Type[Dropdown]" field.

Have a non-empty "Epic Link" field.

The linked Epic's "Work Type[Dropdown]" field is not empty.

The linked Epic's "Work Type[Dropdown]" field is not "QA" or "Interruption".

Make sure to replace "xxx" and "aaa" with the actual keys of your projects.

THANK YOU