Skip to main content
Skip table of contents

How to find issues where company has/hasn't other issues?

Sometimes we want to find issues, where company has or hasn't other issues. For example, at Teamlead we have projects Deals. There we track Deals (issues). And we have another project - Hosting, where we track hosting Instances (issues). So, we want to see Instances, which have no any Deals in status Delivery to control payments etc.

To resolve this requirement we'v add special JQL operator into CRM:

id not in issuesByField(Company, "ANY JQL")

Let's have a look at full example of JQL:

project = HOSTING AND issuetype = Instance AND status = Работает AND "Режим работы" = Промышленный AND id not in issuesByField(Company, "project = DEAL AND issuetype = Deal AND status = Delivering AND Department = {(119)}")

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.