Need help to create JQL query for a filter

Question

Hi Team,

Here is the ask:

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

Thanks

saurabh.1.jain · Answer

No @John Funk , thanks for your follow-up. Though i got a work around through EazyBI. Thanks.

John Funk · Answer

Hi @saurabh.1.jain  - So sorry! This got buried and I lost track of it. Did you ever get this working?

saurabh.1.jain · Answer

Hi John,

Yes, you correctly interpreted, 'work type' field is a custom field used at Epic level, we have set the automatic query to flow the data from Epic level to child level. However, some child level issues the query is not working. To determine where work type field is empty at child level though at Epic level its available for those issues the logic to be run again.

I written following filter query, however it's not running:

issueFunction in issuesInEpics("'Work Type[Dropdown]' != Empty") and Project in (a, b, c....) 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

please suggest.