issueFunction in issuesInEpic() function causes issues with starting sprints

Question

(issueFunction in issuesInEpics("project = TEST") AND status not in (closed, resolved)) OR (project = TEST AND status not in (closed, resolved)) ORDER BY Rank ASC

Above is the JQL I'm using with the added JQL from ScriptRunner. The problem is when using this query on a board users who have manage sprint permissions in the projects are unable to create a sprint. It seems this is because Jira doesn't know what projects are being pulled so the user would need permissions in all the projects. Is there a way to modify this query so Jira recognizes the projects associated?

Raynard Rhodes_y6vawn · Answer

Yep the user has permissions for every project that appears in the board.

Raynard Rhodes_y6vawn · Answer

Looking at the backlog. There are roughly 58 issues in it (more are added as time goes on). Each respective project the issues reside in the user has Manage Sprint permission.

I'm not sure what is the difference between what you're telling me at the end and what I've posted above.

Nic Brough -Adaptavist- · Answer

No, that's not true, it doesn't matter where it falls in the conjunction of the AND.  You've also got the problem that an Epic in Test could also draw in an issue from any project.

You need to explicitly limit the entire query to projects that your people have permissions for.  Might be simplest to take your original query and just say "project in (a, b, c) AND <your query>"