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.