Optimizing custom entity list for faster loading

This option is not supported for standard entities.

By default, Sage CRM looks for data related to a custom entity list in all database columns. You can configure Sage CRM to look for data only in those database columns that are added to your custom entity list. As a result, your list will load faster.

  1. Click <My Profile> | Administration | Customization | <Custom Entity> | Lists.
  2. Do one of the following:
    • To optimize an existing list, click the Change icon ( ) beside it.
    • To create and optimize a new list, click New.
  3. Set Use all SQL columns in query to No.

    When this option is set to Yes or --None--, Sage CRM looks for data in all database columns.

  4. Click Save.

If you get an error when your list is loading, a list column in your customization might be missing from the SQL query that loads list. To resolve this issue, add the column to the list but make it hidden:

  1. Click <My Profile> | Administration | Customization | <Custom Entity> | Lists.
  2. Click the list name.
  3. From Field, select the column you want to add. In most cases, this is the column mentioned in the error message you get when the list is loading.
  4. Click Add.
  5. In the list under Desktop HTML List Contents, click the column you've just added.
  6. In CreateScript, enter the following:
    Hidden = true;
  7. Click Save.