Table of first inlink per file sorted by inlink name

What I’m trying to do

I’m trying to get a table with an overview of specific files (tag) and their links in other files.

Things I have tried

Here is my dataview query so far:

TABLE
WITHOUT ID
file.name AS "Activity",
split(
	 join(
		reverse(
			filter(file.inlinks, (i) => i.file.name != file.name)
		)
	 ),
",", 1) AS "Inlinks"
FROM #tag AND !"Templates"
SORT Inlinks.file.link DESC

Here are the test files which I used:
File “Some Activity”

tags:: #tag
[[Some Activity]]
Some dummy content...

File “Another activity”

tags:: #tag 
[[Another activity]]
Some dummy content...

File “My activtiy”

tags:: #tag 
[[My activity]]
Some dummy content...

Testfile “Testfile 108 with links”:

[[Some Activity]]
[[My activity]]
[[Another activity]]

Testfile “Testfile 109 with links”

[[Another activity]]
[[My activity]]`

Testfile with the overview shows the following result:

The problem is, that the file “My activity” is linked in file “Testfile 109 with links”,
but the overviews shows the file “Testfile 108 with links” as the “last” one.
So I’m trying to sort the links descending so that “…109” should be displayed instead of “…108”

Many thanks for all suggestions!
monthaton

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.