List-Query in note's folder dynamically

[Gewerd-Strauss]

Hello,

assume I have the following query:

``` dataview
table 
  dateformat(file.ctime,"dd.MM.yyyy HH:mm") AS "Created",  state AS "Status",location as "Location",referred_by AS "Referee",note AS NOTE,progress AS PROGRESS
FROM #Internship and "200 University/08 Internships and Universities/01 Internships"
WHERE state!="discarded"
Sort location Asc, file.name Asc, Referee Desc, state Desc 
```

I am trying to make the query relative to the note's folder. Essentially I want to query
FROM #Internship and this.file.folder "/08 Internships and Universities"; so that I can move the note or rename the folder without having to painfully rewrite several dozen DV-Queries all over my vault.

But... that doesn't seem to work, and I can't figure out if I can even do so, or how to do so if I could do it.

Any help is appreciated.
Thank you.
Sincerely,
~Gw

[AB1908]

FROM doesn't use variables that way. At best, you'll be able to use a where file.folder = this.file.folder.

[Gewerd-Strauss]

That works for my usecase.
Thank you.

[AB1908]

Can you check if this has been covered in the docs? It needs to go in the FAQ. If it isn't there, can you open an issue and assign it to me?

[Gewerd-Strauss]

I can do so over the next weekend probably, but I won't get to it till then. I've made a note and will hopefully remember, but I cannot give any guarantees - I am a rather chaotic individual :P
Until the weekend, no chance, I'm completely booked for work reasons.
Also I am currently unaware what you mean by FAQ, so I kinda can't check anyways right now.

[AB1908]

All good, just trying to see where users run into trouble and make appropriate changes to docs. I'll check it out soon.