search

coolPrat / and-bookworm

Automatically exported from code.google.com/p/and-bookworm
0 stars 0 forks source link

Use standardized title sort and display #99

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
RWhat steps will reproduce the problem?
1. View book list
2.
3.

What is the expected output? What do you see instead?

Dawkins' book 'The Blind Watchmaker' is sorted by its first word, 'The', but 
standard library sort order would sort it by 'Blind', as though the book were 
titled without that word, and appear as 'Blind Watchmaker, The'.

What version of the product are you using? On what operating system?
Latest on Market, Android 2.1

Please provide any additional information below.

Original issue reported on code.google.com by pmccul...@gmail.com on 9 Aug 2010 at 5:34

GoogleCodeExporter commented 8 years ago 
I think what you are referring to is not "standard," but yes, commonly used. 
Seems like the "mechanical" sort order disregarding leading articles. 

http://en.wikipedia.org/wiki/Library_catalog

"In the mechanical sort order, the first word of the title is the first sort 
term. Most new catalogs use this scheme, but still include a trace of the 
grammatical sort order: they neglect an article (The, A, etc.) at the beginning 
of the title."

We could do this for English, but there are complications for other languages 
as that article notes.

Original comment by charlie....@gmail.com on 29 Aug 2010 at 6:58

GoogleCodeExporter commented 8 years ago

Original comment by charlie....@gmail.com on 29 Aug 2010 at 6:58

GoogleCodeExporter commented 8 years ago 
I looked into this more and it gets tricky. What about "A is for Alibi"? and 
such, we don't know to remove the leading article then? 

More info 
http://stackoverflow.com/questions/1285849/custom-order-by-to-ignore-the

Original comment by charlie....@gmail.com on 19 Oct 2010 at 3:16

GoogleCodeExporter commented 8 years ago 
At the same time we do the sort by last name, we could add a "title_sort" 
column, and we could strip articles that go in that. Still tough in some cases 
though (like "A is for Alibi").

Original comment by charlie....@gmail.com on 19 Oct 2010 at 7:59