I have notes with several instances of the same key but a different value.
I was hoping to have a dataview query that makes a row, repeating the file name, for every instance of the key.
I want to order both filename and key.
Hi.
One thing is “what we want”, other thing is “what is possible” or “what we can achieve with the created structure of metadata”.
Considering your custom metadata:
So, the only groups you have are by fields (an array/list of values in each field).
There are no “pseudo-groups” Time-Scene-Summary, this means, for example, there’s no direct relation between Time:: 14:00, Scene:: DT-01.01.01 and Summary:: Summary 1… only the order/position.
We can try something with that, but isn’t a simple one.
To do that you need to add a header to each group. For example:
TABLE WITHOUT ID rows.file.link[0] AS File, rows.L.Time[0] as Time, rows.L.Scene[1] as Scene, rows.L.Summary[2] as Summary
FROM "your-folder-path"
WHERE file.lists
FLATTEN file.lists AS L
WHERE contains(meta(L.section).subpath, "part")
GROUP BY file.name + meta(L.section).subpath
SORT rows.file.name ASC
Thank you so much… that was exactly what I was aiming for.
As a new user I’m so impressed with the versatility of Obsidian, Dataview and other plugins. I’m also impressed with how quickly you came up with a solution.
And now I’m going to find out what each element of this query exactly does and why/how it works.