Get all Links with substring

[mr_anh_ngoc]

What I’m trying to do

hello,
I want dataview to list all links with a certain substring.
I’ve searched the dataview documentation, but found no solution.
The links are not set in YAML-header.
lets say the links look like this:

File 1:
medium:: [[Saltwater]]
...
File 2:
medium:: [[Sweetwater]]

Things I have tried

in dataview:

TABLE
...
where contains(medium, "water")
...

there are no results found.

How do I use the right syntax or can I only seach the whole string/link?

[holroy]

Since links are its own type, the simple contains doesn’t work. A hackish solution is to do: contains(string(medium), "water")

This hack counters for single and multiple values, and forces the user of the text version of the link(s).

[mr_anh_ngoc]

aah… thank you.