JIRA filter for specified projects.

[Jacob A. Albrektsen]

Hi All 

Can someone maybe help me define if this problem is feasible?

Problem: 
I have a Kanban board, that picks up issues (tasks) from other projects, to have an overview over our activities in our team (Teammates, is assigned to different squads). and the problem is that I want to filter on assignees in all filters for all boards. But for the main board (Testtask Kanban), i need to filter for unassigned as assignee, but exclude filtering for unassigned in all other projects as this gives over 3K issues in all types. 

My Query:
project in (CVS, TESTTASK, CONFIG, BMRT, CLMO, CLOUDPBX, CONSUMEMRT, FVS, SD) AND assignee in (557058:9907387c-75f1-4623-b34d-1e7a699a18cd, 557058:1921ca58-3d3b-4bdf-b182-fc9cf570769a, 557058:59cbdaec-d489-4e0d-97b6-4fb45d1660e4, 5ad7040134f1e62b1ac936b2, 557058:9ead326b-8b14-443f-8d12-2ba1221ff03f, 557058:1b2282e0-7472-4ad9-8409-09b04f50582d, 5a03255c7569444230692387, 557058:502cc2cb-7fef-4e27-8285-e149ab72637f, 5ad70400e378d62b3bb40e54, 557058:83e8abef-4abf-4cb2-996b-a1d88bafea20, 557058:58afdcc4-d821-49ed-9116-3789a935b5d7) ORDER BY created DESC

[Trudy Claspill]

Hello @Jacob A. Albrektsen 

Modify your filter thus:

Remove TESTTASK from the list of projects.

Add another clause thus before the ORDER BY

OR project=TESTTASK

That will result in the first clause gather issues only for the assignees in the 8 specified projects and the second clause gather all issues in TESTTASK regardless of whether or not they are assigned.

[Jacob A. Albrektsen]

IT WORKS! 😀
Thanks @Trudy Claspill I have been spending a lot of time trying to get this, not even chatGPT could resolve it for me 🤣

[Trudy Claspill]

I'm glad I could help you @Jacob A. Albrektsen 

Please consider marking the Answer as Accepted to help other users find the posts that have working solutions.