making a jql with script runner epics and issues

Question

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?

Jon_4n6t23 · Answer

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

Petter Gonçalves · Answer

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_4n6t23 · Answer

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")