I have the following task
- [%] [subject::Sub 1] [module::1] [lectureNumber::1] [startTime::00:00] [endTime::02:00] #study/lecture #study/concept #study/time-log
I am using following query to view the tasks as table
~~~dataview
table without id
date("1970-01-01T" + task.endTime + ":00") - date("1970-01-01T" + task.startTime + ":00") as "Duration",
task.subject as "Subject",
task.module as "Module",
task.lectureNumber as "Lecture",
task.startTime as "Start",
task.endTime as "End"
from "Main/Journal/daily"
FLATTEN file.tasks AS Tasks
~~~
It can find the tasks but the data is not displayed in table. See the output screenshot, specifically Duration (2) part.