Sorting
Sort order used for data displayed the selected column at run time.
Attribute |
Value |
---|---|
Technical Name | Formats =
SortValue |
Property Type | choice |
Dynamic? | Y |
Default value | C |
Value |
Representation |
Description |
---|---|---|
C
|
Character |
Sort items in column alphabetically |
N
|
Numeric |
Sort items in column by default numeric value |
P
|
Numeric |
Sort items in column by numeric value,
treating periods ( |
K
|
Numeric |
Sort items in column by numeric default,
treating commas ( |
T
|
Date & Time |
Sort items in column by date and time |
I
|
Tree Item Type |
Sort items in column by item type |
Description
When setting this property in Define Columns of List View dialog box, you can use the Sorting and Decimal Indicator fields to define the specific numeric value to use. For more information, see Decimal Indicator.
When setting the Sorting programmatically, you use the Formats property. For more information, see Formats.
Numeric Sorting
Columns that are specified as
Numeric
are sorted as follows:
-
All items of the list view column are converted to numeric if each item contains only the characters 0-9, spaces, the plus and minus signs ('
+
' and '-
'), and the specified decimal indicator.-
If the period (
.
) is specified (or it is the Local default), then it is the only allowed separator; a comma is considered to be a special character. -
If the comma (
,
) is specified (or it is the Local default), then it is the only allowed separator; a period is considered to be a special character.
-
-
All other strings containing alphabetic or special characters are treated as non-numeric fields.
The sorted order will be the numeric items first, followed by the non-numeric string items. For example, for an ascending sort of mixed numeric and alphabetic items, the order would be:
1 2 2.
2 3 10 11 20 1A 2B A1 AA
B1 BB