Querytuning LIST for: custom text display, recursive folder search, nested index lists.

[errantalmond]

Hi,

follow up on this question, but with LIST instead of TABLE:

LIST rows.file.link
FROM "space/planet"
group by file.folder

The query above create a list of all files in the planet/ folder, as links, grouped by subfolder, shown as the path to the folder in unlinked plain text heading each subfolder list. There are several things I would like to do with this that I haven't managed to figure out from documentation and discussions:

1. Change the displayed text for the subfolder headings to the [[folder_name]] (linking to folder note), instead of displaying the entire filepath to the folder in plain text.

2. This query only displays one level of subfolders. Is there a way to include one (or two) more?

3. Is there a way to display all files and folders contained, instead of just .md files? I assume no, since anything that isn't a note doesn't have the kind of metadata Dataview is looking for.

4. Indent sub-level folder sublists hierarchically in the same way that the file explorer shows nested folders.

Any help is appreciated!
Wishing you all a great day.

[sergeBoisse]

Hello,
The following dataviewjs script displays a list of all files in a folder, and recursively a nested list for any subfolder. Therefore you can have the full directory listing of your Obsidian vault. Hope this helps, as it took me a whole day to come up with this code.

function listRecursive(folder, depth) {
	// All pages in the scope of the current path
	let pages = dv.pages('"' + folder + '"');
	
	// on va collecter les sous-répertoires directs
	let subfolders = [];
	pages.forEach(page => {
		let afolder = page.file.folder;
		if (afolder == folder) return;
		if (!afolder.startsWith(folder)) return;
		let relpath = afolder.substring(folder.length);
		if (relpath == "") return;
		let sub = relpath.split("/")[0];
		if (folder != "") sub = relpath.split("/")[1];
		if (sub == "") return;
		if (!subfolders.includes(sub)) {
			subfolders.push(sub);
		}
	});

	// on liste les fichiers du répertoire courant
	let currentFiles = "";
	pages.forEach(page => {
		if (page.file.folder == folder || (folder=="" && page.file.folder == "/")) {
			// Page is in current folder
			currentFiles += page.file.link + " | ";
		}
	});
	let indent = "\t".repeat(depth);
	let rep = folder.substring(folder.lastIndexOf("/")+1);
	// on commence par le nom du répertoire
	let res = indent+"- ### "+rep+"</h3>";
	if (folder == '') res = "- ### ALL NOTES</h3>";
	//res += indent+currentFiles+"\n";
	res += currentFiles+"\n";

	// on ajoute les sous répertoires
	for (let srep of subfolders) {
		if (folder == "")
			res += listRecursive(srep, depth+1);
		else
			res += listRecursive(folder+"/"+srep, depth+1);
	}
	return res;
}
// change to whatever folder you would like to list.
let files = listRecursive('_Créer/Art', 0);
//let files = listRecursive('', 0);

dv.el("p",files)

An example of the result: