|
Hmmm.... interesting challenge.
Given the existence of the kindle collections column, I think the query could be described as:
step 1: find all books by any author of a book with an entry in k_collections. Lets call this list "possibles".
step 2: find all books with an author in possibles and k_collections:false.
You can do this using user categories. What you do is:
1. Create a user category called "possibles" (or some such). Make sure it has no items in it.
2. Search for k_collections:true. Finds all books in kindle collections.
3. Select all books found in step 2.
4. Click/drag any authors cell to possibles. This will enter all the authors for the selected books into the user category.
We now have the list "possibles" described in step 1.
The search described in step 2 is "@possibles:true and k_collections:false" (no quotes). This will find all books by authors listed in the user category that do not have a value in k_collections.
|