SugarCRM Limitations

  1. For both UPDATE and UPSERT queries, an UPSERT operation is performed.
  2. The Nullable and Updatable columns in the table properties, as displayed in the physical model Schema of the connection, may not represent the correct operation. For example, a column not marked as Updatable may throw system exception when you try to update it and conversely, a column marked as Nullable might not throw an exception in updating.
  3. When querying using joins you need to use an alias.