JQL does'nt obey date

[Edimara]

Hi


I have the follow structure in Jira:  Iniciativa > Epic > Story/Task

I create this JQL to bring all issues under Iniciative  until story/task level, but it seems that exists something wrong at my logic


(issueFunction in linkedIssuesOfAllRecursiveLimited("project = INI AND STATUS NOT IN (Cancelado) AND created >= 2020-01-01", 2) OR (project = INI AND created >= 2020-01-01 AND STATUS NOT IN (Cancelado))) AND status not in (Removed)

[Tim Perrault · Accepted solution]

Hi @Edimara 

The problem is probably with the issueFunction part of the JQL. You are asking for the linked issues for the query you have. So when you are searching for issues in that date, it will find them and then query will follow all links, recursively, from the issues it found until it has traversed a maximum of 2 links deep along any link path.

Thanks,

Tim

[Tim Perrault]

(issueFunction in linkedIssuesOfAllRecursiveLimited("project = INI AND STATUS NOT IN (Cancelado) AND created >= 2020-01-01", 2) AND created >= 2020-01-01 OR (project = INI AND created >= 2020-01-01 AND STATUS NOT IN (Cancelado))) AND status not in (Removed)

Adding AND created >= 2020-01-01 after the issuefunction should work in this case

[Edimara]

Thanks @Tim Perrault 

Works perfectly