Query tasks on this page Template
template-including-parent: false
template: page tasks
{{query (and (todo todo doing) (page <% current page %>))}}
List all the tasks on the current page which have TODO or DOING status. Useful to gather together tasks from a long page where they might be spread out.
Shared by Luhmann
Project page
template-including-parent: false
template: project page
icon: 📂
tags: project page
### Project Meta
#project <% current page %>
#+BEGIN_QUERY
query-table: false
{:title [:h4 "Tasks related to <% current page %>"]
:query [:find (pull ?b [*])
:in $ ?current-page
:where
[?p :block/name ?current-page]
[?b :block/marker ?marker]
[?p :block/alias ?al]
(or [?b :block/refs ?p] [?b :block/refs ?al])
(or
[(= "" ?marker)]
[(= "" ?marker)]
[(= "WAITING" ?marker)]
[(= "" ?marker)]
)
(not [?b :block/page ?p])
]
:inputs [:current-page]
:result-transform (fn [result]
(sort-by (fn [b]
(get b :block/priority "Z")) result))
:breadcrumb-show? false
:table-view? false
}
#+END_QUERY
#+BEGIN_QUERY
query-table: false
{:title [:h4 "Checklist"]
:query (and (todo todo) (page <% current page %>))
:result-transform (fn [result]
(sort-by (fn [b]
(get b :block/priority "Z")) result))
:breadcrumb-show? false
:table-view? false
}
#+END_QUERY
### Notes
This is the template I use for my project pages, as described in my project management workflow: https://luhmann-logseq.notion.site/A-new-approach-to-project-management-in-Logseq-8b36dd5eb25d4b9e9882742b5ee4368e
Shared by Luhmann