Is it possible in advanced query to sum the clock for tasks?

Questions & Help Queries
1

Hi community,

I’m using TODO to list my daily works with time tracking. I want to have a single row to show ‘how much time it takes’. I try my best to explore the source code, seems no way to extract this with query script (Im new on clojure…).

e.g.

#+BEGIN_QUERY
{
 :title "time cost"
 :query [
         :find (sum ?spent-min)
         :in $ ?current-page
         :where
         [?p :page/name ?current-page]
         [?b :block/page ?p]
         [?b :block/marker ?marker]
         [(contains? #{"DONE"} ?marker)]
         [?b :block/properties ?prop]
         ;; !! no this properties
         [(get ?prop "clock-time") ?spent-min]
 ]
 :inputs [:current-page]
}
#+END_QUERY

image
image1152×382 14.7 KB

I want to know is that possible? or other solutions?