Create dataview table of multiple tasks within notes

[Kabo]

@mnvwvnm

But, taken the query above, if we add the filter bellow after the FLATTEN file.tasks AS Tasks, maybe it works:
WHERE Tasks.created = date(2021-08-09)

Thanks this works! Albeit with some wonky date format, but that is in the existing table already and not that important for me…

But when I apply the same logic to [keyword:: pride]

WHERE Tasks.keyword = pride
WHERE Tasks.keyword = keyword(pride)
WHERE Tasks.keyword = "pride"

and so on…it disappears all tasks with keywords from the table, not just the keyword in question.

What is happening?