String Manipulation in Dataview where clause not executed

Help
1

Dear Community,

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?

Current Dataview

TASK from "meetings"
WHERE contains(tags, "#todo/action/<% tp.file.title%>") AND !completed
GROUP BY file.link
SORT rows.file.ctime DESC
LIMIT 20

Things I have tried

  • WHERE contains(tags, replace(“<% tp.file.title%>”, " ", “”))
  • Results in
    WHERE contains(tags, replace(“ANd Wo”, " ", “”))
3

I somehow managed this now… :slight_smile:

```dataview
TASK from "meetings"
WHERE contains(tags, replace("<% tp.file.title%>", " ", "-"))
GROUP BY file.link
SORT rows.file.ctime DESC
LIMIT 20
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.