invert search for custom fields (GUI)

rogue_librarian · 07-25-2011, 10:54 AM

If would like Calibre to display all records with a custom field different from a given resulst, i.e. a Boolean NOT.

I have

Code:

#my_field:"=foo"

working as expected. How would I search for fields other than foo? For a single letter a regular expression might work, something like

PHP Code:


			
#my_field:"~[^X]"

but for a string?

Is there an easy way to tell Calibre to display #my_field except if it contains "foo"?

chaley · 07-25-2011, 11:01 AM

not #my_field:"=foo"

theducks · 07-25-2011, 11:01 AM

Quote:

Originally Posted by rogue_librarian

If would like Calibre to display all records with a custom field different from a given resulst, i.e. a Boolean NOT.

I have

Code:

#my_field:"=foo"

working as expected. How would I search for fields other than foo? For a single letter a regular expression might work, something like

PHP Code:


			
#my_field:"~[^X]"

but for a string?

Is there an easy way to tell Calibre to display #my_field except if it contains "foo"?

have you tried putting a "not" in front of your (string) search term?

rogue_librarian · 07-25-2011, 11:15 AM

I did, it was the first thing I tried, and I could've sworn it didn't work. Now it looks as though it actually does. Thank you, I guess foolish is as foolish does...

theducks · 07-25-2011, 11:36 AM

Quote:

Originally Posted by rogue_librarian

I did, it was the first thing I tried, and I could've sworn it didn't work. Not it looks as though it actually does. Thank you, I guess foolish is as foolish does...

Use the Tag Browser to help construct query code (custom fields are there)
choose match any or match all at the bottom of the list area
1 click (Green Plus) include
2 click (Red minus) Not
hold ctrl key down to allow additional terms.

07-25-2011, 10:54 AM	#1
rogue_librarian Guru Posts: 973 Karma: 4269175 Join Date: Apr 2010 Location: Europe Device: Pocketbook Basic 613	invert search for custom fields (GUI) If would like Calibre to display all records with a custom field different from a given resulst, i.e. a Boolean NOT. I have Code: #my_field:"=foo" working as expected. How would I search for fields other than foo? For a single letter a regular expression might work, something like PHP Code: `#my_field:"~[^X]"` but for a string? Is there an easy way to tell Calibre to display #my_field except if it contains "foo"?

07-25-2011, 11:15 AM	#4
rogue_librarian Guru Posts: 973 Karma: 4269175 Join Date: Apr 2010 Location: Europe Device: Pocketbook Basic 613	I did, it was the first thing I tried, and I could've sworn it didn't work. Now it looks as though it actually does. Thank you, I guess foolish is as foolish does... Last edited by rogue_librarian; 07-25-2011 at 12:49 PM.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy between libs, keep custom fields	drMerry	Library Management	1	05-24-2011 06:56 PM
Edit MultiData Search and Replace to multiple fields	Doug-W	Library Management	1	02-22-2011 03:17 PM
Catalogs & Custom Fields	nynaevelan	Library Management	14	10-27-2010 04:55 PM
Calibre beta available that fully integrates custom fields	chaley	Calibre	206	10-03-2010 02:28 AM
Sony collections and custom fields: how to handle duplicates?	chaley	Calibre	13	09-02-2010 04:11 PM

07-25-2011, 11:01 AM	#2
chaley Grand Sorcerer Posts: 11,728 Karma: 6690881 Join Date: Jan 2010 Location: Notts, England Device: Kobo Libra 2	not #my_field:"=foo"

Advert

Advert