Hi.
To start use this query:
```dataview
TABLE WITHOUT ID regexreplace(Tasks.text, "\[.*$", "") AS Task, choice(Tasks.completed, "completed", "incompleted") AS Status, Tasks.completion AS "Completion Date", Tasks.due AS "Due Date", Tasks.created AS "Created Date", Tasks.priority AS "Priority", regexreplace(Tasks.subtasks.text, "\[.*$", "") AS Subtasks, choice(Tasks.subtasks.completed, "completed", "incompleted") AS "Subtasks status", file.link AS "File"
FROM "your-folder"
WHERE file.tasks
FLATTEN file.tasks AS Tasks
```
BUT…
- can’t list subtasks in first column
- can’t recognize different statuses (attention: different checklist symbols implies not recognition as tasks)