Base: all unique values of lists

[jionnyMagiah]

I have two notes with a list property. How could I get all unique values of that property?

For example:

Note 1

---
list:
  - foo
  - bar
---

My note 1

Note 2

---
list:
  - foo
  - qwe
---

My note 2

I would like to define a base in which the output is a list like this

- foo
- bar
- qwe

Is this possible with bases?

[CawlinTeffid]

I believe that is possible. But someone who knows Bases better than I do would have to explain how (or you can try poring over the Help docs).

[jionnyMagiah]

I did something similar using Dataview with JS query, but I’ve already moved everything to bases, I don’t want to reinstall Dataview.

I’m afraid this can’t be done with bases. To my understanding, each rows in a base is related to a file. I would need to ‘split’ a row (hence a file) into multiple rows

[jionnyMagiah]

I tried writing a custom base view, I managed to get something working

Each list item is a link that allows to search the notes that have that value in the properties

I’ve opened a ‘Plugin Idea’ topic, see more Base View: unique list item