Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 04-06-2015, 10:04 AM   #1
jpsurf
Junior Member
jpsurf began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Jan 2015
Device: tolino vision
syntax query: author equals publisher

Hello!
I want to clean my metadata. A query selecting all books, where author equals publisher would save be much time. Something in the way: author:=publisher, but this is not working Whats the right syntax,
jpsurf is offline   Reply With Quote
Old 04-06-2015, 12:30 PM   #2
chaley
"chaley", not "charley"
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
chaley's Avatar
 
Posts: 6,649
Karma: 1891006
Join Date: Jan 2010
Location: France
Device: Many android devices
Quote:
Originally Posted by jpsurf View Post
Hello!
I want to clean my metadata. A query selecting all books, where author equals publisher would save be much time. Something in the way: author:=publisher, but this is not working Whats the right syntax,
You can't do that in a search expression. It does not support relational operators. However, you can create a custom column "from other values" (Preferences / Add your own columns) that computes what you want, then search on that.

One template for the custom column could be:
Code:
{authors:'strcmp($, field('publisher'), 'No', 'Yes', 'No')'}
The column will contain Yes if author == publisher, No otherwise.
chaley is offline   Reply With Quote
 
Advertisement
Old 04-06-2015, 01:09 PM   #3
jpsurf
Junior Member
jpsurf began at the beginning.
 
Posts: 3
Karma: 10
Join Date: Jan 2015
Device: tolino vision
syntax query: author equals publisher

Thanks for the clear answer. I don't have to think about any longer!
jpsurf is offline   Reply With Quote
Reply

Tags
query

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Library skips publisher, goes directly to author kennyc Writers' Corner 5 08-05-2013 06:26 AM
A query about author names TimK2012 Library Management 1 01-12-2012 10:21 AM
how to mass move publisher to author stanmarsh Library Management 6 11-05-2011 09:26 AM
The Shadow Warriors equals high tech crimes and misdemeanors judyinboston Self-Promotions by Authors and Publishers 0 05-10-2011 06:39 PM
Indie author/publisher Haunted Computer Books Scott Nicholson Introduce Yourself 8 02-16-2010 02:51 PM


All times are GMT -4. The time now is 01:35 AM.


MobileRead.com is a privately owned, operated and funded community.