Multiple Link field. Can't sort by or filter by it on a list of records.
When you try to sort by a multiple link field, the system returns a Bad Server Response message.
When trying to even Filter by a Multiple Link field, the system returns a Bad Server Response too.
Some log messages...
[2019-01-23 21:44:13] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 150' at line 1, Code: 42000 URL: /api/v1/Opportunity?select=codproposta%2Cname%2CaccountsId s%2CaccountsNames%2Cstage%2CamountCurrency%2Camoun t%2CcloseDate%2CultimoContatoComOCliente%2Ccreated At&maxSize=150&offset=0&orderBy=accounts&order=des c&where%5B0%5D%5Btype%5D=linkedWith&where%5B0%5D%5 Battribute%5D=accounts&where%5B0%5D%5Bvalue%5D%5B% 5D=14 [] []
[2019-01-23 21:45:02] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Opportunity ) , InputData: - SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 150' at line 1 [] []
[2019-01-23 21:45:02] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 150' at line 1, Code: 42000 URL: /api/v1/Opportunity?select=codproposta%2Cname%2CaccountsId s%2CaccountsNames%2Cstage%2CamountCurrency%2Camoun t%2CcloseDate%2CultimoContatoComOCliente%2Ccreated At&maxSize=150&offset=0&orderBy=accounts&order=des c&where%5B0%5D%5Btype%5D=linkedWith&where%5B0%5D%5 Battribute%5D=accounts&where%5B0%5D%5Bvalue%5D%5B% 5D=14 [] []
When you try to sort by a multiple link field, the system returns a Bad Server Response message.
When trying to even Filter by a Multiple Link field, the system returns a Bad Server Response too.
Some log messages...
[2019-01-23 21:44:13] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 150' at line 1, Code: 42000 URL: /api/v1/Opportunity?select=codproposta%2Cname%2CaccountsId s%2CaccountsNames%2Cstage%2CamountCurrency%2Camoun t%2CcloseDate%2CultimoContatoComOCliente%2Ccreated At&maxSize=150&offset=0&orderBy=accounts&order=des c&where%5B0%5D%5Btype%5D=linkedWith&where%5B0%5D%5 Battribute%5D=accounts&where%5B0%5D%5Bvalue%5D%5B% 5D=14 [] []
[2019-01-23 21:45:02] Espo.ERROR: API [GET]:/:controller, Params:Array ( [controller] => Opportunity ) , InputData: - SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 150' at line 1 [] []
[2019-01-23 21:45:02] Espo.ERROR: Display Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DESC LIMIT 0, 150' at line 1, Code: 42000 URL: /api/v1/Opportunity?select=codproposta%2Cname%2CaccountsId s%2CaccountsNames%2Cstage%2CamountCurrency%2Camoun t%2CcloseDate%2CultimoContatoComOCliente%2Ccreated At&maxSize=150&offset=0&orderBy=accounts&order=des c&where%5B0%5D%5Btype%5D=linkedWith&where%5B0%5D%5 Battribute%5D=accounts&where%5B0%5D%5Bvalue%5D%5B% 5D=14 [] []
Comment