Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 02-09-2016, 09:17 AM   #16
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,422
Karma: 85397180
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 09:23 AM.
eschwartz is offline   Reply With Quote
Old 02-09-2016, 09:19 AM   #17
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,703
Karma: 54369092
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by HarryT View Post
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
theducks is offline   Reply With Quote
Old 02-09-2016, 09:21 AM   #18
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 85,544
Karma: 93383043
Join Date: Nov 2006
Location: UK
Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6
Quote:
Originally Posted by eschwartz View Post
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.
HarryT is offline   Reply With Quote
Old 02-09-2016, 09:27 AM   #19
eschwartz
Ex-Helpdesk Junkie
eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.eschwartz ought to be getting tired of karma fortunes by now.
 
eschwartz's Avatar
 
Posts: 19,422
Karma: 85397180
Join Date: Nov 2012
Location: The Beaten Path, USA, Roundworld, This Side of Infinity
Device: Kindle Touch fw5.3.7 (Wifi only)
Quote:
Originally Posted by theducks View Post
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.
eschwartz is offline   Reply With Quote
Old 02-09-2016, 09:31 AM   #20
HarryT
eBook Enthusiast
HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.HarryT ought to be getting tired of karma fortunes by now.
 
HarryT's Avatar
 
Posts: 85,544
Karma: 93383043
Join Date: Nov 2006
Location: UK
Device: Kindle Oasis 2, iPad Pro 10.5", iPhone 6
Quote:
Originally Posted by eschwartz View Post
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.
HarryT is offline   Reply With Quote
Old 02-09-2016, 10:05 AM   #21
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,703
Karma: 54369092
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
theducks is offline   Reply With Quote
Old 02-10-2016, 12:28 AM   #22
pjmpjm
Zealot
pjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchforkpjmpjm can load mercury with a pitchfork
 
pjmpjm's Avatar
 
Posts: 106
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.
pjmpjm is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

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


All times are GMT -4. The time now is 04:14 AM.


MobileRead.com is a privately owned, operated and funded community.