Field with spaces or multi word field

[asknet]

Hi,

I have field name that consists of multiple words. When I tried to use this plugin in dataview query, it is throwing parsing error. I couldn't find any usage related to this in documentation.

Wondering if this is supported?

Thank you

[asknet]

@blacksmithgu can you pls help on this? Thanks!

[asknet]

thank you for your response.
I'm referring to field name, for example:
Film Name:: Avatar

Last I tested it is not recognizing when field name has spaces.

[filmgal]

Ah, sorry about that. I mistook "field names" for "field values".

[blacksmithgu]

Dataview doesn't recognize spaces in field names in queries, to be specific - you have two options:

• Use dataview's query-friendly name for a field. If your field is called "Film Name", you can use it in a query as film-name. In general, to get the dataview query-friendly name, make it all lower case and replace spaces with dashes ("hello there" -> "hello-there", etc).
• Use dataview's row syntax, where you can refer to an arbitrary field via row["field name"]. So, for example, row["Film Name"].

[AlexShevyakov]

Good day, sorry to bother with what seems to be an answered topic, however, why do we use syntax like row["field name"] and not column["field name"]? Are we not addressing column name, like in SQL where SELECT colName from tabName?

[AlexShevyakov]

Also I have noticed that options mentioined above work differently.
Specifically
in WHERE statement:

LIST 
FROM "" 
WHERE row["note type"] = "book impression"

but in SELECT statement:

TABLE author, title, note-type, file.tags as tags
FROM #book-impression OR #book-review 

I mean I could not use row["field name"] in SELECT statement to make it work.