JQL query

[Varvara K_]

Tell me a JQL query that will show me all tasks that do not have incoming links.

[Cristiano Alves -Appfire-]

Hello @Varvara K_ 

I'm Cristiano from Appfire Team,

The software our team works on, JQL Search Extensions for Jira can easily help you with that, with the following queries ie:

linkType = "is blocked by" AND linkType = "is duplicated by"AND linkType = <Any other outward transition you may use>

Also the following query will allow you to query for anything more specific:

issue in linkedIssuesOfQuery("project=ACME AND type = EPIC", "blocks") 

finds EPIC issues that project ACME blocks.

You are also able to query for link count, issue linked status and so on.

If you need any help to set this up, feel free to contact our support team.

Regards,

[Gor Greyan]

Hi @Varvara K_

Thanks for the question.

By saying incoming links, did you mean that no other issue links to them?

If yes, you can try the following JQL.

issueLinkType IS EMPTY

[Varvara K_]

@Gor Greyan There are inward and outward links, but I need all the tasks without inward links. 

[Gor Greyan]

Dear @Varvara K_

If you have Scriptrunner, I think this one will work

issueFunction not in linkedIssuesOf("", "is blocked by") AND issueFunction not in linkedIssuesOf("", "is cloned by") AND issueFunction not in linkedIssuesOf("", "is duplicated by") AND issueFunction not in linkedIssuesOf("", "has to be finished together with") AND issueFunction not in linkedIssuesOf("", "has to be done after")

I not, 

I guess you can just write this type of JQL, which will exclude inward types.
issue not in hasLinksOfType("blocks", "clones", "duplicates", "has to be finished together with", "has to be done after")

Couldn't find any more well solution.

[Varvara K_]

@Gor Greyan Thank you for your answer!