Trying to get a 'simple' query which should return anything without any linked tickets

Sascha Wiltenburg

Hi all, so I'm trying to get a 'simple' query which should return anything without any linked tickets attached, like this:

project in (A,B,C,D,E,F) AND statusCategory not in (Done) AND reporter in (reporterA,reporterB,reporterC) AND issueFunction not in hasLinks() ORDER BY created ASC, key ASC

However, somehow it returns an X amount of tickets, of which still several have some linked ticket?

Anyone more familiar with this or another solution?

Regards, Sascha

(Jira Software 9.4.18)

Kindly note: Also I'm missing 2 tickets which do meet the requirements, but are not showing in my results?

Radek Dostál

I think it'd be good if you can "prove" the faulty results by including screenshots (anonymized ofc, we don't need to know the actual issue data), but to see the linked issue tab, what type of link it is, what the category is, and so forth.

My first thought would for instance be around `hasLinks()`, perhaps you're seeing remote links (which should be ignored by that function iirc) or epic links (separate tab with epics but still a possibility).

Second step would be to isolate individual JQL clauses to see which "doesn't work".

Such as if you have an issue ABC-5; which you expect to either show up or not - then you could try the jql as 

```key = ABC-5 AND ...``` and basically try each JQL clause until you find out which one doesn't work the way you think it should.

 

Once you identify which JQL clause specifically doesn't work then it's easier to figure out why. Perhaps incorrect status category, perhaps a broken index, perhaps something else entirely.