Query for all tasks Scheduled or deadlined for today. Can anyone help with this?

[pdrq]

Hi there,

I have been looking for hours but couldn’t find how to achieve it. Anyone knows how to query for all tasks scheduled or deadlined for today?

Thanks very much!

[Siferiax]

There’s a lot of task related queries here:

Queries for task management

I’m going to gather some queries here that will be useful for task management. It won’t be done in one go and I will be adding inline comments to help you understand what is going on. I have added those to build on the queries in order. So read through them all as I have only added comments the first time a statement appeared. Hopefully this will help you be able to edit the queries for yourself. Tasks past due Tasks scheduled value is past due (based on today) #+BEGIN_QUERY {:title [:h3 "…

Though I don’t think this one specifically.

So here’s your specific one:

#+BEGIN_QUERY
{:title [:b "Today's tasks"]
 :query [:find (pull ?b [*])
  :in $ ?day
  :where
   [?b :block/marker ?m]
   [(contains? #{"TODO" "DOING"} ?m)]
   (or
     [?b :block/scheduled ?day]
     [?b :block/deadline ?day]
   )
 ]
 :inputs [:today]
}
#+END_QUERY

[4343357]

Is there a way to adapt this query to pull tasks that are scheduled for the current day by the repeater? For example, if the current day is 2023-11-23, pull the task marked SCHEDULED: <2023-11-21 Tue .+2d> as well.

[Siferiax]

The idea of the repeater is that when you mark a task as done it will move the scheduled date the desired amount of time from the original scheduled date.
So in this case from 21st of Nov to 23rd.
As the repeater in the data only exists as plain text, it is not (easily) possible to get the data and modify the date. We have no date manipulation functions as a date format isn’t implemented in advanced queries.
In other words the ?day in the query is not a date but actually a number e.g. 20231123.