Subitems filters are incorrectly filtering out Parent items on Dashboards

Description:

On a dashboard, in a table widget with filters set against parent & subitems items on the linked boards. If the parent item doesn’t have any subitems for the filter to test, then the parent items just gets excluded completely. This certainly seems like unintended behaviour.

Scenario to reproduce:

  1. On a Dashboard, the items from each each linked board may or may not have 1 or more subitems (which are ‘next actions’ for the parent task).

  2. Inside a Table Widget, I added filters to show any (parent) items across all boards with ‘Status = Actionable’ from each board. No problem.

  3. I also put a filter on the Subitem status where [text is not = done]. So if a (parent) task has 8 next actions, and 5 have status = Done, I only want to see the 3 remaining.

This all worked fine. Except then I noticed some items had Actionable but were not showing up at all. After banging my head on the desk for a while, I realized the ones that weren’t showing had no subitems created. When I deleted the [subitem status text is not = done] filter, all of those Actionable items appeared.

So it seems like if there are no subitems for the [text is not = subitem] filter to test, it just fails the whole parent item.

To clarify:

  • A [Status = Actionable] parent item with 3 subitems, 2 of which are ‘done’, correctly appears, with it’s 1 remaining subitem underneath.

  • A [Status = Actionable] parent item with 3 subitems - all 3 of which are Done, correctly does not appear, since it’s components are all done.

  • A [Status = Actionable] parent item with no subitems yet created, is incorrectly ommitted, because it does not fail the test of subitem status. It’s only crime is having no subitem for the filter to test.