AJAX error when sorting soft credit by name or date

To reproduce:

• View the Contribution tab of a Contact with Soft Credits such as this one on dmaster
• click the Contributor or Received arrows in Soft Credit section and attempt sort
• observe Ajax error DataTables warning: table id=DataTables_Table_0 and/or Invalid field 'contribution.receive_date' in the black popup

changed the description

turning on debugging shows this

0	Civi\Api4\Query\Api4SelectQuery->buildOrderBy()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:157
1	Civi\Api4\Query\Api4SelectQuery->getSql()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/Api4/Query/Api4SelectQuery.php:171
2	Civi\Api4\Query\Api4SelectQuery->run()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/Api4/Generic/DAOGetAction.php:124
3	Civi\Api4\Generic\DAOGetAction->getObjects()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/Api4/Generic/DAOGetAction.php:111
4	Civi\Api4\Generic\DAOGetAction->_run()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/Api4/Provider/ActionObjectProvider.php:72
5	Civi\Api4\Provider\ActionObjectProvider->invoke()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/API/Kernel.php:158
6	Civi\API\Kernel->runRequest()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/Civi/Api4/Generic/AbstractAction.php:250
7	Civi\Api4\Generic\AbstractAction->execute()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Contribute/BAO/ContributionSoft.php:437
8	CRM_Contribute_BAO_ContributionSoft::getSoftContributionList()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Contribute/BAO/ContributionSoft.php:366
9	CRM_Contribute_BAO_ContributionSoft::getSoftContributionSelector()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Contribute/Page/AJAX.php:39
10	CRM_Contribute_Page_AJAX::getSoftContributionRows()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Invoke.php:285
11	CRM_Core_Invoke::runItem()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Invoke.php:69
12	CRM_Core_Invoke::_invoke()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/CRM/Core/Invoke.php:36
13	CRM_Core_Invoke::invoke()	/srv/buildkit/build/dmaster/web/sites/all/modules/civicrm/drupal/civicrm.module:471
14	civicrm_invoke()	/srv/buildkit/build/dmaster/web/includes/menu.inc:527
15	menu_execute_active_handler()	/srv/buildkit/build/dmaster/web/index.php:21
16	{main}	 
 Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
Invalid field 'contact.sort_name'
Return to home page.

PR for this https://github.com/civicrm/civicrm-core/pull/25846

added has-pull-request label

added regression label

mentioned in commit dc244b09

mentioned in commit eab355b3

changed milestone to %5.59.4

closed

mentioned in commit 5d9766e2

mentioned in commit fd85d1a8