Struggling to use dataview on single note

[rareese]

I’m trying to generate a dataview from a single note. I have an existing 1500 line markdown file from before I used obsidian that looks approximately like below.

My test data looks like this:

## (name:: Pet Cemetery) 
- Rating:: 3/5
- Summary:: Text
	- Ideally subsequent bullet points would show, but 
	- I can live without

## (name:: Dune Part 1) 
- Rating:: 5/5
- Summary:: Summary 2

## (name:: Dune Part 2)
- Rating:: 4.5/5
- Summary:: Summary 3

Originally I had the data as a series of buttled lists, but I understand the lists need to be separated by headings when dealing with a single file.

I can’t for the life of me get a workable query.

Absolutely banging my head against the wall on this

[rareese]

A query like this:

TABLE WITHOUT ID name AS name, rating AS rating, summary AS summary 
FROM "" 
where file.name = this.file.name

Generates

Adding a flatten:

TABLE WITHOUT ID L.name AS name, L.rating AS rating, L.summary AS summary 
FROM "" 
FLATTEN file.lists AS L
where file.name = this.file.name

Complete disaster

[rareese]

Re-reading this I realise that the issue is with my lack of understanding of minimal cards. Without the cssclasses cards the table shows correctly

Though its a shame the sub bullet points aren’t collected into the summary.

When I add the cards css style the cards display as a single card:

[rareese]

So I have a hypothesis:

TABLE name AS name, rating AS rating, summary AS summary FROM "" where file.name = this.file.name

Removing the WITHOUT ID the table renders thus:

My suspicion is the cards style is treating the items as a single card because there is only one File(1)

[rareese]

So here are two dataviews:

and with cards css

It feels like the only difference is the number in brackets on the first column.