NOT EQUAL (!=) and OR in Search

HFC3 · 07-06-2013, 03:13 PM

How do you code a "not equal" condition in a search filter?

Help says any Python expression is accepted, but I can't get != to work;
{field}!={value}
{field}:!={value}
{field}:!{value}

All return no results.

Also, how do you code an OR? .{val}.{val} works for an itemized list field as an AND, but how would I code an OR?

And, how do you code an AND or an OR where the blank value is also OK?

Thanks!

itimpi · 07-06-2013, 04:38 PM

I think you missed the obvious

You can use the words 'and', 'not' and 'or' (without the quotes) and use brackets for grouping.

kovidgoyal · 07-06-2013, 11:07 PM

http://manual.calibre-ebook.com/gui....arch-interface

HFC3 · 07-07-2013, 03:11 AM

LOL I thought of that about 45 minutes after posting the thread while driving to Phoenix. I hate when that happens!

Thanks

07-06-2013, 03:13 PM	#1
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	[SOLVED] NOT EQUAL (!=) and OR in Search How do you code a "not equal" condition in a search filter? Help says any Python expression is accepted, but I can't get != to work; {field}!={value} {field}:!={value} {field}:!{value} All return no results. Also, how do you code an OR? .{val}.{val} works for an itemized list field as an AND, but how would I code an OR? And, how do you code an AND or an OR where the blank value is also OK? Thanks! Last edited by HFC3; 07-07-2013 at 03:12 AM. Reason: Annotate solved

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I select books where #language is equal to #original_language?	arspr	Library Management	31	03-26-2011 06:02 AM
Are all K3s created equal?	vega07	Amazon Kindle	23	12-16-2010 07:02 AM
eBook pricing still not equal between stores	jswinden	Amazon Kindle	11	09-07-2010 10:01 PM
eBook pricing still not equal between stores	jswinden	Sony Reader	0	09-07-2010 12:38 PM
"E-book access not so equal" from the Daily Illini	Nate the great	News	1	12-11-2009 01:16 PM

07-06-2013, 04:38 PM	#2
itimpi Wizard Posts: 4,553 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	I think you missed the obvious You can use the words 'and', 'not' and 'or' (without the quotes) and use brackets for grouping.

07-06-2013, 11:07 PM	#3
kovidgoyal creator of calibre Posts: 45,198 Karma: 27110894 Join Date: Oct 2006 Location: Mumbai, India Device: Various	http://manual.calibre-ebook.com/gui....arch-interface

07-07-2013, 03:11 AM	#4
HFC3 Enthusiast Posts: 30 Karma: 10 Join Date: Apr 2013 Device: Kindle Touch	LOL I thought of that about 45 minutes after posting the thread while driving to Phoenix. I hate when that happens! Thanks

Advert