ERROR - TABLE WITHOUT ID link(file.link, Name) AS “Name”

[romebot]

Things I have tried

variations on the code, YAML

What I’m trying to do

using dataview, replace the file name w/ the Title in the Metadata

I have this working in other places, so pulling my hair out as to what’s wrong in this case.

This code is working great:

TABLE Author, Year, Type, Genre, POV, Length, Pub, Summary, Note, Status
Where Type="Novel"
SORT Title DESC

But instead of the file name, I want to use the Title field in my YAML, eg.

TABLE WITHOUT ID link(file.link, Title) AS “Title”, Author, Year, Type, Genre, POV, Length, Pub, Summary, Note, Status
Where Type="Novel"
SORT Title DESC

What I get is the following error:

Dataview: Error:
– PARSING FAILED --------------------------------------------------

1 | TABLE WITHOUT ID link(file.link, Title) AS “Title”, Author, Year, Type, Genre, POV, Length, Pub, Summary, Note, Status
| ^
2 | Where Type=“Novel”
3 | SORT Title DESC

Expected one of the following:

string, variable identifier

---

[joethei]

Removing the quotes from:
as "Title" to as Title
fixed this in my testing.

[Craig]

It looks to me like you’re using custom quote marks around “Title” in link(...) AS “Title”. I replaced them with straight quotes and the query parsed fine for me:

TABLE WITHOUT ID link(file.link, Title) AS "Title", Author, Year, Type, Genre, POV, Length, Pub, Summary, Note, Status Where Type="Novel" SORT Title DESC

[romebot]

@Craig

TABLE WITHOUT ID link(file.link, Title) AS "Title"

yes! that worked… why might I have those other quotes and is there a way to make obsidian always convert them? could be I copy pasted the text from somewhere.

[joethei]

Do you happen to have the Smart Typography plugin installed?
That converts "" to “” by default, you can disable this in the plugins settings.

[romebot]

great! thx.