Need help to create JQL query for a filter

[saurabh.1.jain]

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

[John Funk]

Hi Saurabh,

What is the work type? Is that a custom field? So you don't want to get Epics, but you want issues that have certain values in a certain field in the Epic (I assume parent)?

And what are you going to do with the results? 

[saurabh.1.jain]

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.

[John Funk]

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

[saurabh.1.jain]

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