making a jql with script runner epics and issues

[Jon]

How would I construct a filter that would search for all epics excluding for epics that have issues linked to it in a particular status? Moreover, the filter we are trying to construct would contain all epics (our names for the different types of epics are  open contracts and closed contracts) as long as the issues linked to it are not in a particular status (paid).  

Does anyone have an idea on to contstruct this? 

[Petter Gonçalves]

Hello Jon,

Unfortunately, this query cannot be performed natively on JIRA, however, you can use Scriptrunner plugin to perform it:

Issuefunction in linkedIssuesOf("status != paid", "has Epic")

Please, check the similar question in the link below to better understand it:

JIRA query that returns all Epics that contain an issue that is assigned to me

[Jon]

How do I type the Jql  for this. basically its the opposite of the above. It says the jql is valid there are no results and there should be dozens. basically I want to get all epics if any of the issues linked to it are not in the paid status. here are some screen shots too. thanks. 

 issueFunction in linkedIssuesOf("status in (Loaded, Assigned, Sailed)", "has Epic")

[Petter Gonçalves]

Hello Jon,

Actually, the query I've sent previously should be returning the query as you need. Please, note that I used the not equal parameter (!=):

Issuefunction in linkedIssuesOf("status != paid", "has Epic")

Can you please copy/paste this exact query and provide us the screenshot of the results?

[Jon]

its a valid function but doesn't give any results..