|
Special cases of complex sorting |
Scroll |
A more complicated case of complex sorting is sorting of texts created from fill templates (these are usually names of standard products and materials; for details, see section Using fill templates). Texts created from the templates consist of several fields. These texts often need to be sorted not in a sequence of symbols and numbers of which they consist, but in a specific sequence of fields according to the values in these fields. For example, stock products are first sorted by name, then by standard designation, then in ascending order of basic parameters and dimensions. Example of complex sorting of standard items:
Key 2–1058–40 GOST 23360–78
Spline 2–14x90x50 GOST 23360–78
Pin 10×45 GOST 3128-70
Rod 12×50 GOST 3128-70
Information about fields and order for sorting the items of this type is stored in the fill template. See section Creating custom fill templates.
Sometimes neither ascending nor descending sorting is suitable for the correct arrangement of the texts created from templates. In these cases, when configuring a template, the order of sorting the values in the fields is specified explicitly — by listing possible values and arranging them in the required sequence.
For example, designations of electrical elements with the same name must first be sorted in the ascending order of measurement units and then in the ascending order of nominal value:
Resistor MLT-0.25-210 Ohm TU 11–85
Resistor MLT-0.5-240 Ohm TU 11–85
Resistor MLT-0.25 24 kOhm TU 11–85
Resistor MLT-0.25-27 kOhm TU 11–85
To achieve correct sorting by a field containing measurement units, the order for sorting values in the corresponding field may be explicitly set.
BOM columns, the text in which is formed and sorted based on templates, have the 'entry' value type.
