Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Vincent Kars]

I sorted by disc and by track but somehow it doesn't work properly on disc #

[MrC]

Empty and 1 are considered the same with Disc # when using formatted values.

Make them use either, but not both of those values.  Or use [Disc #,0] as an expression column.

[Vincent Kars]

Hi MrRegex

I did nothing
Care to explain these formatted values?

[MrC]

The values you see in cells and panes are formatted.  They are pretty-printed versions of the raw, actual stored data, or have special treatment applied to certain values or operations (such as for integer or decimal types treating 0 and blank as the same, or for [Disc #] blank and 1 as the same).

A field has two forms of expression:

   Raw:         [field,0]
   Formatted: [field,1]  (the default)

MC uses the formatted version by default (so you can just enter [field]).  So in the case of Disc #, both blank and 1 are treated as one and the same.

[Vincent Kars]

Thanks

Looks like I have a feature request…

[MrC]

Just change the column you show, from [Disc #] instead to an expression column with the value [Disc #,0] and it will sort the way you want.