Loading fails when searching for a group that starts with a number in CiviMail
Overview
Loading of the autocomplete select widget for the Recipients field fails within CiviMail if the user searches with a number.
Reproduction steps
- Make sure you have at a mailing group that starts with a number. If not, create one.
- Go to Mailings > New Mailing
- In the Recipients (to include) field, start typing the name of the group that starts with a number
- Get the error message Loading Failed
Current behaviour
A user cannot search for recipients within CiviMail if the group starts with a number.
vs.
Expected behaviour
A user should be able to search for recipients regardless of if a group starts with a number, letter, or other character.
Environment information
- CiviCRM: _Master/5.64.1
Dev notes
PHP TypeError:
TypeError: Return value of Civi\Api4\Query\SqlField::render() must be of the type string, null returned in Civi\Api4\Query\SqlField->render() (line 34 of Civi/Api4/Query/SqlField.php).
Call stack
Civi\Api4\Query\SqlField->render (Civi/Api4/Query/SqlField.php:34)
Civi\Api4\Query\Api4SelectQuery->buildSelectClause (Civi/Api4/Query/Api4SelectQuery.php:201)
Civi\Api4\Query\Api4Query->getSql (Civi/Api4/Query/Api4Query.php:78)
Civi\Api4\Query\Api4Query->getResults (Civi/Api4/Query/Api4Query.php:89)
Civi\Api4\Query\Api4SelectQuery->run (Civi/Api4/Query/Api4SelectQuery.php:101)
Civi\Api4\Generic\DAOGetAction->getObjects (Civi/Api4/Generic/DAOGetAction.php:107)
Civi\Api4\Generic\DAOGetAction->_run (Civi/Api4/Generic/DAOGetAction.php:94)
Civi\Api4\Provider\ActionObjectProvider->invoke (Civi/Api4/Provider/ActionObjectProvider.php:72)
Civi\API\Kernel->runRequest (Civi/API/Kernel.php:158)
Civi\Api4\Generic\AbstractAction->execute (Civi/Api4/Generic/AbstractAction.php:249)
civicrm_api4 (api/api.php:85)
Civi\Api4\Service\Spec\Provider\SearchSegmentExtraFieldProvider::getSets (ext/search_kit/Civi/Api4/Service/Spec/Provider/SearchSegmentExtraFieldProvider.php:55)
Civi\Api4\Service\Spec\Provider\SearchSegmentExtraFieldProvider->modifySpec (ext/search_kit/Civi/Api4/Service/Spec/Provider/SearchSegmentExtraFieldProvider.php:25)
Civi\Api4\Service\Spec\SpecGatherer->getSpec (Civi/Api4/Service/Spec/SpecGatherer.php:70)
Civi\Api4\Generic\DAOGetFieldsAction->getRecords (Civi/Api4/Generic/DAOGetFieldsAction.php:43)
Civi\Api4\Generic\BasicGetFieldsAction->_run (Civi/Api4/Generic/BasicGetFieldsAction.php:97)
Civi\Api4\Provider\ActionObjectProvider->invoke (Civi/Api4/Provider/ActionObjectProvider.php:72)
Civi\API\Kernel->runRequest (Civi/API/Kernel.php:158)
Civi\Api4\Generic\AbstractAction->execute (Civi/Api4/Generic/AbstractAction.php:249)
civicrm_api4 (api/api.php:85)