View Single Post
Old 06-11-2014, 12:38 AM   #13
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
Quote:
Originally Posted by kovidgoyal View Post
If you want a tags like column in which order is preserved you can create a custom column in Preferences->Add your own columns (check the box that says 'Contains names'). IIRC, order is preserved for tags like columns containing names, just like it is for the authors column, you will have to use & instead of , as the separator, however.

@davidfor: Order information for all many-many columns is stored in the link table, the order in which the entries for a particular book appear in that table is significant.
Oops. I didn't look at the actual structure, just viewed the data. The viewer I was using can display a rowid as the first column. I read the "id" column as that number.

That order was what I was referring to. But, as I hadn't noticed that the primary key was the id, I assumed it was just the row creation order. The id does give a sequence for the tags in the book. I can see similar things happening with all the link tables.

For the tags, there is some inconsistency in the display. In the metadata edit screen, they in the id order. Everywhere else they are in alphabetical order. The OP, and I agree, feels that tag order is important. Having them displayed in this order would be good.

Of course, I think I know the answer: "Patches are welcome"
davidfor is offline   Reply With Quote