Perfect Charles, I've just tested your new function.
I've used it in a new column which I've called "#global_author_sort". And then, through another one, {:'strcmp(field('#global_author_sort'), field('author_sort'), 'Yes', 'No', 'Yes')'}, I've set up a quick test where I can easily see which books seem to have a bogus Author Sort value.
Now I have another question: is there a function to call the sorting process Calibre perform in titles? I mean the process Calibre follows to fill "title_sort" from "title" by default. I would like to built up a similar auxiliary column in order to quickly detect possible strange values in "title_sort". Something like:
Perfect Charles, I've just tested your new function.
I've used it in a new column which I've called "#global_ author_ sort". And then, through another one, {:'strcmp( field(' #global_ author_ sort'), field(' author_ sort'), 'Yes', 'No', 'Yes')'}, I've set up a quick test where I can easily see which books seem to have a bogus Author Sort value.
(Playing with it I've discovered https:/ /bugs.launchpad .net/calibre/ +bug/1368928)
Now I have another question: is there a function to call the sorting process Calibre perform in titles? I mean the process Calibre follows to fill "title_sort" from "title" by default. I would like to built up a similar auxiliary column in order to quickly detect possible strange values in "title_sort". Something like:
{:'strcmp( the_function_ I_am_asking_ about(field( 'title' ), maybe_language_ code_also_ needed_ here), field(' title_sort' ), 'Yes', 'No', 'Yes')'}