sthedens
2009-10-05, 05:42 PM
How does Revit do ascending sorts? I would assume it would use the ASCII values of the characters. See attached thumbnail for what is happening. The first column has an alias of "Number" that is actually the Mark value of the door. The schedule is sorted by Mark ascending. No other field is used in sorting. Yet Revit is pulling out the stair doors (the ones with "S" as the second character of the Mark value) and sorting them separate from the remainder of the doors.
I would expect 1S1, 1S1A and 1S2 to be between 113 and 200.
According to the ASCII character listing I have, numeral characters always sort before alpha characters.
It's like Revit is looking at the list of doors and saying, "Hey, I bet those doors with the "S" in the tags are special. Let me group those together. I'm sure that's what the user wants."
I would expect 1S1, 1S1A and 1S2 to be between 113 and 200.
According to the ASCII character listing I have, numeral characters always sort before alpha characters.
It's like Revit is looking at the list of doors and saying, "Hey, I bet those doors with the "S" in the tags are special. Let me group those together. I'm sure that's what the user wants."