Jira Query Language (JQL): Advance search "WHERE" statement in JQL?

Question

My team is trying to resolve an issue to help find cross functional dependencies where the team is dependent on a task that is involved in another project. The issue here is dependencies track in different projects are not visible in the corresponding team's scrum board.

To the resolve the problem, the team's are required to linked the impacted issues to the related stories or epics. A dashboard will pull that information to display intra and inter project dependencies base on the query to pull related links where the related link is not equal to the Project

Proposed Query:

(project in ("PROJECT A", PROJECT B, PROJECT C ) AND issuetype in (Story, bug, Sub-task) AND (issueFunction in hasLinks("blocks") OR issueFunction in hasLinks("is depended on by")) and status != Closed) WHERE issuefunction in hasLinks != (project in ("PROJECT A", PROJECT B, PROJECT C )

To my knowledge, JQL does not have a WHERE clause. What would be the best approach to resolve this problem?

sukkeong · Answer

I don't think you can search on key prefixes.

starryeyes · Answer

I am trying build a query to that will pull intra related dependencies across different the projects. Ideally, the search return from project A where at least one of the issue keys in the related links does not share the same project key prefix as Project A.

Proposed Query:

(project in ("PROJECT A") AND issuetype in (Story, bug, Sub-task) AND (issueFunction in hasLinks("blocks") OR issueFunction in hasLinks("is depended on by")) and status != Closed) WHERE issuefunction in hasLinks != (project in ("PROJECT A", PROJECT B, PROJECT C )

Base on your explanation, the query to follow

(project in ("PROJECT A") AND issuetype in (Story, bug, Sub-task) AND (issueFunction in hasLinks("blocks") OR issueFunction in hasLinks("is depended on by")) and status != Closed) AND issuekey in hasLinks != (project in ("PROJECT A", PROJECT B, PROJECT C )

Payne · Answer

The entire JQL clause is the where clause. Simply add another AND to your proposed query, instead of a WHERE. Think of WHERE as being at the beginning of it all.