Dataview Table sort by frontmatter doesn't work

[Snens]

Hello everyone,

I’m experiencing an issue with dataview tables.
I want my table to only show me notes based of a tag and a frontmatter value.
But whenever i include the filter for my frontmatter value it won’t show any notes in the table.

My code is as follows

TABLE WITHOUT ID
	file.link AS Name,
	Pages,
	row["Author Name"] as "Author Name"

FROM #books
WHERE "Author Name" = "Name Example"
SORT file.link asc

I’ve tried doing it with a folder path instead of a tag but it doesn’t work aswell.
If i’m only using WHERE “Author Name” it shows me all Notes.
I’ve tried the contains and containsword function, but i couldn’t get that to work.

[ush]

How about WHERE row["Author Name"] = "Name Example" instead of WHERE "Author Name" = "Name Example"?

See also:

@ush

By length(rows) AS "Count", you can re-label the length(rows) column as “Count”. But the scope of this new label “Count” is limited to the first line of the query (if I understand correctly), so you can’t reuse the “Count” label in another line. This is why SORT length(rows) DESC, not SORT Count DESC.

[Snens]

Amazing. That worked.
I thought “row” was only limited to what kind of columns the table should show.

Thank you very much.

[Snens]

Hello again,

I’m now encountering a new issue. I can’t seem to find a way to filter out frontmatter in the list format. Where it looks like this:

Author:

• Author 1
• Author 2

I’ve tried the following an many more.
WHERE Author = “- Author 1”
With two Spaces " - Author 1"
row[“Author”] = " - Author 1"
even with with the value being in a new line like it is on the note.
Author =
" - Author 1"

But i can’t seem to get this to work. I would really appreciate your help because i can’t seem to find anyone else already experiencing this issue.

[ush]

Probably it’s better to open a new thread, as this topic is already resolved.

[Snens]

Ok then. that was quick haha.