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):
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 > Functions - 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"
FLATTEN file.tasks As Tasks