Search comparing two columns

Terisa de morgan · 06-07-2015, 06:58 AM

Hi,

I don't know if this has already been answered (I haven't found any example or related thread). Is there any way to search the records where two field fulfill a condition: #les > #nes, for example.

Thank you in advance

kovidgoyal · 06-07-2015, 10:40 AM

No, but you can achieve it in a roundabout way by creating a custom column witha template that outputs the result of the comparison and then search on that column.

Terisa de morgan · 06-07-2015, 12:28 PM

Thank you, I was afraid about it.

06-07-2015, 06:58 AM	#1
Terisa de morgan Grand Sorcerer Posts: 6,689 Karma: 13151331 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	Search comparing two columns Hi, I don't know if this has already been answered (I haven't found any example or related thread). Is there any way to search the records where two field fulfill a condition: #les > #nes, for example. Thank you in advance

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Newbie: I can't get search to work on custom columns	Rudy1949	Library Management	3	07-21-2014 01:08 AM
Search keywords in yes/no columns	Jellby	Calibre	1	07-14-2014 11:58 AM
I got this error when comparing search replace results!	user743	Editor	0	06-26-2014 09:30 PM
Comparing epubs after using Regex	Gregg Bell	Sigil	3	08-02-2013 11:22 PM
Comparing epubs	DrChiper	Sigil	10	05-01-2013 02:45 PM

06-07-2015, 10:40 AM	#2
kovidgoyal creator of calibre Posts: 45,653 Karma: 28549046 Join Date: Oct 2006 Location: Mumbai, India Device: Various	No, but you can achieve it in a roundabout way by creating a custom column witha template that outputs the result of the comparison and then search on that column.

06-07-2015, 12:28 PM	#3
Terisa de morgan Grand Sorcerer Posts: 6,689 Karma: 13151331 Join Date: Jun 2009 Location: Madrid, Spain Device: Kobo Clara/Aura One/Forma,XiaoMI 5, iPad, Huawei MediaPad, YotaPhone 2	Thank you, I was afraid about it.

Advert