Multi-column sort does not work

Things you’d like to miss in the future...
Post Reply
prino
Posts: 337
Joined: 18 Mar 2012 21:14
Location: Vilnius, Lithuania
Contact:

Multi-column sort does not work

Post by prino »

Sort on timestamp (primary) followed by name. See the attached.
Attachments
Incorrect multi-column sort
Incorrect multi-column sort
multi-sort.gif (425.52 KiB) Viewed 1790 times
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
At last, a tiny bit of programming here... :mrgreen:

admin
Site Admin
Posts: 60357
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Multi-column sort does not work

Post by admin »

Not sure what you mean. I made some tests and all works fine. :eh:

prino
Posts: 337
Joined: 18 Mar 2012 21:14
Location: Vilnius, Lithuania
Contact:

Re: Multi-column sort does not work

Post by prino »

Then why, in the .GIF I posted, ends the "on-the-road.jpg" between the various "imageNN.jpg" files, when all the timestamps (primary sort key) for all files are the same?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
At last, a tiny bit of programming here... :mrgreen:

admin
Site Admin
Posts: 60357
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Multi-column sort does not work

Post by admin »

Can you wrap those files in a ZIP and send it to me?

prino
Posts: 337
Joined: 18 Mar 2012 21:14
Location: Vilnius, Lithuania
Contact:

Re: Multi-column sort does not work

Post by prino »

Reduced to the minimum, 7 files. Extract the RAR file with a "-tsm -tsc -tsa" to restore all timestamps.
Attachments
sylvain_viard.rar
Seven files that incorrectly sort multi-column
(596.37 KiB) Downloaded 52 times
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
At last, a tiny bit of programming here... :mrgreen:

admin
Site Admin
Posts: 60357
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Multi-column sort does not work

Post by admin »

You see this because you have set the tweak SortSecondaryByExactDate=1 (cf. change log v14.20.0307 - 2014-07-02 21:48), and you have hidden the milliseconds from the date columns so you thought the dates would be identical but they are not:
WatchTheMilliseconds.png
WatchTheMilliseconds.png (21.53 KiB) Viewed 1747 times
Set SortSecondaryByExactDate=0 (which is also the factory default) and the sorting will be as you want it.

prino
Posts: 337
Joined: 18 Mar 2012 21:14
Location: Vilnius, Lithuania
Contact:

Re: Multi-column sort does not work

Post by prino »

Yes, that's what I have. And that doesn't explain it. See the attached .GIF:
Attachments
Same difference. Does not sort correctly!
Same difference. Does not sort correctly!
XY.gif (194.51 KiB) Viewed 1738 times
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
At last, a tiny bit of programming here... :mrgreen:

admin
Site Admin
Posts: 60357
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Multi-column sort does not work

Post by admin »

Whoops, my mistake. I said milliseconds, but I meant seconds! Choose a date format that shows seconds...
Attachments
WatchTheSeconds.png
WatchTheSeconds.png (21.19 KiB) Viewed 1736 times

prino
Posts: 337
Joined: 18 Mar 2012 21:14
Location: Vilnius, Lithuania
Contact:

Re: Multi-column sort does not work

Post by prino »

OK, I goofed.

However, in that case I wonder why, if using only hh:mm times, setting the time in the properties panel does not set the seconds and milliseconds to 00.000000, which is what every (or at least this) sensible person would expect?
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
At last, a tiny bit of programming here... :mrgreen:

admin
Site Admin
Posts: 60357
Joined: 22 May 2004 16:48
Location: Win8.1 @100%, Win10 @100%
Contact:

Re: Multi-column sort does not work

Post by admin »

It does here. :?

prino
Posts: 337
Joined: 18 Mar 2012 21:14
Location: Vilnius, Lithuania
Contact:

Re: Multi-column sort does not work

Post by prino »

Then I'm absolutely clueless as to why the milli- and nano-seconds were zero and the seconds were different.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
At last, a tiny bit of programming here... :mrgreen:

Post Reply