On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
 
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

Sorting by Alphanumeric Fields (such as Alternates and Change Orders numbers) - OST QB DPC

Views: 729 Last Updated: 08/09/2018 10:38 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Issue

When a sequence of entries is sorted by a field that is alpha-numeric in nature, for example, Project Name and Job No. (Alternate and Change Order numbers), the field is sorted according to Alphabetical rules, "1..." comes before "2...", numbers always come before letters.

So, you may end up with a Bid list that looks like this...

Discussion

Notice how "10" comes before "2" - this is sorting correctly, mind you, because the numbers are being treated as text because the field itself supports alphanumeric values (unlike "Bid No." which is a numeric only field, and so the sequence is 1, 2, ... 10, 20, etc. - always increasing or decreasing in numerical value).

This sorting happens on any field where alphanumeric entries are supported (regardless of whether alphanumeric values are used or all numeric values are used).

Resolution

Adding a leading "0" to numbers in an alphanumeric field applies sorting in a more 'numerical' fashion:




Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! Copyright 2021 - On Center Software, Inc. by ConstructConnect - All Rights Reserved.