Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 05-06-2022, 07:12 AM   #1
rracoon01
Connoisseur
rracoon01 began at the beginning.
 
rracoon01's Avatar
 
Posts: 88
Karma: 10
Join Date: Nov 2013
Device: android tablets
Searching broken in V5.42?

The Calibre update 6.42 appears to have broken something with the operations on some custom columns. I have a custom column name “booktype” that is setup as “Text, but with a fixed set of values”. The field is fully populated on all records. Prior to the update the search

#booktype:wishlist

Would return about 200+ books and now it returns zero books. I have verified that the data is the same as always and of course the virtual library where I use a command with this kind of logic remains unchanged. So I paired the logic down on the virtual library specification until I saw that it failed as described above.

Please advise.
rracoon01 is offline   Reply With Quote
Old 05-06-2022, 07:20 AM   #2
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Moderator Notice
Post moved. It has nothing to do with system colors.
chaley is offline   Reply With Quote
Old 05-06-2022, 08:02 AM   #3
kovidgoyal
creator of calibre
kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.kovidgoyal ought to be getting tired of karma fortunes by now.
 
kovidgoyal's Avatar
 
Posts: 45,351
Karma: 27182818
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
searching for a value in such a column is working for me. The change in the latest release is that searching by default ignores punctuation. If your values have punctuation and spaces then tryprefixing your search with = like this

#booktype:=wishlist
kovidgoyal is offline   Reply With Quote
Old 05-06-2022, 08:08 AM   #4
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,725
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
Quote:
Originally Posted by rracoon01 View Post
The Calibre update 6.42 appears to have broken something with the operations on some custom columns. I have a custom column name “booktype” that is setup as “Text, but with a fixed set of values”. The field is fully populated on all records. Prior to the update the search

#booktype:wishlist

Would return about 200+ books and now it returns zero books. I have verified that the data is the same as always and of course the virtual library where I use a command with this kind of logic remains unchanged. So I paired the logic down on the virtual library specification until I saw that it failed as described above.

Please advise.
What happens if you put the #booktype:wishlist search term in the search bar with the "All Books" 'virtual' library selected.

I have a similar column (#status) and #status:converted etc are working fine on 5.42, but that column is not used to define any VLs.

BR
BetterRed is offline   Reply With Quote
Old 05-06-2022, 03:10 PM   #5
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,974
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
I also have an enumerated #booktype column for use in VLs and it's still working for me.

What happens if you show the column to tag browser? You may need to enable it in preferences > add your own column > edit settings of #booktype > 'Show in Tag Browser'. actually I think enumerated columns appear in the tag browser by default.
Attached Thumbnails
Click image for larger version

Name:	2022-05-06 16_14_58-calibre — __ My Books __.png
Views:	74
Size:	7.4 KB
ID:	193657  

Last edited by ownedbycats; 05-06-2022 at 06:01 PM.
ownedbycats is offline   Reply With Quote
Old 05-07-2022, 06:43 AM   #6
rracoon01
Connoisseur
rracoon01 began at the beginning.
 
rracoon01's Avatar
 
Posts: 88
Karma: 10
Join Date: Nov 2013
Device: android tablets
That did not help. Still selecting zero records. Search seems to be correct in a similar virtual library and even, as another responder suggested, if I just put it in for all Books. Deleted the virtual library and rebuilt it with same results.
rracoon01 is offline   Reply With Quote
Old 05-13-2022, 05:26 PM   #7
rracoon01
Connoisseur
rracoon01 began at the beginning.
 
rracoon01's Avatar
 
Posts: 88
Karma: 10
Join Date: Nov 2013
Device: android tablets
This continues to be a problem for me. I have tried every permutation of logic and still can't get the records I am looking for. And I think you are on to it with the business of punctuation. One of the values I am looking for is that a custom column that is computed from other columns does not contain a @. I can't prefix that with = because I want to exclude any record that has the @ anywhere in that field via use of a not qualifier. So I have played with all the other search parameters and everything goes correctly until I introduce the check for the @ and then it goes from 300+ records, some containing @, down to zero when there are over 200 records that should qualify. All of this worked perfectly prior to update 5.42.

This is what my query looks like after messing around with the = qualifier

(#booktype:="wishlist" or #booktype:="paper") and (not #hasoid:="Not Avail, check again") and (not #hasoid:"@").

From the population of books that are either wishlist or paper in #booktype, I want to further exclude any that are Not Available and do not have an @ in #hasoid
rracoon01 is offline   Reply With Quote
Old 05-13-2022, 05:33 PM   #8
ownedbycats
Custom User Title
ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.ownedbycats ought to be getting tired of karma fortunes by now.
 
ownedbycats's Avatar
 
Posts: 10,974
Karma: 75337983
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
What happens if you enclose the equal sign inside the quotation marks? e.g. #booktype:"=wishlist"

For the @, try "~@" — the squiggly (always forget the real name ) makes it a regex search, which doesn't ignore the puncuation.

Last edited by ownedbycats; 05-13-2022 at 05:42 PM.
ownedbycats is offline   Reply With Quote
Old 05-13-2022, 05:46 PM   #9
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by rracoon01 View Post
(#booktype:="wishlist" or #booktype:="paper") and (not #hasoid:="Not Avail, check again") and (not #hasoid:"@").
The problem is (not #hasoid:"@"). Because punctuation is ignored, #hasoid:"@" searches for books for nothing therefore matching all books, so not #hasoid:"@" matches no books.

Use regular expression searching to work around the problem, i.e., #hasoid:"~@". This works unless a character in the search string is 'special' to regular expressions, for example a period, in which case you need to use "~\\."

In general, with the new searching if you wish to search for explicit punctuation or spaces then you must use regular expression searching. As a consequence you must understand regular expression special characters and how to escape them.
chaley is offline   Reply With Quote
Old 05-13-2022, 05:48 PM   #10
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
Quote:
Originally Posted by ownedbycats View Post
For the @, try "~@" — the squiggly (always forget the real name ) makes it a regex search, which doesn't ignore the punctuation.
Its real name is tilde. For some reason many people call it "twiddle".
chaley is offline   Reply With Quote
Old 05-14-2022, 04:07 PM   #11
rracoon01
Connoisseur
rracoon01 began at the beginning.
 
rracoon01's Avatar
 
Posts: 88
Karma: 10
Join Date: Nov 2013
Device: android tablets
Thanks to those folks who came up with the tilde solution. I had seen that in the documentation but it meant little to me as I don't know Python and regular expressions.

Problem fixed.
rracoon01 is offline   Reply With Quote
Reply


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Kindle PW3 5.9.6.1 ssh broken pipe leaves broken ssh xception Kindle Developer's Corner 8 01-27-2019 10:23 AM
Buy Searching for a PRS-T1 with a broken screen. Kintaro Oe Flea Market 0 08-20-2013 08:29 AM
Broken PRS-505; any place to buy chrome bottom piece? Or anyone with broken 505? erikk Sony Reader 1 12-09-2009 06:51 PM
Broken Ipod works Fine! except that its broken Andybaby Lounge 1 06-04-2009 02:03 AM
Searching for an broken Iliad with unbroken Display Stenis iRex 0 11-28-2008 05:58 PM


All times are GMT -4. The time now is 04:15 AM.


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