I have Few Project Pages. Wanted a query which lists Tasks linked to Non Project Page.
In example both “curate” and “minimalism” are non Project Pages.
However the query Below only Lists “Todo 1” from curate but “Test Mini” is not listed until i remove the clause to exclude, pages with property.
#+BEGIN_QUERY
{:title [:h3 "⚓ Projectless"]
:query [:find (pull ?b [*])
:where
[?b :block/path-refs ?p]
(task ?b #{"LATER" "TODO"})
(not [?b :block/scheduled])
(not [?b :block/deadline])
[?p :page/properties ?prop]
(not [(get ?prop :status) ?s])
]
}
#+END_QUERY
Strangely Page Minimalism has no Page Property but still is getting filtered.
Debug Details
Removing Property Match Clauses make results appear.
[?p :page/properties ?prop]
(not [(get ?prop :status) ?s])
Block Info
{:block/uuid #uuid "6534b7f3-f557-4a0f-8fac-43031535b3fd",
:block/left {:db/id 93},
:block/refs [{:db/id 4}],
:block/format :markdown,
:block/content "TODO Todo 1",
:db/id 90,
:block/path-refs [{:db/id 4} {:db/id 88} {:db/id 89}],
:block/parent {:db/id 93},
:block/page {:db/id 89},
:block/marker "TODO"}
{:block/uuid #uuid "6534b7f3-c4b8-4f90-80ef-5bcf14298ad0",
:block/left {:db/id 91},
:block/refs [{:db/id 4}],
:block/format :markdown,
:block/content
"TODO Test Mini\n:LOGBOOK:\nCLOCK: [2023-10-22 Sun 11:05:24]--[2023-10-22 Sun 11:05:27] => 00:00:03\n:END:",
:db/id 101,
:block/path-refs [{:db/id 4} {:db/id 87} {:db/id 89}],
:block/parent {:db/id 91},
:block/page {:db/id 89},
:block/marker "TODO"}
Page Info
Journal Page of Task Blocks
{:block/uuid #uuid "6534b7f3-dcc7-4bb6-b35f-12edf8e08511",
:block/journal? true,
:block/updated-at 1697954560845,
:block/created-at 1697953779441,
:block/journal-day 20231020,
:db/id 89,
:block/name "oct 20th, 2023",
:block/file {:db/id 85},
:block/original-name "Oct 20th, 2023"}
Minimalism Page
{:block/uuid #uuid "6534ba3b-4465-4cfd-a071-96c278cbd0bd",
:block/journal? false,
:block/updated-at 1697954284013,
:block/created-at 1697953783983,
:block/format :markdown,
:db/id 87,
:block/name "minimalism",
:block/file {:db/id 14500},
:block/original-name "Minimalism"}
TODO Page
{:db/id 4,
:block/journal? false,
:block/name "todo",
:block/original-name "TODO",
:block/uuid #uuid "6534ba3b-1b7b-4cba-87a2-d8725858abd8"}
Curate Page
{:block/properties-text-values {:exclude-from-graph-view "true"},
:block/uuid #uuid "6534b80a-08ed-4922-b79e-51f22a76f05b",
:block/properties {:exclude-from-graph-view true},
:block/journal? false,
:block/updated-at 1697953783739,
:block/created-at 1697953783739,
:db/id 88,
:block/name "curate",
:block/file {:db/id 13330},
:block/original-name "curate"}