hope you can help me, I am struggling a bit here as a beginner.
Here is the scenario
- Peoples Note with Name Pattern → Firstname Lastname
- Section showing all open tasks with specific tag for that person
- Tag looks like this → #todo/action/FirstName
Now how do I integrate string manipulation functions into my query so I get a tag without space?
Logically i know i can use replace function but I cannot get it to work as the function seems not to be executed!? What am I missing?
TASK from "meetings" WHERE contains(tags, "#todo/action/<% tp.file.title%>") AND !completed GROUP BY file.link SORT rows.file.ctime DESC LIMIT 20
- WHERE contains(tags, replace(“<% tp.file.title%>”, " ", “”))
- Results in
WHERE contains(tags, replace(“ANd Wo”, " ", “”))