Hi, we have made some recent changes to our team's boards. On our main shared board, I have adjusted the filter to include nearly all issues in the project. However, issues with an empty component field are excluded from the backlog view, and I am unsure why this is.
I have tried the filter in two ways. One in which I make no mention of components to include (assuming it would include all issues this way). This also excludes the 4 components we don't want to be included:
project = GKCS AND component not in (deletion-candidate, Parking-lot, PBB, RevOps) ORDER BY Rank ASC
And another in which I specify all components except 4 we don't want. This also excludes the 4 components we don't want to be included:
project = GKCS AND component in (EMPTY, Accounts, "Bug - Automation", "Bug - Customer", "Bug - Internal", "Bug - RC", Chargebee, "Cloud Profiles", collect-feedback, GIJ-HubSpot, gitkraken.dev, "GK Boards", "GK CLI", "GKCS Preview Environment", GKDS, grader.gitkraken.com, HubSpot, Insights, Integrations, Purchasing-problems, QA, Renewal-problems, service-request, SSO-problems, Switching-problems, "Team Collaboration", TeamsTierPlan, Technical-problems, Trial-problems, User-Account-deletion-problems, User-Account-management-problems, User-Account-reactivation-problems, WorkSpaces) AND component not in (deletion-candidate, Parking-lot, PBB, RevOps) ORDER BY Rank ASC
Again, both of these exclude issues whose component field is empty. Thank you for your time and help!
Hello @Grady
When you include in your criteria a field that can have 0..n values in it, if you want to include the issues that have zero values then you need to include in the filter:
(components not in (<values>) or component is empty)
When the criteria is evaluated by it will compare you list of values to the values in the field. If the field has no values then Jira cannot do the comparison, therefore the issue with the field empty is excluded.
You need to include components is EMPTY when you are searching on the component field (unless you negate that part). So in order to include issues with no components your first query should look like this:
project = GKCS AND (component not in (deletion-candidate, Parking-lot, PBB, RevOps) OR components is EMPTY) ORDER BY Rank ASC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you use negate then the query would look like this:
project = GKCS AND not (component in (deletion-candidate, Parking-lot, PBB, RevOps)) ORDER BY Rank ASC
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.