Structure of Issue type with no Children

[Yaniv L]

I have two types of issues - 'Contract' and 'Sys HLR'.

'Sys HLR' are always children of 'Contract'

I would like to have a query of all 'Contract' issues which don't have a linked (child issue) of 'Sys HLR'.

I saw an option of issueFunction not in parentsOf ("issuetype = ABC") and tried to apply it like that:.

Type = 'Contract' and issueFunction not in parentsOf ("issuetype = 'Sys HLR'")

But it did not work.

How should I write it? 

[Trudy Claspill]

Hello @Yaniv L 

Welcome to the community.

When you created the custom issue "Sys HLR" did you make it a Sub-task type of issue? Or can a Sys HLR issue be created without a parent?

What error message did you get with the query that you tried?

Are you using Jira Cloud or Jira Server/Data Center?

Do you have the third party app Scriptrunner for Jira installed on your Jira system? "issueFunction not in parentsOf()" is a feature that is not natively available in Jira. ScriptRunner is a third party app that provides that function. If you don't have Scriptrunner than trying to use that function would generate an error.

[Yaniv L]

Solved it with the following:

issuefunction not in hasLinkType("Parent-Child Link") and issuetype = Contract