Sorting property names, especially when considering large numbers of sub-units, can be somewhat complicated. The typical methods to sort available on the web are alphabetically or numerically. The challenge presents itself when there might be a property, or multiple properties within an account that look like the following lists:
|123 Spruce St, Unit A
123 Spruce St, Unit B
123 Spruce St, Unit C
123 Spruce St, Unit D
|133 Pine St, Unit A1 – 4br
133 Pine St, Unit A2 – 3br
133 Pine St, Unit B1 – 2br
133 Pine St, Unit B2 – 2br
Computers can be told to sort numerically, which would not have any idea how to sort the first set of data. Likewise, they can be told to sort alphabetically which presents a problem with the 2nd set of data. Even a straight numerical sort on the 2nd set of data would produce an unwanted result. Alphabetical sorting also has the complication of ordering like this: 1,11,12,13,2,3,4,5,6 (see why the 11, 12, 13 are before the 2? hint: it’s because they start with 1 which comes before 2) Add to this that within the property name field we see other notes which may not relate to the property address. Now picture these same lists with 100 or 200 properties or unit in them. It can end up looking disorderly.
Rentec Direct has developed a custom sorting methodology to address all options and display the list in the most universally ordered method available. The explanation of how it works is as follows:
- If a property has a numeric value within it (any number), that number is stored and used as the primary sort, followed by a alphabetical sort; otherwise if a property has no numerical values it is considered to start with a zero, so it’s at the top of the list and then sorted purely alphabetically.
- Following any alphabetical only addresses are the numbered addresses, or addresses with any number in them at all.
- In the case of properties with subunits, each list of subunits is sorted independently and listed directly below the primary property (or in the case of many reports, the subunit’s first units shows first). The sorting of subunits follows the same rules as items 1 and 2 above.
If that’s too technical (or long) to read and understand, suffice it to say the sorting in Rentec Direct works much better now. Thank you Sam (one of our terrific customers) for your feedback and help reporting the sorting issues. This update should provide a more consistent look and feel across the board when looking at lists of properties.
This update affects all editions of Rentec Direct.