Kanban Plugin and Dataview

I’m almost a zero in regex… but yes, it removes everything after the first “[”. This simple fact implies that in this case

[ ] Utility Application #project/Alta [due:: [[ 2022-04-28]]] [Project:: [[Alta Apartments]]]

if you don’t want to see #project/Alta, then you need to send the tag to a place after the first inline field.

About the other questions:

You want to see the status (i.e. the header title) in the table? yes, it’s possible… because you’re targeting tasks and dataview collects the tasks section/headers as metadata.

First, you need to learn how to filter a completed tasks. This means know dataview metadata structure. Do you read the plugin documentation?
I don’t understand what you mean by “set a duration within 3 days”. Means “tasks with due date for the next 3 days”?

You arrive at this point and ask: “yes, but the solution”?
And my answer is: what’s you intention to learn Dataview? Or you want only the solution for your request?

To understand better the metadata structure go to a note with three or four tasks and run this inline query (you need to enable js inline queries in settings > dataview):

`$=dv.span(dv.current())`

There, you’ll see that under the tasks level you have an implicit field called completed, a field you can target in query with file.tasks.completed. This means that if you want to target only not completed tasks, maybe you need to use, after the flatten, something like WHERE !Tasks.completed (“!” means negation).

Explaining the section/header thing is more complicated. You’'l need to use the meta() function > https://blacksmithgu.github.io/obsidian-dataview/query/functions/#metalinksubpath

```dataview
TABLE WITHOUT ID
	regexreplace(Tasks.text, "\[.*$", "") as Task,
	Tasks.due As "Due Date",
	Tasks.Project as "Project",
	meta(Tasks.section).subpath as "Status",
	file.link as "File"
FROM #project
WHERE file.tasks
FLATTEN file.tasks As Tasks
WHERE !Tasks.completed
```
1 Like