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 · Accepted solution]

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

[saurabh.1.jain]

Thankyou for the quick response however it gave me this error 

Error in the JQL Query: Expecting operator but got '.'. The valid operators are '=', '!=', '<', '>', '<=', '>=', '~', '!~', 'IN', 'NOT IN', 'IS' and 'IS NOT'. (line 2, character 45)

Please guide further. Thanks for the help.

[Megha Rajanna]

Can you try with this jql

project in ("aaa", "xxxxx")

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

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

AND "Work Type[Dropdown]" is EMPTY

AND (issuetype = Epic AND "Work Type[Dropdown]" is not EMPTY AND "Work Type[Dropdown]" not in ("QA", "Interruption"))

ORDER BY created DESC

Thank you

[saurabh.1.jain]

Thanks a lot Megha Rajanna. It worked. Thank you for your quick support.

[saurabh.1.jain]

The query is fine (accepted as green tick), however it is not giving the list of issue, it shows no results. Though through EazyBI i build the same query/ chart it showing the result.

Not sure if this part of your suggeted query is working as desired: AND (issuetype = Epic AND "Work Type[Dropdown]" is not EMPTY AND "Work Type[Dropdown]" not in ("QA", "Interruption")).

If you have any suggestion please do share. Thanks for all your support