Hello,
I have the following set up
Project 1 - 10 jira issues ( My project)
Project 2 - 1000 Jira issues
We create a relates to links from issues in Project 1 -> Project 2
Project 2 has many internal links between issues which I don't care. I only want to retrieve the issues in Project 2 that are linked to issues in project 1 and display it in a confluence table.
currently, i have to use the following two queries which retrieve quite a lot of unwanted issues of project 2 and then as a second step see which are linked to Project 1 issues.
Query 1: issueLinkType = "relates to" AND (project="Project 1" OR project = "Project 2") <-- gives 1000 issues
Query 2: project = "Project 1" and issuetype = "PI Objective" <--- returns the 10 Issues created
Following this I merge the two tables using a vlookup. which then gets only the entries i need. I need to optimize query 1 just to retrieve the issues that has a "relates to" relationship with the issues in Project 2
Is there a JQL query that I could use just to retrieve the 10 or more linked issues from Project 2.
Thanks in advance for your proposals
