set calibre so at start books sorted - Page 2

eschwartz · 02-09-2016, 10:17 AM

It's a full timestamp.

Sort by date, and you will likely never get to a second-level sort criteria.
(Unless you manually set the values, which defeats the whole purpose of having that column.)

theducks · 02-09-2016, 10:19 AM

Quote:

Originally Posted by HarryT

That will sort by date within title, won't it? If you want to sort by title within date, shouldn't it be the other way around?

Code:

 [('date',1), ('title',0),]

I guess it depends whether the "date" column just stores the date, or a full timestamp. If it's the latter, you'll never have two items with the same timestamp, so there can't sensibly be a secondary sort column.

Yes, it is a timestamp so the the TITLE ORDER won't be a order unless they were added at the same exact time.

and I almost always get it backward, as to which is first

(But it is real easy to flip )

Sort Title to set the order Bias, then set the Date. Same as clicking the column headers in the GUI

HarryT · 02-09-2016, 10:21 AM

Quote:

Originally Posted by eschwartz

It's a full timestamp.

Sort by date, and you will likely never get to a second-level sort criteria.

Thanks - that's what I thought was the case.

eschwartz · 02-09-2016, 10:27 AM

Quote:

Originally Posted by theducks

Yes, it is a timestamp so the the TITLE ORDER won't be a order unless they were added at the same exact time.

They can't be added at the same time, there will always be at least a few seconds of difference.

As I said above, (cross-posted, actually,) the only way you can really get that to happen is if you manually edit the fields.

HarryT · 02-09-2016, 10:31 AM

Quote:

Originally Posted by eschwartz

They can't be added at the same time, there will always be at least a few seconds of difference.

As I said above, (cross-posted, actually,) the only way you can really get that to happen is if you manually edit the fields.

Yes, so it's meaningless to have a secondary sort field if "Date" is the primary.

theducks · 02-09-2016, 11:05 AM

I had a timestamp mask in place, so I was not seeing the seconds

So, yes... Meaningless to do the extra level.

OP
there is another tweak that sets the number of (column) sorts calibre will use in cascade )
so you can't exceed that setting and expect correct results

Note: I find it difficult to imagine very many levels of useful sort before I would run into another timestamp-like case

pjmpjm · 02-10-2016, 01:28 AM

Thanks, everyone. This discussion has clarified a lot of issues for me.

sort_columns_at_startup = [('date', 1)] is now doing what I want.

02-09-2016, 10:17 AM	#16
eschwartz Ex-Helpdesk Junkie Posts: 19,421 Karma: 85400180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	It's a full timestamp. Sort by date, and you will likely never get to a second-level sort criteria. (Unless you manually set the values, which defeats the whole purpose of having that column.) Last edited by eschwartz; 02-09-2016 at 10:23 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove unwantedPagesat start of Books in Calibre Tweek Books	Dasha	Calibre	5	10-23-2013 12:37 AM
A way to have column w Fixed set o values but not alphabeticaly sorted ?	Riva3000	Library Management	9	09-21-2013 07:03 PM
Help With Books Sorted on Disc	alikayn	Calibre	11	11-13-2012 12:31 AM
Books sorted by Number within Series - is it possible?	s.g.	Calibre	8	11-29-2011 10:59 AM
set calibre to move books	gheatza	Calibre	0	10-19-2010 02:10 PM

02-09-2016, 11:05 AM	#21
theducks Well trained by Cats Posts: 31,289 Karma: 62000000 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	I had a timestamp mask in place, so I was not seeing the seconds So, yes... Meaningless to do the extra level. OP there is another tweak that sets the number of (column) sorts calibre will use in cascade ) so you can't exceed that setting and expect correct results Note: I find it difficult to imagine very many levels of useful sort before I would run into another timestamp-like case

02-10-2016, 01:28 AM	#22
pjmpjm Zealot Posts: 116 Karma: 48334 Join Date: Sep 2013 Location: Australia Device: Fire HD 10	Thanks, everyone. This discussion has clarified a lot of issues for me. sort_columns_at_startup = [('date', 1)] is now doing what I want.