Sorting Tweak

[atjnjk]

I've been trying to use this tweak:

sort_columns_at_startup = [('authors',0),('title',0)]

That and this "[('authors',0),('series',0)]" work.
But "[('date',0),('series',0)]" or "[('date',0),('series',0)]" doesn't seem to be working as it should.
Is this a bug?

[DoctorOhh]

Originally Posted by atjnjk

But "[('date',0),('series',0)]" or "[('date',0),('series',0)]" doesn't seem to be working as it should.
Is this a bug?

What is the difference between the two you say don't work. I think that date - series probably works fine. The devil is in the details you don't see. The metadata for date goes down to the second...

<meta content="2009-07-17T08:59:29+00:00" name="calibre:timestamp"/>

...not the day, thus if you sort by date, series will be a mute point unless all of the dates are the same down to the second and that doesn't happen during normal operation.

[atjnjk]

Sorry. It was "[('date',0),('series',0)]" or "[('date',0),('title',0)]".
Thank you very much for explaining. It's too bad we can't see the time in Calibre's GUI or have an option to sort only by date.

There is only one thing I don't understand. When sorting by authors,title or authors,series, there is an arrow next to the author column. But when sorting by date,title or date,series, the arrow is next to the title/series column (it should be next to the date column).

[chaley]

Originally Posted by atjnjk

There is only one thing I don't understand. When sorting by authors,title or authors,series, there is an arrow next to the author column. But when sorting by date,title or date,series, the arrow is next to the title/series column (it should be next to the date column).

Thanks for persevering. There is in fact a problem here.

The internal name for 'date' is 'timestamp'. Normally when a column is sorted, one name is translated into another. Unfortunately, the sort at startup path does not go through that translation. Calibre tries to find a field named 'date', fails, and ignores it.

You can fix this now by using the name 'timestamp' instead of date.

[DoctorOhh]

Originally Posted by chaley

You can fix this now by using the name 'timestamp' instead of date.

Just wondering, does "timestamp" truncate down to the day only or does it include the time down to the second?

[chaley]

Originally Posted by dwanthny

Just wondering, does "timestamp" truncate down to the day only or does it include the time down to the second?

Your post a few back is correct, timestamp (date) includes time to the second.

[atjnjk]

Originally Posted by chaley

You can fix this now by using the name 'timestamp' instead of date.

Thanks a lot. This "[('timestamp',1),('series',0)]" works perfectly.