Kanban - Combine two projects, with additional filtering from one of them

[Ben Øye]

Case: We run Project for specific customers, with kanban boards, and we have a combined project with incoming support for all of our customers. The support project uses a field "organizations" to organize incoming requests.

Question: How to do a combined kanban - 

"project in (Customer,Support) and limit results from support to organizations = customer

My initial but misled test was: 
project in (customer,support) and Organizations in ("customer") ORDER BY Rank ASC , this will not work as "organizations" is only present in the support project, not in the specific customerproject.

What i believe is needed is something in the line of:

project in (customer,(support where organizations in customer))


Edit 1: project in (customer,support) and reporter in organizationMembers("customer") got me a bit further, but not showing all relevant cases from the customer project as some reporterts might be internal from our side.

[Karim ABO HASHISH · Accepted solution]

Hello Ben

You may try the below JQL

(project = customer) OR (project = support and organization = customer ) ORDER BY Rank ASC

[Ben Øye]

@Karim ABO HASHISH Thank you, that did the trick. Considered "OR", but felt I was on thin ice as it was.

[Karim ABO HASHISH]

@Ben Øye you're welcomed, glad it worked for you