Announcement

Collapse
No announcement yet.

Multiple Link field. Can't sort by or filter by it on a list of records.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiple Link field. Can't sort by or filter by it on a list of records.

    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 [] []

  • #2
    Originally posted by rodrigocoelho View Post
    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 [] []
    The filter worked after a refresh. It was not working after clicking on the sort by column and the system returning the error.
    After a browser refresh, the filter started working again.

    But the sort option is not working.

    Comment


    • #3
      Hello,
      make this field not sortable on the layout, please.
      there is no defined expectation of ordering LinkMultiple field.

      Comment


      • #4
        I did this. But I'm missing the sort option. Maybe sort by the first register or sort the multiple field and use the first register as the one considered

        Comment


        • #5
          It's not supported and not planned to be supported.

          Comment

          Working...
          X