Sort by Calibre Folder ID

[JohnnyBook]

Can the books be sorted by the Calibre Folder IDs?

I know the IDs can be displayed in the book details screen.

But don't see a way to display that column in the library display.

I would assume I need to make a custom column?

Thanks,

[chaley]

Make a custom column "built from other columns". Set the template to {id}. Set the Search/Sort type to number.

[theducks]

Originally Posted by JohnnyBook

Can the books be sorted by the Calibre Folder IDs?

I know the IDs can be displayed in the book details screen.

But don't see a way to display that column in the library display.

I would assume I need to make a custom column?

Thanks,

'Natural order' (un-sorted), original{id} order closesly follows the Date column if you do not change that value.

I noted original{id} because I believe there are events that impose a new ID number

Having to burden the database with a custom column to get at something that exists naturally tends to 'off' my sensibilities .

By default, Calibre starts with the last sorted column
OR
using the tweak: ID: sort_columns_at_startup
'None' being the standard behavior (above)

sort_columns_at_startup = [('id',0)]

works on Windows for the initial startup of a Calibre session

[eschwartz]

Originally Posted by theducks

I noted original{id} because I believe there are events that impose a new ID number

New id numbers only happen when book records are deleted and readded, probably through save to disk. (copying to-from staging libraries would do the same.)

Even Restore database uses the same id numbers from the filename. (I guess it recycles the numbers after the last one?)

[theducks]

Originally Posted by eschwartz

New id numbers only happen when book records are deleted and readded, probably through save to disk. (copying to-from staging libraries would do the same.)

Even Restore database uses the same id numbers from the filename. (I guess it recycles the numbers after the last one?)

Restore DB uses the OPF file which has the id number stored