Did you try any of the tips in the other thread? It does seem to be the same case of a single value turning into a list, which throws off your search cases.
In your case it does seem like you want to keep both films in list, so I would suggest to use FLATTEN
transform those two values for Assistido
which are present in one row for Avatar
, into two rows of Avatar
with one value each for Assistido
.
To fully get this please execute the following query:
```dataview
TABLE
Ano,
Assistido
FROM
"04 - Filmes/02 - Filmes"
WHERE
file.name = "Avatar"
```
and
```dataview
TABLE
Ano,
A
FROM
"04 - Filmes/02 - Filmes"
FLATTEN
Assistido as A
WHERE
file.name = "Avatar"
```
One of them contains the key to what you need to change your full query to, as well.
Hope this helps, and you understand a little bit on how FLATTEN
works. You are free to change A
to whatever you like. I chose A
since I don’t know any good alternatives to Assistido
.
Bonus tip 1: Try changing the Assistido
in the first query to min(Assistido)
and/or max(Assistido)
and see the effect of it.
Bonus tip 2: If you add another set of backticks around dataview-queries (or other code blocks) with ````
on the lines before and after, it’ll show as a proper code block in the forum question.