Table-Query listing files of arbitrary type and their containing folders

[Gewerd-Strauss]

Hello,

I have long ago dug out the following list query somewhere. I think it was even on this repo, but I am not sure.

```dataviewjs
// get files via Obsidian api - filter pdf extension and path with the string "Preparation"
const files = app.vault.getFiles().filter(file => ((file.extension == 'docx' || file.extension == 'pdf') && file.path.includes("07 Thesis")));

// creating a list with links
dv.list(files.map(f => dv.fileLink(f.path)))
dv.sort
```

This query will make a list of all docx- and pdf-files which contain a specific path, and list their names only. The last part is important as I sometimes split my attachments depending on the project, and only want to list what is relevant for the note I am querying from.

Example File: root/200 University/07 Thesis/BE31 Thesis/Misc/Project Scope.pdf
I now would like to translate this to a table-query; which should be able to list a couple of things:

1. Filename - this is what the list-query does already
2. Parent Directory.
3. Parent Directory's Parent Directory
4. Last Edited Date

Clarification regarding 2. and 3.:
A lot of queries will list files which are in different folders with the same name - e.g. I have a lot of projects, but they all contain a Misc-folder; so listing the folder above that is often necessary to distinguish things.

Clarification regarding 4.: preferably in yyyy-MM-dd HH:mm format, but unformatted iso would be fine as well.
Table should be sortable by file.mtime

Is there a way to do this?

Thank you.
Sincerely,
~Gw