Find all the tickets from the specific project that were part of a sprint that starts with other

[Lakshmi S]

Hi Team,

I would like to find all the tickets from the "XXX" project that were part of a sprint that starts with "AR" or to be more specific were part of a sprint in the AR project.

I'm wanting to find out how many points from the "XXX" project have been done within AR project sprints.  

I tried to find out with the below jql query for 3 years sprints, but its showing other projects tickets also in the results, we just need "XXX" project tickets.

We have script runner addon.

project = XXX AND (issueFunction in completeInSprint("AR Project Backlog", "AR.2023.1.4") OR issueFunction in completeInSprint("AR Project Backlog", "AR.2023.1.5")) etcc