A Bases equivelnt to FLATTEN in DV

I would love to be able to query at the bullet point scope. Specifically I would love to get a list of bullets from all notes or a filtered list of notes that contain a link to the current note
Basically I want to have something equivalent to FLATTEN in Dataview:

 FLATTEN file.lists AS L
 WHERE contains(L.outlinks, [[]])
6 Likes

Yes! Badly need FLATTEN like in DataView to explode list values into multiple rows.

Example in DataView:
TABLE file.name, value
FLATTEN tags AS value

To improve over DataView: keep the “exploded” records editable from the Bases view!

3 Likes