Add 'Is empty (NULL)' and 'Is not empty (NOT NULL)' operators to boolean field filtering

* Other option, create a View with an optional relationship to something that has a boolean field. In the rows that don't have the relationship the values will be NULL

As Lendude mentions here this is a massive gap in the current boolean filter logic, take the following scenario:

I have a View that lists multiple bundles of the same entity type, one of those bundles has a boolean field. I want to be able to filter the view to only show records that don't have that field (all but one of the bundles), or have a false value for the field. This is currently unachievable.

To my mind this is the main use case we are solving here.

+1 for the patch in #9.

Managed to successfully use the patch to acheive the above use case. I used an OR filter group containing a = FALSE condition and a IS NULL condition. Worked perfectly, thanks!

+1 for the patch in +9.

It worked perfectly to provide new operator options "Is empty (NULL)" and "Is not empty (NOT NULL)" inside of the Views Filter Criteria section.

Re-rolled patch for Drupal 10.3

Doh! Of course the patch failed to apply for 10.1.

sokru → changed the visibility of the branch 11.x to hidden.

sokru → changed the visibility of the branch 10.1.x to hidden.

I picked up this instead of ✨ Add 'Is empty (NULL)' and 'Is not empty (NOT NULL)' to field filter operators Needs work since this has working tests. Otherwise the "Proposed resolution" section seems rather identical with these two issues, calling for closing either of these or refining the issue summary.

I marked ✨ Add 'Is empty (NULL)' and 'Is not empty (NOT NULL)' to field filter operators Needs work as PNMI for someone to confirm this ticket fixes the same issue, if not that issue should specify what didn't make it.

For this ticket

Ran the test-only feature

1) Drupal\Tests\views\Kernel\Handler\FilterBooleanOperatorTest::testEmptyFilterBooleanOperator
Failed asserting that actual size 6 matches expected size 1.
/builds/issue/drupal-3322402/core/modules/views/tests/src/Kernel/Handler/FilterBooleanOperatorTest.php:161
FAILURES!
Tests: 3, Assertions: 13, Failures: 1.

Show the test coverage.

Checking the issue summary, it appears complete with a matching solution to the MR.

Looking at the code I applied some small typehints for the new functions and the test.

I left dataSet and schemaDefinition as those are inherited and probably could be a standalone ticket for applying throughout the repo.

Rest appears to do as advertised.

Nice to see these small features still getting attention, I've needed this before on a similar project and had to patch in support for it.

Committed b6c0243 and pushed to 11.x. Thanks!

Not eligible for backport as it's a new feature, anything building on this has to be targetted at 11.1 and above only.

Automatically closed - issue fixed for 2 weeks with no activity.