![]() |
#1 |
Connoisseur
![]() 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. |
![]() |
![]() |
![]() |
#2 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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. |
![]() |
![]() |
![]() |
#3 |
creator of calibre
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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 |
![]() |
![]() |
![]() |
#4 | |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 21,725
Karma: 29711016
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
Quote:
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 |
|
![]() |
![]() |
![]() |
#5 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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. Last edited by ownedbycats; 05-06-2022 at 06:01 PM. |
![]() |
![]() |
![]() |
#6 |
Connoisseur
![]() 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.
|
![]() |
![]() |
![]() |
#7 |
Connoisseur
![]() 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 |
![]() |
![]() |
![]() |
#8 |
Custom User Title
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 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 ![]() Last edited by ownedbycats; 05-13-2022 at 05:42 PM. |
![]() |
![]() |
![]() |
#9 | |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
Quote:
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. |
|
![]() |
![]() |
![]() |
#10 |
Grand Sorcerer
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 12,447
Karma: 8012886
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
|
|
![]() |
![]() |
![]() |
#11 |
Connoisseur
![]() 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. |
![]() |
![]() |
![]() |
|
![]() |
||||
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 |