View Single Post
Old 10-05-2018, 04:06 PM   #1
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: 11,037
Karma: 75555555
Join Date: Oct 2018
Location: Canada
Device: Kobo Libra H2O, formerly Aura HD
Help with search query; excluding books with a single format

Hi. I've been lurking here for a little while and been a happy user of Calibre since 2013 but only just now registered. I've started using Calibre to catalog my physical books (couldn't find a satisfactory solution for a while, thought "I wish there was something like Calibre for paper books...wait..."), using dummy.paperbook files so they appear in the format category.

I've created a virtual library for the physical books, using the search query "formats:#=1 and formats : paperbook" for the Paper Books sublibrary.

The problem, though, lies in the default virtual library (which already excludes a specific tag). I'd like to exclude books that have only a paperbook format. A simple "not formats : paperbook" doesn't work as I have books with both physical and digital formats that I do want to appear. Can't quite figure out how to accomplish this.
Things I've tried:
"formats : paperbook AND formats:epub" for each different format - rather unwieldy
"formats : paperbook AND formats:#=2" only works for books with two formats
(both of those resulted in every other book getting excluded as well)

I hope someone here may be able to help with this.

Last edited by ownedbycats; 10-05-2018 at 04:27 PM.
ownedbycats is offline   Reply With Quote