• Why Relate fields aren't sortable in listviews?

    Hello, I have this Related field that seems not sortable in my listview: Scope of supply is a dropdown and account name is a relationship. It seems that being "Relate" kind, Machine Model can't be sortable. Right? Any solutions? It's annoying…

  • SugarCRM and MYSQL 8.0

    I am facing an issue after upgrading a test instance of SugarCRM from MYSQL 5.7 to MYSQL 8.0 (in place upgrade after ubuntu server 18.0.4 to 20.0.4 upgrade) Table 'job_queue' from one of the SELECTs cannot be used in global ORDER clause I have configured…

  • Database failure. Please refer to sugarcrm.log for details in SugarCRM Professional 11.05

    Good Day! I have a problem with creating fields because I am unable to create columns in the database due to the error I encounter every time I finish the Quick Repair and Rebuild. Check the error logs below: Fri Jan 20 01:26:13 2023 [1447][1][ALERT…

  • Metadata required fileds

    Hello there So, I'm having the following issue: Repairing our customized installation of SugarCRM 11.0, I'm having several queries that returns errors. I'm trying to fix those fields, in order to be able to have a clean repair, without Oracle…

  • How to use relation prospect_list_campaigns in API? (SugarCRM 11)

    Hi, GET http://localhost/rest/v11/ProspectLists/56991d00-3c78-11ec-8a7f-005056b0b4f5/link/prospect_list_campaigns result is 404 with the response "Could not find a relationship named: prospect_list_campaigns" The relation exists and with a studio…

  • In the release notes for Sugar 11; the function isInList has been updated to work with mulitselect fields; Is there an examples of how to properly make this call?

    In the release notes for Sugar 11, https://support.sugarcrm.com/Knowledge_Base/Installation_Upgrade/What_to_Expect_When_Upgrading_to_11.0/ . It states Sugar Logic Passing a mulitselect field as a second parameter in the isInList() formula does…