APIv4 - Add UNIQUE flag to GROUP_CONCAT
authorcolemanw <coleman@civicrm.org>
Sat, 19 Aug 2023 20:07:38 +0000 (16:07 -0400)
committercolemanw <coleman@civicrm.org>
Tue, 5 Sep 2023 02:32:02 +0000 (22:32 -0400)
commit6ec95aa2e6184ea7add34b77ec1f2b5ee878d925
tree2ae1f9b26ec1983cdc5d8c40f6662d620b91f010
parentb04fc44bda46ea3332e74422a9f706f39677ed38
APIv4 - Add UNIQUE flag to GROUP_CONCAT

Unlike DISTINCT which dedupes by the value of a field, UNIQUE will dedupe by the id of the record
15 files changed:
Civi/Api4/Query/Api4EntitySetQuery.php
Civi/Api4/Query/Api4SelectQuery.php
Civi/Api4/Query/SqlBool.php
Civi/Api4/Query/SqlEquation.php
Civi/Api4/Query/SqlExpression.php
Civi/Api4/Query/SqlField.php
Civi/Api4/Query/SqlFunction.php
Civi/Api4/Query/SqlFunctionDAYSTOANNIV.php
Civi/Api4/Query/SqlFunctionGROUP_CONCAT.php
Civi/Api4/Query/SqlNull.php
Civi/Api4/Query/SqlNumber.php
Civi/Api4/Query/SqlString.php
Civi/Api4/Query/SqlWild.php
Civi/Api4/Utils/FormattingUtil.php
tests/phpunit/api/v4/Action/SqlFunctionTest.php