Sort the data in a subform

Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

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

Note

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

Related tasks

Related references