Indexing panel properties

Training course

Enabling property indexes increase the speed of lookups and reports but could decrease the speed of adding or updating data in the source. It is recommended that property indexes be used sparingly and that this option be used for ID properties, such as codes in reference tables, fields aggregated in reports, or fields used in lookups.

Do the following to enable indexing for a panel property:

  1. Go to RiSE > Panel Designer > Panel definitions.
  2. Open a panel for edit. This can be the panel that the property is on or any other panel.
  3. If the property is currently being used, temporarily remove it from the panel layout, so you can edit it.

    4. Removing a property from the layout area temporarily

  4. Expand the source, then right-click the property and select View.

    5. Viewing a property in the layout area

  5. Expand the Advanced section, then enable Index this property for improved query performance.

    6. Note: The Index this property for improved query performance property does not apply to File upload or large Text fields of 400 characters or more

    Expanding Advanced property options

  6. Click OK.
  7. Add the property back to the panel.

    8. Adding the property back into the layout area

  8. Click Save & Exit.