Multi-column sort does not work

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

Multi-column sort does not work

Post by prino » 03 Apr 2020 21:58

Sort on timestamp (primary) followed by name. See the attached.
Attachments
multi-sort.gif
Incorrect multi-column sort
multi-sort.gif (425.52 KiB) Viewed 516 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: 48885
Joined: 22 May 2004 16:48
Location: Cologne, Win 8.1, Win 10
Contact:

Re: Multi-column sort does not work

Post by admin » 06 Apr 2020 10:42

Not sure what you mean. I made some tests and all works fine. :eh:
FAQ | XY News RSS | XY Twitter | Stay home! 🎸 Wear DIY masks! 😷

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

Re: Multi-column sort does not work

Post by prino » 06 Apr 2020 11:39

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: 48885
Joined: 22 May 2004 16:48
Location: Cologne, Win 8.1, Win 10
Contact:

Re: Multi-column sort does not work

Post by admin » 06 Apr 2020 11:41

Can you wrap those files in a ZIP and send it to me?
FAQ | XY News RSS | XY Twitter | Stay home! 🎸 Wear DIY masks! 😷

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

Re: Multi-column sort does not work

Post by prino » 06 Apr 2020 11:59

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 6 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: 48885
Joined: 22 May 2004 16:48
Location: Cologne, Win 8.1, Win 10
Contact:

Re: Multi-column sort does not work

Post by admin » 06 Apr 2020 12:20

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 473 times
Set SortSecondaryByExactDate=0 (which is also the factory default) and the sorting will be as you want it.
FAQ | XY News RSS | XY Twitter | Stay home! 🎸 Wear DIY masks! 😷

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

Re: Multi-column sort does not work

Post by prino » 06 Apr 2020 12:54

Yes, that's what I have. And that doesn't explain it. See the attached .GIF:
Attachments
XY.gif
Same difference. Does not sort correctly!
XY.gif (194.51 KiB) Viewed 464 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: 48885
Joined: 22 May 2004 16:48
Location: Cologne, Win 8.1, Win 10
Contact:

Re: Multi-column sort does not work

Post by admin » 06 Apr 2020 13:02

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 462 times
FAQ | XY News RSS | XY Twitter | Stay home! 🎸 Wear DIY masks! 😷

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

Re: Multi-column sort does not work

Post by prino » 06 Apr 2020 13:29

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: 48885
Joined: 22 May 2004 16:48
Location: Cologne, Win 8.1, Win 10
Contact:

Re: Multi-column sort does not work

Post by admin » 06 Apr 2020 13:38

It does here. :?
FAQ | XY News RSS | XY Twitter | Stay home! 🎸 Wear DIY masks! 😷

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

Re: Multi-column sort does not work

Post by prino » 06 Apr 2020 15:14

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