|
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
|