SearchKit - Apply filters to ON clause of EXCLUDE joins
authorColeman Watts <coleman@civicrm.org>
Wed, 7 Apr 2021 03:38:10 +0000 (23:38 -0400)
committerColeman Watts <coleman@civicrm.org>
Wed, 7 Apr 2021 03:38:10 +0000 (23:38 -0400)
commite8a5372844942ed0764f02f1a02307877a62f94c
treef2baa531964f41b1c4e43b54686733b9b2511f84
parent5da82bb19c8419507ef98a4db15d6466a1f526a1
SearchKit - Apply filters to ON clause of EXCLUDE joins

Filters usually get applied to the WHERE clause, but in the case of EXCLUDE joins,
they will never be available (because their results are excluded).
So it makes more sense to add them to the ON clause of the join itself.
ext/search/Civi/Api4/Action/SearchDisplay/Run.php