[SOLVED] Exclude a page from query

Queries
1

Pages with book notes have property type:: book. I have a template to create book page, so of course it too has that property.

To just get a list of books without the Template page, I compiled this:

#+BEGIN_QUERY
{:title [:h3 "Books read"]
 :query [:find (pull ?b [*])
     :where
     [?b :block/properties ?prop]
     [(get ?prop :type) ?type]
     [(= ?type "book")]
     (not [?b :page "templates"])
     ]
     }
#+END_QUERY

Unfortunately, in table lay-out the list only shows the table headings but no list with titles.
What amendment do I need to make to the syntax?

2

I don’t understand your question?
What are you seeing and what are you trying to see?

3

@Siferiax a simple query {{query (property type book)}} gives me this output:

image

That is what I want to see, ideally sorted alphabetically (A @ top, Z @ bottom), but without the Templates page.

So, I tried to compile an advanced query, as shown in my OP. But then the output is this:

image

which, besides the headings, shows nothing, nada, zilch, niks.

4

You mean pages that contains blocks that have the property, right?

In that case have you tried:

{{query (and (property :type book) (not (property :template)))}}

or, if you want to exclude blocks from the page Templates specifically:

{{query (and (property :type book) (not (page [[Templates]])))}}

1 Like
5

Thanks for jumping in :grinning:

I had to modify that slightly: {{query (and (property :type book) (not (page Templates)))}}, which then gives me what I want.

Is there a way to sort the rendered list alphabetically (titles starting with A at the top, those with Z at the bottom), or would I then need an advanced query?

6

By default you should see the results (blocks) grouped by page and the pages are sorted alphabetically.

And in table view you should have both a “Block” and a “Page” columns that can be used to sort alphabetically by blocks and pages name respectively.

7

Yep, that works indeed! Thanks for your help.
I have marked your OP as the solution.

1 Like