I try that also but the list is empty. And is based on “today”. I like based on Journalpage Date.
I just take the code from above and change [(contains? #{"DONE"} ?m)]
#+BEGIN_QUERY
{
:inputs [:query-page] ; lower-case name of the page the query is on
:query [:find (pull ?b [*])
:in $ ?page
:where
[?p :block/name ?page] ; this is always lower-case
[?p :block/journal-day ?day]
[?b :block/scheduled ?day]
[?b :block/marker ?m]
[(contains? #{"DONE"} ?m)] ; can use whatever state you want here, just an example
]
:breadcrumb-show? false
:group-by-page? false
}
#+END_QUERY
Now I get a list of all done Task with scheduled date from Journalpage date. But If I have a Task completed/done today with scheduled date yesterday then its not on
the list
Sorry, but I still don’t understand what you want to do.
- One time you write “How can I change that to see all completed/done task from today?”
- The other time you write “If I have a Task completed/done today with scheduled date yesterday then its not on the list”
- What is “done task from today” and “done today with scheduled date yesterday”?
- If you want to query the done date, it is not queryable.
- Should manually add a reference to that date.
Hi mentaloid
Sorry for the confusion
I’ll try to describe more clearly what I need.
- For the journal I have a template with the above query
- My tasks are distributed on different pages
- These tasks are displayed to me with the query, filtered to the day of the journal sheet, as “Tasks of the day”
- If such a task is completed, it is removed from the list, i.e. I cannot see what I have done today. Especially those tasks that are on other pages.
- I would like to have a query where the completed tasks are listed. And filtered by the date of the journal sheet (e.g. on the journal sheet from 16.5.2025 I see all completed tasks with completion date 16.5.2025. No matter when this task was planned. Only the completed date counts )
Do you have an Idea?
Thank you very much
Regards
Floonder
Thank you for the Info
Could this be an improvement?