Filter TASK of a KANBAN note with DATAVIEW

[louis71]

Hi.

I’m trying to filter the list of TASK in My KANBAN note with the Heading “Archive” with the following code:

TABLE WITHOUT ID 
regexreplace(Tasks.text, "@\[.*$", "") as Task,
meta(Tasks.section).subpath as "Status",
file.link as "Board"
from "My Kanbans"
WHERE kanban-plugin = "basic" 
FLATTEN file.tasks As Tasks
FLATTEN list(filter(file.tasks, (x) => meta(x.section).subpath = "Archive").text) as Archive
WHERE 
contains(Tasks.text, "2024-04-19") OR   
contains(Tasks.text, "2024-04-18") OR 
contains(Tasks.text, "2024-04-17") OR 
contains(Tasks.text, "2024-04-16") OR 
contains(Tasks.text, "2024-04-15") OR 
contains(Tasks.text, "2024-04-14") OR 
contains(Tasks.text, "2024-04-20")

SORT date(Tasks.due.file.name)

But it’s not working.

Can anyone help me ?

[louis71]

I’ve solved with the following code:

TABLE WITHOUT ID 
regexreplace(Tasks.text, "@\[.*$", "") as Task,
meta(Tasks.section).subpath as "Status",
file.link as "Board"
from "My Kanbans"
WHERE kanban-plugin = "basic" 
FLATTEN file.tasks As Tasks
WHERE 
contains(Tasks.text, "2024-04-19") OR   
contains(Tasks.text, "2024-04-18") OR 
contains(Tasks.text, "2024-04-17") OR 
contains(Tasks.text, "2024-04-16") OR 
contains(Tasks.text, "2024-04-15") OR 
contains(Tasks.text, "2024-04-14") OR 
contains(Tasks.text, "2024-04-20")
WHERE contains(meta(Tasks.section).subpath,"Archive")
SORT date(Tasks.due.file.name)