Sorting by label is not in the expected order

Product(s): WaterGEMS, WaterCAD, SewerGEMS, SewerCAD, CivilStorm, StormCAD, HAMMER
Version(s): CONNECT Edition, V8i
Area: Modeling


When sorting an element FlexTable based on the label, the order of the elements is not ascending or descending as expected. 


This may be related to how the label is displayed. Sorting is based on the first set of numbers. As an example, if the pipes have a label like P-1, P-2, P-3, and P-10 and you sort ascending, the order will follow the numerical values. 

However, if the pipe labels are similar to P-1-1, P-1-2, P-1-3, and P-1-10, the order will following logic of a string or text value. For that reason, sorting in an ascending manner will display the pipes like this: P-1-1, P-1-10, P-1-2, P-1-3.

This is working as designed. You can append the labels to remove the first set of numbers by right-clicking on the Label column header and selecting Relabel. You can then use the Append feature to edit the prefix.

See Also

How do I append a prefix to element labels based on a selection set of elements?

Sorting and relabeling a flextable based on upstream-downstream order

  • Created by Bentley Colleague
  • When: Thu, Nov 11 2021 4:54 PM
  • Revisions: 1
  • Comments: 0