Sorting by OS produces bad ordering with Mac OS X versions

RESOLVED WORKSFORME

Status

Socorro
Webapp
--
minor
RESOLVED WORKSFORME
9 years ago
6 years ago

People

(Reporter: Smokey Ardisson (offline for a while; not following bugs - do not email), Unassigned)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(URL)

STR:

1. Load URL
2. Sort by OS in descending order

ER: 10.5.5, 10.5.4, 10.5.3…10.5.0, 10.4.11, 10.4.10, 10.4.9…10.4.0
AR: 10.5.5, 10.5.4, 10.5.3…10.5.0, 10.4.9…10.4.2, 10.4.11, 10.4.10, 10.4.0 (there are currently no 10.4.1 reports)

I have no idea what version of Socorro crash-stats.m.c is currently running; choosing "Trunk"
This is kind of sucky. I think in the database we actually have two fields, "OS" and "OS Version". We could split those into two columns in the report, but sorting on "OS Version" would still probably show this. Unfortunately that's not a well-defined field, it's just text, so defining the sorting on it is hard.
I don't know that there's a good way to fix this, since the "OS" and "OS Version" fields are both arbitrary text. I guess we could match templates for specific OSes and pull the data into a more usable form in the db.
Target Milestone: --- → Future
(Assignee)

Updated

6 years ago
Component: Socorro → General
Product: Webtools → Socorro

Updated

6 years ago
Component: General → Webapp
I believe this is no longer a problem. Heading to https://crash-stats.mozilla.com/report/list?product=Firefox&platform=mac&query_search=signature&query_type=contains&reason_type=contains&date=03%2F25%2F2012%2021%3A13%3A08&range_value=1&range_unit=weeks&hang_type=any&process_type=any&do_query=1&signature=strlen%20|%20Flash%20Player%400x2e7bc4 and sorted the Mac OS either asc or desc works as expected.

Closing as works for me, feel free to reopen if I am wrong it is still not fixed.
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → WORKSFORME
You need to log in before you can comment on or make changes to this bug.