JIRA filter for specified projects.

Question

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 P Claspill · Answer

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.

Jacob A. Albrektsen · Answer

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

Trudy P Claspill · Answer

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.