SearchKit - Allow aggreation by partial dates
authorColeman Watts <coleman@civicrm.org>
Mon, 8 Aug 2022 21:35:27 +0000 (17:35 -0400)
committerColeman Watts <coleman@civicrm.org>
Mon, 8 Aug 2022 21:35:27 +0000 (17:35 -0400)
commit2246b4fa9d5db221206f117ef561578f0c10b40e
tree3e025b5f904e2f6660ca1bd0cd3edcdf4b9e96d1
parent0fa05f712d83ee89a627e62afc1f181d1f9a7b96
SearchKit - Allow aggreation by partial dates

Supports the EXTRACT() sql function so that partial dates can be extracted.
See dev/core#3700
16 files changed:
Civi/Api4/Query/SqlExpression.php
Civi/Api4/Query/SqlFunction.php
Civi/Api4/Query/SqlFunctionAVG.php
Civi/Api4/Query/SqlFunctionCOUNT.php
Civi/Api4/Query/SqlFunctionEXTRACT.php [new file with mode: 0644]
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.module.js
ext/search_kit/ang/crmSearchAdmin/crmSearchClause.component.js
ext/search_kit/ang/crmSearchAdmin/crmSearchFunction.component.js
ext/search_kit/ang/crmSearchAdmin/crmSearchFunction.html
ext/search_kit/ang/crmSearchAdmin/crmSearchFunctionFlag.component.js [new file with mode: 0644]
ext/search_kit/ang/crmSearchAdmin/crmSearchFunctionFlag.html [new file with mode: 0644]
tests/phpunit/api/v4/Action/SqlFunctionTest.php