Query for Tasks done today

[sir79]

Has anyone an idea for a query which shows me the tasks I finished on a specific day?
I would like to add this query to the journal queries to see what I achieved each day.

[Alex_QWxleA]

As of today, that is not yet possible. The database does not save a timestamp of the moment a task was finished. If you have logbook enabled, there will be org-mode style logs, but they are not (yet) indexed, so can not be queried.

In theory it is possible to write a regex parser and combine that with an advanced query to look for finished tasks, but so far nobody has taken that upon themselves.

So for now, you can only query for DONE tasks, not when that task was done

[sir79]

Thank you for your repsonse.
That would probably also answer the next question, if it is possible to list in the journal the task I was working on that day, by querying the logbook timestamps. But as they are not yet indexed, that’s not possible.

[Alex_QWxleA]

What is possible to query, is the journal-day the task is in, so if the task is located in the correct day, then that information can be queried.

But, if a task is located in yesterdays journal, and you worked on, or finished it today, that cannot be queried (despite being in the logbook).

[John_Doe]

Is it possible now?
Would be great to have it.

[John_Doe]

Please upvote

Add a done date to done tasks that is query-able

As not all tasks are finished on time it would be valuable to have the done date added to the DB schema of logseq. One could activate the timetracking feature of logseq to get the latest date tracked (See a query @darwis made here. But that is not something I really need. But I would like to know when a task is done. I am not entirely sure how the DB schema works exactly but I see that there is a :block/marker "DONE"} entry in the block data. If also a :block/marker/done “DATE”} part could b…

[dyo]

@John_Doe @sir79 If you’re still looking for a solution to this, try the PlugIn ‘Task Completion’ by Dmitri Dushkin. When checking a TODO as DONE it adds a completed property to the task with todays date. Completed tasks can then be searched by date - PlugIn includes a ‘completed tasks in previous week’ query that can be simply modified to suit your individual criteria.

Hope that helps as workaround until this is standard Logseq functionality.

[hughg]

I’d like to use the “Task Completion” plugin output with an Advanced Query, but can’t get it to work. If I comment out the (or ...), the following query returns all “DONE” tasks which have a :completed property; but if I put it in, it returns nothing.

{:title [:h3 "Done today"]
 :query [:find (pull ?b [*])
   :in $ ?today
   :where
     [?b :block/marker "DONE"]
     [?b :block/properties ?properties]
     [(get ?properties :completed) ?completed]
     (or
       [(= ?completed ?today)]
       [(contains? ?completed ?today)]
     )
 ]
 :result-transform (fn [result] (sort-by 
     (fn [r] (get-in r [:block/properties :completed])
  ) result))  ; Sort by completion timestamp
 :inputs [:today]
 :table-view? false
 :group-by-page? false
 :breadcrumb-show? false
 :collapsed? false
}

[YU000jp]

If use task DONE with journals only

{
:title [:h3 "Today completed DONE task"]
:query (and (between today tomorrow) (task DONE) (property completed) )
	table-view? false
	:group-by-page? false
 	:breadcrumb-show? false
 	:collapsed? false
}

[hughg]

Thanks for the idea, @YU000jp, but I’d like to be able to put tasks anywhere. I’m sure there must be a way

[alexadler]

Not directly what you were asking but maybe my query might help:

#+BEGIN_QUERY
{:title [:h2 "DONE"]
 :query [:find (pull ?h [*])
  :in $ ?page
  :where
   [?j :block/name ?page]
   [?j :block/journal-day ?day]
   [?h :block/marker ?marker]
   [(contains? #{"DONE"} ?marker)]
     [?h :block/refs ?j]
 ]
 :inputs [:query-page]
:table-view? false;
 :breadcrumb-show? false ;
 :collapsed? false;
 :result-transform (fn [result] (sort-by (fn [r] (get-in r [:block/scheduled])) result)) ; sort the result by the scheduled date
}
#+END_QUERY