Dataview FROM expecting variable when putting folder location

Help
1

What I’m trying to do

I’m following along Paul Dicksons “LifeOS” series and am running into a problem.

TABLE without ID
file.link as "Daily Note",
DailyMorningMood as "Morning Mood",
DailyEveningMood as "Evening Mood",
DailyLearning as "Learning",
DailyFocus as "Focus",
FROM "7 - Journal/Daily Journals" 
WHERE Month != null AND
	(contains(Month, this.thisMonth))
SORT file.name ASC
LIMIT 100

This is the table with the only change being the name of my folder, but I run into this parsing error:

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

5 | DailyLearning as “Learning”,
6 | DailyFocus as “Focus”,
7 | FROM “7 - Journal/Daily Journals”
| ________^
8 | WHERE Month != null AND
9 | (contains(Month, this.thisMonth))

Expected:

variable

Things I have tried

Ive tried replacing the folder name with the tag thats applied to every daily note, but I have no idea what I’m supposed to do other than that, and I havent found a solution after a bit of searching.

2

You’ve got a syntax error with an extra , on the end of the line before the FROM statement which shouldn’t be there.

3

I’m gonna cry
scripting is a test of sanity
thank you for your help

1 Like