APIv4 - Add GROUP_FIRST aggregate function
authorcolemanw <coleman@civicrm.org>
Thu, 16 Nov 2023 01:12:18 +0000 (20:12 -0500)
committercolemanw <coleman@civicrm.org>
Fri, 17 Nov 2023 14:32:14 +0000 (09:32 -0500)
commit38f2f84a7875c3108d8268032282aae991587afd
tree330f5139573a7d8f636f351ea7a5f4db4b34adc3
parentae84a37fde117dd742a68d6fc4d7a2c9bea04887
APIv4 - Add GROUP_FIRST aggregate function

This fills a gap in the MySql spec. It returns the first result of a GROUP_CONCAT set.
Civi/Api4/Query/SqlFunction.php
Civi/Api4/Query/SqlFunctionGROUP_FIRST.php [new file with mode: 0644]
tests/phpunit/api/v4/Action/SqlFunctionTest.php