YAML key, multiple values, dataview table with one value only

Help
4

Hi.

Sorry for my intrusion…

I’d like to say three things:

  1. In inline fields you don’t need to use quotes if multiple values are links:
locations:: [[Madrid]], [[Barcelona]], [[Granada]]

  1. For links you don’t need to use the syntax for strings (the quotation marks) in the commands. Instead of WHERE contains(locations, "Granada") use WHERE contains(locations, [[Granada]])

  2. To a rigorous query, instead of the “construction” of the column results ([[Granada]] as Location) you need to apply the filter function:

TABLE WITHOUT ID
	film as Film, year AS Year,
	filter(locations, (l) => l = [[Granada]]) as Location
FROM #peninsulafilms 
WHERE contains(locations, [[Granada]])
SORT year DESC, title ASC
7 Likes