APIv4 - Improve metadata about SQL functions, including translated labels
authorColeman Watts <coleman@civicrm.org>
Fri, 23 Jul 2021 02:37:50 +0000 (22:37 -0400)
committerColeman Watts <coleman@civicrm.org>
Wed, 28 Jul 2021 22:09:29 +0000 (18:09 -0400)
commit1b6a82eef0cf27f3a00dd085bc190ab618c6f8af
tree454337aa43d4609e6c3497f8be278603a8c90981
parentf19a0f0005c2b829f31e7630b0b88842dca59e2d
APIv4 - Improve metadata about SQL functions, including translated labels

This splits the concept of prefix/suffix into prefix, flag_before and flag_after,
Since a prefix like ORDER BY is not the same as a flag like DISTINCT.
Lays the groundwork for exposing more info about SQL functiont to a UI like SearchKIt.
Civi/Api4/Query/SqlFunction.php
Civi/Api4/Query/SqlFunctionAVG.php
Civi/Api4/Query/SqlFunctionCOUNT.php
Civi/Api4/Query/SqlFunctionGROUP_CONCAT.php
Civi/Api4/Query/SqlFunctionMAX.php
Civi/Api4/Query/SqlFunctionMIN.php
Civi/Api4/Query/SqlFunctionSUM.php
ext/search_kit/ang/crmSearchAdmin/crmSearchFunction.component.js
ext/search_kit/ang/crmSearchAdmin/crmSearchFunction.html
tests/phpunit/api/v4/Query/SqlExpressionParserTest.php