fix sorting of numbers

Ticket

fix sorting of numbers+status
fix sorting of numbers+priority
fix sorting of numbers+tag
fix sorting of numbers+commit
 

fix sorting of numbers+issues

 

 

 

this works, though SQL breaks on casting issues (like if one of the values is obviously non numeric).  we should probably close this and fix wql breaking on casting issues, and should also standardize wql type casting -- it current uses the native db types.


Looks okay http://test.dwagn.org/wagn/sorting_numbers

 

Seems prone to confusion to require WQL to explicitly have "sort_as": "integer" - if all of the cards being sorted are Number, shouldn't it default to that?

  --John Abbe.....Tue Nov 29 19:38:36 -0800 2011


documentation questions - can "sort_as" take any other values besides "integer" ?

  --John Abbe.....Tue Nov 29 19:40:17 -0800 2011


it currently uses native db types. (see above). Postgres has "real", "integer" and several others.

 

Type-based defaults could be nice, but low roi. Let's not ticket that until we know we're going to invest energy in this area.

  --Ethan McCutchen.....Thu Dec 01 14:38:13 -0800 2011