View Single Post
Old 06-08-2019, 10:39 AM   #15
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,141
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by Ahu Lee View Post
That did what I wanted! But I should say this was absolutely counterintuitive to me. "Column built from other columns" could be called "The quick brown fox jumps over the lazy dog" and it would make as much sense to me.
While it said 'from other', it did not mandate that you must use more than one (which is what a lot of people mostly do).

As others have pointed out: table (more columns and those 'built') bloat, slow things down. The bigger the Library, the more important this becomes.
FWIW
Code:
author_sort:jones
is a valid Search term, even though you can't see the column. And sorting on the Authors column (as shipped settings) really uses {author_sort}, but you Still SEE the authors first name, but in the proper order
Anne Lee Jones
Mary Jones
Wilbur Jones
(or
Jones, Anne Lee
Jones, Mary
Jones, Wilbur
)
theducks is offline   Reply With Quote