I am having issues querying my vault with the following Dataview query (shows as no results).
For some context: I’m creating a greater list of both wishlist and owned items and want to organize them into the particular room they belong in my house.
Using the following Dataview query, I would expect to show the “Desk Top” file (as room = “My Office”), but it’s showing empty.
TABLE room as "Room", organizetags as "Topic", use as "Use", price as "Price", value as "Value" FROM #ownedItems AND "02. Resources"
WHERE room = "My Office"
This is the note I have refencing said desk top, which I bought from Ikea (a countertop):
I did get this query to pull the desk in, but only with other Ikea products (not quite the intent):
TABLE room as "Room", organizetags as "Topic", use as "Use", price as "Price", value as "Value" FROM #ownedItems AND "02. Resources"
WHERE room = "My Office" OR brand = "Ikea"
I’ve messed with a bunch of other stuff, but the issue seems to exist for other queries in my vault as well. My initial thought is the YAML type (list vs text).
Is there a workaround? I don’t want to go around and manually change the types of all the tags in my vault…
Currently, I’m in: v1.4.1 (through insider builds)