Jira filter that shows epics without tasks in sprints

[Ali Jacobsen]

I am using Jira cloud and need a Jira filter that shows me any epics (this is the parent issue) that are "in progress" but do not have any task, story or bugs (these are the children issues) in the current sprint or future sprints.

I have already tried the following filter:

issuetype = Epic AND status = "In Progress" AND project IN ("Project Names Here") AND "Epic Link" is EMPTY AND issueFunction not in hasLinkType("blocks") AND issueFunction not in linkedIssuesOf("issuetype in (Task, Story, Bug) AND Sprint in openSprints()") AND issueFunction not in linkedIssuesOf("issuetype in (Task, Story, Bug) AND Sprint in futureSprints()")

I am getting a return of "no results found". I know this is not correct as I added in a test epic that fulfills this criteria.

Thanks for the help!  

[Nic Brough -Adaptavist- · Accepted solution]

No, there should be no problem doing it.  Import the libraries you need into your add-on or script and run the SOAP calls as needed.

[Anil Gupta]

Thanks Nic, your input help to proceed. So writing this post successfull implementation :)

Just to add couple of points -

- I have tried with jaxws and axis(1.4) and both works fine 

- I have bundled dependencies(scope as compile) in both cases(jaxws/axis) for required jars