Question about Advanced Query to filter specific, date-related sprints

Questions & Help Queries
,
1

Hi there,

for a Project (actually my MA-Thesis) I scheduled a lot of tasks for my Thesis, which I now want to query and sample them on one page, where I have the overview about all tasks. Thats Why I want to Query Tasks scheduled between specific dates e.g. 3.4.2024 - 3.16.2024.

My try so far was the following:

{ 
 :title [:h2 "Sprint 1:"]
:query 
[
:find (pull ?b [*])
:in $ ?start-of-week ?end-of-week
:where
[?b :block/marker ?marker]
[(contains? #{"TODO" "DOING"} ?marker)]
[?b :block/scheduled ?scheduled-date]
[(>= ?scheduled-date ?start-of-week)]
[(<= ?scheduled-date ?end-of-week)]
 :inputs {
    :start-of-week #t "2024-03-04T00:00:00Z"
    :end-of-week   #t "2024-03-16T23:00:00Z"
  }
]}
#+END_QUERY

but It seems, that Logseq needs another Inputformat or anything like that. Could you help me out?

2

Welcome. Try this:

#+BEGIN_QUERY
{ 
 :title [:h2 "Sprint 1:"]
 :query [
   :find (pull ?b [*])
   :in $ ?start-of-week ?end-of-week
   :where
     [?b :block/marker ?marker]
     [(contains? #{"TODO" "DOING"} ?marker)]
     [?b :block/scheduled ?scheduled-date]
     [(>= ?scheduled-date ?start-of-week)]
     [(<= ?scheduled-date ?end-of-week)]
 ]
 :inputs [20240304 20240316]
}
#+END_QUERY
3

Hey there thank you so much! It worked perfectly - now I have to find out how to sort them by date - but I am sure I had seen an tutorial already for that
best regards from germany!