![]() |
#1 |
Member
![]() 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 |
![]() |
![]() |
![]() |
#2 |
Chalut o/
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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) Depending on what you want exactly, I recommend you to watch the The calibre template language Last edited by un_pogaz; 10-28-2022 at 09:46 AM. |
![]() |
![]() |
Advert | |
|
![]() |
#3 |
Deviser
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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.
|
![]() |
![]() |
![]() |
#4 |
Connoisseur
![]() Posts: 91
Karma: 10
Join Date: Jul 2022
Location: Greenland
Device: xiaomi
|
|
![]() |
![]() |
![]() |
#5 | |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 21,710
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
BR |
|
![]() |
![]() |
Advert | |
|
![]() |
#6 |
Member
![]() Posts: 22
Karma: 10
Join Date: Jun 2016
Location: France
Device: PocketBook Touch Lux 2
|
Thanks a lot for all your answers!
|
![]() |
![]() |
![]() |
|
![]() |
||||
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 |