Hello Logseq community!
I would really appreciate if someone would help me to understand, how I can sort my namespaced pages and sort to show only the one that status property changed from DOING to DONE for the last couple of days.
So far I have only manage to create query that showing me the tickets that starts with “Ticket/” and status is “DOING”
{
:title [:h3 "Tickets currently working on"]
:query [
:find (pull ?b [*])
:in $ ?s
:where
[property ?b :status "DOING"]
[?b :block/page ?p]
[?p :block/original-name ?n]
[(clojure.string/starts-with? ?n ?s)]]
:inputs [ "Ticket/" ]
}
Thanks