Board to show issues from a specific project or assigned to a sprint from the same project

[Alex Paransky]

My board typically has JQL that selects all issues from the project. For example:

project = SP

However, my team sometimes needs to work on tickets from other projects.  Instead of creating a duplicate ticket in the project SP linked to the original ticket in another project, I want to put a ticket from another project in an SP sprint.  To display such ticket, the query I want to use for my board is something like: 

project = SP or sprint in SP.openSprints()  //does not work

Note that this is NOT the same as:

project = SP or sprint in openSprints() 

Since the latter returns issues in ALL openSprints across all projects.  The following does not work either:

project = SP or (sprint in OpenSprints() and Project = SP) 

As it only returns tickets for the SP project.

ScriptRunner has a function called nextSprint("board"), but it does not seem to have a function for openSprint("board").

Any suggestions?

Thanks!

[Akhand Pratap Singh]

Hey @Alex Paransky ,

Good day, Welcome to Atlassian community,

Why not use a unique labels (or field) in tickets of another project that your team needs to work on and then use that in your filter.

For e.g. for all the tickets of another project that your team needs to work on update label as SP

Now your board filter should be

project = SP or (sprint in OpenSprints() and labels = SP) 

[Alex Paransky]

That would require people to remember to label a ticket in addition to adding it to the Project's Sprint.  That's two things that could go wrong and impact visibility.

At our company, we have Virtual Teams, which are made up of individuals from different parts of the organization.  Those individuals typically work on tickets assigned from their own JIRA team.  

However, since they are part of a Virtual Team, sometimes they get assigned tickets from other projects (Virtual Projects) to be completed during their own Sprint from the team they belong to.  

I want the Scrum board for a real team to display issues from other projects (such as virtual projects) that have problems in the Project's Sprint.

So, what I want is:

project = SP or sprint in SP.openSprints()

Is there a way to do this with Script Runner, for example?  

Thanks.

PS: Yes, we could use labels, but a Sprint is very much like a "better" label as it represents exactly what I need and works well since the same ticket can be part of multiple sprints from different projects.