Quote:
Originally Posted by jpsurf
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.