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

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


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

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

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.

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

2 Likes

great! thx.