Request:
curl -g -H 'Espo-Authorization: <token>‘ -X GET "https://<crm server>/api/v1/Opportunity?where[0][field]=accountName&where[0][type]=equals&where[0][value]=<company name>"
worked before upgrading to 5.6.1 or 5.6.2 (can't determine). Now it returns HttpServerErrorException: 500 Internal Server Error
CRM Error Log:
Espo.ERROR: (42) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account.name' in 'where clause'; GET /api/v1/Opportunity?where[0][field]=accountName&where[0][type]=equals&where[0][value]=<company name>
curl -g -H 'Espo-Authorization: <token>‘ -X GET "https://<crm server>/api/v1/Opportunity?where[0][field]=accountName&where[0][type]=equals&where[0][value]=<company name>"
worked before upgrading to 5.6.1 or 5.6.2 (can't determine). Now it returns HttpServerErrorException: 500 Internal Server Error
CRM Error Log:
Espo.ERROR: (42) SQLSTATE[42S22]: Column not found: 1054 Unknown column 'account.name' in 'where clause'; GET /api/v1/Opportunity?where[0][field]=accountName&where[0][type]=equals&where[0][value]=<company name>
Comment