Query to show (not done) tasks only if it is in todays daily note?

[Deadcows]

I've got a query containing this:

path includes Tasks.md
(not done) OR (done 2023-04-07)
(no scheduled date) OR (scheduled before 2023-04-08)

Dates here inserted by Templater (done today, scheduled before tomorrow).
So I want to see all the tasks in the daily note, but when I review my previous days it is very distracting to see the tasks there, so usually I tend to remove the query by hand.. which is lame, and also would be nice to keep showing the tasks I checked this day.

Maybe there is a way to make a bit more complex query? Or there is a way to conditionally use two different queries in the Obsidian?

[claremacrae]

Hi, what is the filename pattern for your daily notes?
For example, what is the name of your daily note for today?

Asking as a search would need this, in order to know if it was the correct file to show tasks on.

[Deadcows]

It is simply the date, like the note for today called "2023-04-07".
Currently I'm digging in the DataviewJS to insert different queries conditionally. Simply removing "(not done) OR" doing the trick.
But maybe Tasks plugin allows that somehow

[Deadcows]

That was quite a trip :) With a help of the google-fo I was able to write the following code, and it is seemingly do what I needed

var today = dv.date('today');
var noteDay = dv.current().file.day;
var noteToday = noteDay.toISODate();
var noteTomorrow = noteDay.plus({ days: 1 }).toISODate();

var freshNote = today.startOf("day") <= noteDay.startOf("day");

var query = `path includes Tasks.md\n`;
if (freshNote) query += `(not done) OR `;
query += 
`(done `+noteToday+`)
(no scheduled date) OR (scheduled before ` +noteTomorrow+ `)

sort by priority
sort by due
sort by done reverse
hide backlink
hide task count
`;

dv.paragraph('```tasks\n' + query + '\n```');

[Deadcows]

I noted some performance drop on the startup and my tasks are not loaded right away (2-3 seconds hiccup).
Surely it is not a top priority, but I'll be happy to see any suggestions on a better approach :)

[claremacrae]

Glad you got it working.

If you want to check your filters, add an explain line to your query block, and inspect several different daily notes.

Re performance, check your dataview refresh interval. Mine is:

It more affects responsiveness when editing, but is worth checking it.

But anyway, re startup behaviour, I see the same thing. dataview seems to not show its results until it has finished updating its cache of data from all the notes.

So I'm used to waiting 2 or 3 seconds when I start Obsidian until I see dataview results.

[Deadcows]

Ooh, so it's not the performance issue with my code. Got it, thank you!