New to dataview. I want to make a table of all files in a folder

[antonvons]

I have my data structured in folders (even though I use tags). I want to make a table of all records in a folder. Sounds simple enough.

It works if I want a table using tags,

This works:

TABLE FROM #airports
SORT title ASC

However for the life of me are several hours I can not see the data from folders. I either get errors or nothing returned.
I have a folder I am trying to test with which has the following name: "......\Airports\NZ-NewZealand"

This is the closest I have been able to get:

No error, but gives no results:

TABLE 
	file.folder 
FROM "NZ-NewZealand"
SORT title ASC

I also tried:

TABLE 
	title AS "Title" 
FROM "NZ-NewZealand"
SORT title ASC

If I leave out the FROM "NZ-NewZealand" line, I get all 3200 notes listed.
I have tried running the dataview note from the same folder I want to see, this made no difference. I'm now wondering if a dataview can only return results from root folders and not nested folders. I'm going to create folder called "games" in the root and see if that works.

I'm sure the solution will be simple, really love a bit of help here please.

[antonvons]

I'm devastated. I just tried this after making a "games" folder in my obsidian root folder.

Created two test notes in this folder and run the dataview.

TABLE 
	title AS "Title" 
FROM "games"
SORT title ASC

And low and behold here is the result.

So now I have to work out how to see sub-folders, if it is possible. I did try using file.path but this did not work.

I have then tried an explicit path entry like: "T:\obsidian\Airports\NZ-ZeaLand" but as before, this returns nothing.

With this code:

TABLE 
	title AS "Title" 
FROM T:\obsidian\Airports\NZ-ZeaLand"
SORT title ASC

[antonvons]

Next thought I had, maybe sub-folders have to be refferenced with a forward slash, so I tried:

TABLE
title AS "Title"
FROM obsidian/Airports/NZ-ZeaLand"
SORT title ASC

But still now data found.

[AB1908]

It should be in the docs, if you feel like it could be improved, please submit a pull request. It also works on iOS.

[antonvons]

The syntax is FROM "root level folder/subfolder/subfolder".

I just tried both the code blocks below, neither gave error but said no data found....

TABLE 
	title AS "Title" 
FROM "obisdian-avs/fsim/MSFS2020/Addons/Airports/NZ-ZeaLand"
SORT title ASC

TABLE 
	title AS "Title" 
FROM "root level folder/fsim/MSFS2020/Addons/Airports/NZ-ZeaLand"
SORT title ASC

[AB1908]

Don't use obsidian-avs.

[antonvons]

But obsidian-avs is the root level or are you saying the name of my obsidian notes should be changed.

I also tried with …..>

FROM "fsim/MSFS2020/Addons/Airports/NZ-ZeaLand"

But this did not work either.

[AB1908]

Is obsidian-avs a folder inside your vault? If so, my apologies. Can you send over a sample copy of your vault?

[antonvons]

Here is a shot of some of the notes in the sub-folder I'm trying to draw from.....

[antonvons]

However with this code using tags to find the records (three records only given the tag of airport-nz,

TABLE 
FROM #airport-nz 
SORT title ASC

I get the following result.

[antonvons]

Thanks again for your help. Here is a onedrive share to my test obsidian https://1drv.ms/u/s!AuyqYuplL3wAjpJr3E9GkY0ht7OoHg?e=AcTCbj

…

On Mon, Jun 27, 2022 at 7:03 AM AB1908 ***@***.***> wrote: Is obsidian-avs a folder inside your vault? If so, my apologies. Can you send over a sample copy of your vault? — Reply to this email directly, view it on GitHub <#1214 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AQAKMTBZZP7QSVWBIRHQL4TVRDASHANCNFSM5Z3K65OA> . You are receiving this because you authored the thread.Message ID: <blacksmithgu/obsidian-dataview/repo-discussions/1214/comments/3027463@ github.com>

[AB1908]

This was simple, you had a capital L in there.

[AB1908]

```dataview
TABLE 
	title AS "Title" 
FROM "Aviation/Airports/NZ-NewZealand"
SORT title ASC
```

[antonvons]

Well, as you say, that was simple. Didn’t even notice the case indifference. So that works after trying it in several other folders. Thank you. However, despite you saying that dataview works on iOS. When I run the same note on my iPad and change to view a dataview note, it stays in the metadata format. As per attached screenshot. Cheers Anton

…

On 1 Jul 2022, 22:22 +1000, AB1908 ***@***.***>, wrote: This was simple, you had a capital L in there. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[AB1908]

Can you try updating your Obsidian and Dataview to the latest versions?

[antonvons]

Never mind, I found AND works Cheers Anton

…

On 1 Jul 2022, 23:03 +1000, AB1908 ***@***.***>, wrote: Can you try updating your Obsidian and Dataview to the latest versions? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[antonvons]

I have a new query. The following works ```dataview TABLE FROM #airport OR #AUu SORT title asc ``` I want to use “TABLE FROM #airport AND #AUu” That does not work, is it possible to return when both cases are met? Cheers Anton

…

On 1 Jul 2022, 23:03 +1000, AB1908 ***@***.***>, wrote: Can you try updating your Obsidian and Dataview to the latest versions? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[antonvons]

Nailed it again. I did have the latest version of Obsidian for iOS. I didn’t have the dataview pluging for iOS at all. Second silly moment. Thank you for sticking with me. I am now a little more wiser about your plugin and plugins in general. Cheers Anton

…

On 1 Jul 2022, 23:03 +1000, AB1908 ***@***.***>, wrote: Can you try updating your Obsidian and Dataview to the latest versions? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>