View Single Post
Old 01-25-2014, 01:41 PM   #623
Gary_M_Mugford
Groupie
Gary_M_Mugford has a complete set of Star Wars action figures.Gary_M_Mugford has a complete set of Star Wars action figures.Gary_M_Mugford has a complete set of Star Wars action figures.
 
Gary_M_Mugford's Avatar
 
Posts: 180
Karma: 299
Join Date: Jul 2010
Location: Brampton ON
Device: Kobo, Kindle3
Hi all,

At the risk of confirming my lack of expertise, I must admit to having a problem. I'm trying to write a search that, after using the Count plug-in, will show me the the books that have a blank value in the pgs column. I have tried date:>=2daysago and #pgs:blank and that earns me a red search box. date:>=2daysago and #pgs:empty does the same. Changing to #pgs:<1 gives me a green box, but no results. Which is wrong. Eliminating the # prefix to pgs produces almost the exact cycle, except all searches are green, with no results and wrong.

Pgs is an integer column and works perfectly fine with the count plug-in. When the Count plug-in returns an info box saying it couldn't calculate for x books, I've assumed it was because the file was in a format that can't be counted, DOC for example. And I let things go. But I found an instance of an EPUB that wasn't counted. I clicked on the book and discovered it was corrupted. I had to delete the book.

Where there is one, there are more. So, I'd like to write a search that would find problematical books so that I could investigate.

Any ideas on how I should create my search to do that?

Thanks in advance for any help, GM
Gary_M_Mugford is offline   Reply With Quote