SearchKit - Enable joins for custom fields and option groups
authorColeman Watts <coleman@civicrm.org>
Sun, 2 Jan 2022 20:00:04 +0000 (15:00 -0500)
committerColeman Watts <coleman@civicrm.org>
Sun, 2 Jan 2022 20:00:04 +0000 (15:00 -0500)
commit8ee2b510413f01ee74a17996c167f3e2f208fbb5
tree756bac0328866b02091d26330a8aef09ebf5893b
parentd49f3bcb1bfe8802753903ff58db53dee23d988b
SearchKit - Enable joins for custom fields and option groups

There are a few FKs in the database that also have a pseudoconstant.
Arguably there shouldn't be, it should be one or the other. But there they are.
Previously SearchKit would ignore those FKs, but they are needed for e.g.
searching for custom groups and displaying the aggregate count of fields in that group.
ext/search_kit/Civi/Search/Admin.php
ext/search_kit/tests/phpunit/Civi/Search/AdminTest.php