Advanced Query to get all Tasks except from a single page

Questions & Help Queries
1

Hi,

i want to build an advanced query to show all Tasks that are NOW, LATER, TODO and DOING in my Journals except from a single file.

I therefore added a query to my config.edn. However, filterting out the file (which is named tasks, should that matter) is too hard for me.

This is my Datalog Query that i have worked on.
Commented are some ideas that I thought should also work… ^^

    {:title [:b "🟢 ACTIVE"]
    :query [
    :find (pull ?b [*])
    :where
    [?b :block/marker "LATER"]
    ;;; (task ?b #{"NOW" "LATER" "TODO" "DOING"})

    [?b :block/name ?pagename]
    ([(clojure.string/starts-with? ?pagename "tasks")])

    ;;; [?b :block/refs ?pagename]
    ]
    :breadcrumbs-show? true
    :collapsed? false}

I know its a noob question, and I will appreciate all help from you guys <3

2

Welcome. The typical approach would be like this:

[?b :block/page ?page]
(not [?page :block/name "tasks"])
2 Likes