Data Table Record Sorting

Different fields have different storage types, and each storage type has its own sorting method. The following lists the sorting methods for all storage types in the system

Sorting Rules

• String sorting Ascending sorting is done by first comparing the first character, in the order of 0, 1, 2...9, a, b, c...z, Chinese characters; if the first characters are the same, then compare the second, third, and subsequent characters. If the two words are of different lengths (e.g., sigh and sight), the shorter one comes first. Chinese characters are sorted by pinyin, for example (e.g., Guangdong comes before Guangxi because 'guangdong' is ordered before 'guangxi'). Only ASCII letters 'A' to 'Z' are considered letters in strings; other content is sorted strictly according to the byte values of character encodings.

• Integer and decimal sorting Data is sorted by numerical value. In ascending order, smaller numbers come first; in descending order, larger numbers come first.

• Array sorting If the storage type is an array, sorting is performed according to the index order of the array, with each index item sorted in sequence. For example, if the first row of data is [1,2,3] and the second row is [1,4,5], in ascending order, the system first compares the first index item of both rows (1 and 1). When they are equal, it compares the second items (2 and 4), resulting in 2 being less than 4. Therefore, the final sorting is [1,2,3], [1,4,5].

Record Order

By default, the system sorts records according to their insertion order (system-built seq field), with earlier inserted data coming first. You can modify the default order by enabling drag-and-drop sorting in the view.