APIv4 - Use subquery to LEFT JOIN via a bridge entity
authorColeman Watts <coleman@civicrm.org>
Thu, 18 Mar 2021 01:53:31 +0000 (21:53 -0400)
committerColeman Watts <coleman@civicrm.org>
Sun, 21 Mar 2021 21:29:17 +0000 (17:29 -0400)
commit7fa016f8bfbb3b52790b230eb353536a26763b19
tree6575c659ee866c63af94536b25524e898b5e3573
parent277fbb30744aa1222b7ae0ca6739de767f8af3e1
APIv4 - Use subquery to LEFT JOIN via a bridge entity

Bridge entities are supposed to be transparent in APIv4, but when LEFT joining,
an artifact of the double-join would give extraneous results.
Civi/Api4/Query/Api4SelectQuery.php