Find all scheduled blocks that are NOT a TODO item

[mari0]

Hi,

I’m looking for a query to find all blocks that are scheduled (or have a deadline) for the current date that are not a task (TODO, LATER, ect. )

What I want to achieve is to schedule information to show up at certain dates or intervals etc.

Can someone point me in the right direction here ?

Thanks a lot,
Mari0

[mentaloid]

Welcome. Since you asked for directions (instead of a direct solution):

• For a basic query, begin with Query Builder how to search for SCHEDULED or DEADLINE todos?
  • e.g. (or "SCHEDULED" "DEADLINE")
• For an advanced query, begin with Query for all tasks Scheduled or deadlined for today
  • e.g. for current day:

    :in $ ?day
    

    :where
    (or
      [?b :block/scheduled ?day]
      [?b :block/deadline ?day]
    )
    

    :inputs [:today]
    

  • For other ideas, don’t miss Queries for task management

Then use a not expression to exclude:

• basic queries: task
• advanced queries: marker

If still in troubles, ask back here (preferably with your progress).

[mari0]

Ok, I was able to get a 90% solution.

What is my starting point:

I only want to see the Blocks “Test 1” and “Test 2” in my result.

My current query is this:

{:title [:b "Relevant Today"]
 :query [:find (pull ?b [*])
  :in $ ?day
  :where
   (or
     [?b :block/scheduled ?day]
     [?b :block/deadline ?day]
   )
 ]
 :inputs [:today]
}

But this one delivers also “Test 3” as result.

I’m not getting the point how to exclude TODOS explicitly.

What am I missing ?

Thanks,
Mari0

[mentaloid]

Well done so far. You miss the last step:

Then use a not expression to exclude
advanced queries: marker

To exclude blocks that contain any marker, after the or-clause should add this line:

(not [?b :block/marker])

[mari0]

Ok, that was my mistake. I’ve always put this part before the or-clause.

So this is the final version and it works as expected:

{:title [:b "Relevant Today"]
 :query [:find (pull ?b [*])
  :in $ ?day
  :where
   (or
     [?b :block/scheduled ?day]
     [?b :block/deadline ?day]
   )
   (not [?b :block/marker])
 ]
 :inputs [:today]
}