|
|
#1 |
|
Connoisseur
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 60
Karma: 1231814
Join Date: Nov 2017
Device: Kobo Libra Colour, Kindle Voyage(s)
|
Search if "this column" is more than "that column"?
Is there any way to search for books where one numeric column is more than a different numeric column? That is:
the number in column ABC > the number in column XYZ? And just to complicate things a bit more, is there any way to throw a calculation into that - e.g. the number in column ABC > the number in column XYZ *10? |
|
|
|
|
|
#2 |
|
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,528
Karma: 8065948
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
See https://www.mobileread.com/forums/sh...d.php?t=349908
For the template search in post 2, use something like Code:
program: $$#abc ># $$#def For more info see the calibre manual:
Last edited by chaley; 02-07-2024 at 05:14 AM. Reason: Changed the raw field reference to a custom column. |
|
|
|
| Advert | |
|
|
|
|
#3 |
|
Connoisseur
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 60
Karma: 1231814
Join Date: Nov 2017
Device: Kobo Libra Colour, Kindle Voyage(s)
|
Thank you :-)
|
|
|
|
![]() |
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Reading time by creating a column with "word count"/"your wpm" | Anyssia | Calibre | 2 | 01-04-2019 02:02 PM |
| Custom column for "Volume" and "Version" (Revision) | BaronKrause | Library Management | 10 | 11-02-2017 10:20 PM |
| How to search Author column for "The " or "A " | Inferno | Library Management | 11 | 07-28-2014 06:24 PM |
| How to search for "&" in authors column? | manawydan | Library Management | 30 | 03-07-2014 06:54 AM |
| Custom column: "Updated date", when adding new "versions" of the same file? | enriquep | Library Management | 16 | 11-03-2011 11:46 AM |