Sort the data in a subform

Applies to User Roles:

System Administrator

You can configure the default sort order of the data that is displayed in a subform. To do this, configure the following two drop-down lists in the Link form of the subform:

  • Sort Field(To/Target)
    Sets the field by which the subform is sorted
  • Sort Order(To/Target)
    Sets the order in which the field is sorted


  • If multiple links are defined for a field in the Link file of the subform, you must use the first link to define the default sort field and sort order.
  • You cannot sort array fields in Service Manager 9.32. Therefore, you should not configure an array field as the default sort field.
  • You may experience slow performance if you configure a long text field (for example, the Description field) as the default sort field.

Related concepts

Virtual joins
Understanding subforms
Forms Designer

Related tasks

Example: Creating a virtual join
Add a subform to a form

Related references

Subform control