TABLE rows.file.link as "Learnings", kind as Kind
FROM "1 - XXX/1.1 - Journal/1.1.2 - Learnings"
sort file.ctime asc
GROUP BY dateformat(file.ctime, "MMMM") AS Month
SORT rows.file.ctime ASC
Where “kind” is a brief description of the note I write inside each one of them, like:
Well, I guess you have the snippet but don’t understand it.
Sorry to say this so directly, but what’s the reason to use the prefix rows.? Because you use the group command.
If after this command you added the prefix to SORT rows.file.ctime ASC and rows.file.link as "Learnings", maybe you also need to use it in rows.kind as Kind.
Thank’s, you are right… I just tried to take some pieces here ad there without understand much of it. So, what’s the difference between rows.property and property? And why sometimes if I don’t put “rows” it does not works at all?
That’s why we add the prefix rows. in almost all the field (“almost”, because if you target the key you usually don’t need to add any prefix).
I.e., generically, after the group command you need to add the prefix rows. to target the previous fields.