Sort by identifier (id)?

[SnackApp]

How can I sort by identifier (id)?

creating a custom ISBN column didn't work.

thanks for the help!

[BetterRed]

What didn't work - creating the custom column or sorting it?

This works for me:

{identifiers:select(isbn)}

BR

[theducks]

{id} is the startup sort if you have not configured something else.
Sort on {date} works if you have not repurposed that (or changed it).
Both are set when the record is first created.

[SnackApp]

Originally Posted by BetterRed

What didn't work - creating the custom column or sorting it?

This works for me:

Attachment 202299

{identifiers:select(isbn)}

BR

thank you, this was what I was referring to. I guess I did something wrong, this worked for ISBN: tags

some are labeled amazon:
some are labeled mobi-asin:

is there anyway to do it without making a separate header for all of them?

[BetterRed]

Originally Posted by SnackApp

thank you, this was what I was referring to. I guess I did something wrong, this worked for ISBN: tags

some are labeled amazon:
some are labeled mobi-asin:

is there anyway to do it without making a separate header for all of them?

Not that I know of, maybe you could combine them via Preferences->Searching->Grouped searches - but I don't know that a Group search or User category can be shown as sortable book list column - I have my doubts. Maybe via another template?

Why do you want to sort on identifiers?

BR

[theducks]

BR asked the question. Unless they are special (custom), the only ones that make sense would be ISBN, and that is limited.
ISBN has a pattern (length is 10)
First section is Language. The majors are single digit,
Next is publisher. that can be 1-7 digits A 'vanity press might get a 7 digit one.
The next to last is the Book (in assigned sequence) number
And the last is a calculated Mod10 checksum 0-X

So sorting by ISBN would mostly by group Language, then Publisher
I have no clue if ASIN type have any significant (other than Warehousing) Logic included

[Quoth]

Also ISBNs are really for retail ordering. Different sizes on paper have different ISBNs. An ebook need not have an ISBN. A revision (even if hard to see) will have a different ISBN for same paper size.

When we did a book library lending system each physical book got a unique barcode (different format to EAN/UPC/ISBN to avoid confusion). The ISBN wasn't used, except as extra book data.

The only value really of ISBN to a library system is adding fresh physical copies to the database as the ISBN can be looked up, ONCE.

Usually ebooks have the Author, Title and other metadata in the file. An ISBN is maybe only of value (limited) to find additional metadata or a cover, but the initial metadata is usually OK for this. So on Calibre I have no interest at all in ASIN or ISBN for ebooks. I might use ISBN just once on a paper book if I was adding it to a catalogue, library system or Calibre. I'm tempted to at least catalogue my approx 3000 paper books on Calibre, but the rest of the family doesn't use Calibre directly (it's single user anyway) and are happy to hunt the shelves for paper titles.
We duplicate any paper titles we like that come up cheap or appear as PD (I've actual paper editions to turn of 20th C and plenty of books by sufficiently dead people).

Mostly accurate
https://en.wikipedia.org/wiki/ISBN

I can't see why you'd sort by any kind of ID, either ISBN, ASIN or Calibre ID (any database will have a per record unique ID).

Edit:
The Country part might be where the publisher bought a block of ISBNs. It doesn't always mean the publishing country and certainly not the country of the author, which might be more important. I'd not even assume the language ID is correct. It might be the language selected at the time an ISBN block was bought. Technically it might just be an official language of the Registrant's Country. Thus a book with 1 (for English) could be in Irish, Manx, Cornish, Channel Is. Norman-French, Scot's Gaelic, Doric, Ulster-Scots etc. Maybe even in Maltese.

[DaltonST]

See the attached matrix of book:identifiers created by the Job Spy plugin. The JS Tool is under the Metadata sub-menu with the obvious item name.


DaltonST

[Quoth]

Originally Posted by DaltonST

See the attached matrix of book:identifiers created by the Job Spy plugin.

But what use is it to ordinary humans?

[BetterRed]

Originally Posted by Quoth

But what use is it to ordinary humans?

Bugger all, but it might be very useful to a professional librarian.

BR

[Quoth]

Originally Posted by BetterRed

Bugger all, but it might be very useful to a professional librarian.

Ook!

Where are the bananas?

[maddz]

What are you trying to achieve by sorting by ID? Not every entry will have an ISBN, and even if it does, it may be incorrect or duplicated or a weird format.

A unique ID for all your records is the Calibre ID which corresponds to the book ID in the Calibre database. I use it to link to link the Calibre record to the corresponding record in my LibraryThing account.

[theducks]

Wait up, this is getting confusing My first answer was because I thought they wanted the Calibre index # sorted

{id} is the CALIBRE index number seen at the end of a folder name

C:\Users\thedu\Calibre Library\John Schember\Quick Start Guide (1)

{identifiers:isbn} finds (catalog) Ids like ISBN
Kovid, can this label in details be changed to Identifiers, thus making it real clear which we are talking about ?

[BetterRed]

↑ ↑ ↑

This is why my libraries have a '#book-num/Book#' virtual column using the template {id}.

BR

[dunhill]

As indicated above, the isbn of a book varies if it is a soft cover or a hard cover.
What I do is assign an identifier according to the store that bought the book.
And in a personalized column according to the store, it brings me the corresponding isbn.