Dear @mnvwvnm,
Thanks you for your solution. I understand the problem now.
I read a lot of feedback you did and lot of your solution inspieded me.
Based on one of your post, I try to put my report on a table :
Your post : Create dataview table of multiple tasks within notes - #2 by mnvwvnm
I Adapted my report like this :
- [X] Do the point 1 [by::[[Boby Jean]]]
- [ ] Do the point 2 [by::[[James Paul]]]
And my report like this :
TABLE WITHOUT ID regexreplace(Tasks.text, "\[.*$", "") AS Task, choice(Tasks.completed, "🟢", "🔴") AS Status, regexreplace(Tasks.subtasks.text, "\[.*$", "") AS Subtasks, choice(Tasks.subtasks.completed, "🟢", "🔴") AS "Subtasks status", Tasks.by AS "By", file.link AS "File"
FROM "Journal" WHERE contains(file.tasks.by, [[Boby Jean]]) FLATTEN file.tasks AS Tasks
But the request give me Boby AND James.
If you could give me a “last help”.