Filtered list not showing metadata with two dates

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. :smiley:

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.