I have 2 working queries that retrieve overdue tasks, one from the journal pages and one for scheduled task
{:title [:h2 "🧨 OVERDUE"]
:query [:find (pull ?b [*])
:in $ ?start ?end
:where
(task ?b #{"TODO" "DOING"})
(between ?b ?start ?end)]
:inputs [:365d :today]
:breadcrumb-show? true}
{:title [:h2 "🧨 OVERDUE"]
:query [:find (pull ?b [*])
:in $ ?start ?end
:where
(task ?b #{"TODO" "DOING"})
(or [?b :block/scheduled ?date]
[?b :block/deadline ?date])
[(> ?end ?date)]]
:inputs [:365d :today]
:breadcrumb-show? true}
I wanted to combine the 2 together to get all overdue tasks but failed, please help me with this
{:title [:h2 "🧨 OVERDUE"]
:query [:find (pull ?b [*])
:in $ ?start ?end
:where
(task ?b #{"TODO" "DOING"})
(or (between ?b ?start ?end) (and (or [?b :block/scheduled ?date]
[?b :block/deadline ?date])
[(> ?end ?date)]))]
:inputs [:365d :today]
:breadcrumb-show? true}