syntax query: author equals publisher

[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,

[chaley]

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:

{authors:'strcmp($, field('publisher'), 'No', 'Yes', 'No')'}

The column will contain Yes if author == publisher, No otherwise.

[jpsurf]

Thanks for the clear answer. I don't have to think about any longer!