MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management
Reload this Page Search based on the comparison of two columns

Notices

Reply
 
Thread Tools Search this Thread
Old 10-28-2022, 09:08 AM   #1
Nicolas.Laurent
Member
Nicolas.Laurent began at the beginning.
 
Posts: 22
Karma: 10
Join Date: Jun 2016
Location: France
Device: PocketBook Touch Lux 2
Search based on the comparison of two columns
Hello to all

I am looking for a way to display a list of books for which the value of two columns are equal. To be more specific, I have created two custom columns (last name & first name), and I am looking to display the books for which the last name is similar to the first name.

Thanks in advance for your help
Nicolas.Laurent is offline   Reply With Quote
Old 10-28-2022, 09:40 AM   #2
un_pogaz
Chalut o/
un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.un_pogaz understands the importance of being earnest.
 
un_pogaz's Avatar
 
Posts: 439
Karma: 145424
Join Date: Dec 2017
Device: Kobo
Click on the little gear one the search barre. In the dialog, select the tab "Template search".

For you it will be something like this:
Code:
program: strcmp($#first_name, $#last_name, 0, 1, 0)
One the first field 1.

Depending on what you want exactly, I recommend you to watch the The calibre template language
Attached Thumbnails
Click image for larger version Name: Capture d’écran 2022-10-28 153743.png Views: 108 Size: 30.1 KB ID: 197409  
Last edited by un_pogaz; 10-28-2022 at 09:46 AM.
un_pogaz is offline   Reply With Quote
Advert
Old 10-29-2022, 10:28 AM   #3
DaltonST
Deviser
DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.DaltonST ought to be getting tired of karma fortunes by now.
 
DaltonST's Avatar
 
Posts: 2,265
Karma: 2090983
Join Date: Aug 2013
Location: Texas
Device: none
There is a plugin for that type of thing: 'Multi-Column Search'. Both intra-book and inter-book.
DaltonST is offline   Reply With Quote
Old 11-02-2022, 11:50 PM   #4
Fynjisx
Connoisseur
Fynjisx began at the beginning.
 
Posts: 91
Karma: 10
Join Date: Jul 2022
Location: Greenland
Device: xiaomi
Quote:
Originally Posted by DaltonST View Post
There is a plugin for that type of thing: 'Multi-Column Search'. Both intra-book and inter-book.
what is the name of this plugin
Fynjisx is offline   Reply With Quote
Old 11-02-2022, 11:59 PM   #5
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 21,710
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by DaltonST View Post
There is a plugin for that type of thing: 'Multi-Column Search'. Both intra-book and inter-book.
Quote:
Originally Posted by Fynjisx View Post
what is the name of this plugin
Try 'Multi-Column Search' ==>> Index of plugins

BR
BetterRed is offline   Reply With Quote
Advert
Old 11-08-2022, 11:51 AM   #6
Nicolas.Laurent
Member
Nicolas.Laurent began at the beginning.
 
Posts: 22
Karma: 10
Join Date: Jun 2016
Location: France
Device: PocketBook Touch Lux 2
Thanks a lot for all your answers!
Nicolas.Laurent is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting custom columns with a value based on a keyboard shortcut? unabatedshagie Calibre 3 06-15-2017 03:06 PM
How to colour columns based on timestamp or on author_link odinokij Library Management 4 11-09-2012 08:18 PM
book comparison/search mpd123 General Discussions 3 05-31-2011 10:46 PM
AddAll Ebook price comparison search plugin MetaEbooks Deals and Resources (No Self-Promotion or Affiliate Links) 5 10-24-2009 03:51 AM
A Comparison of format limitations based on The Hobbit wallcraft Workshop 89 10-12-2009 12:48 PM


All times are GMT -4. The time now is 06:03 AM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.