Move id table to the right on dataview table

Hi! I am quite confused on this simple problem recently

What I’m trying to do

i have this table dataview of uncreated notes that queries all linked text but not yet created,

Notes You Haven’t Created

TABLE out AS "Uncreated files"
FLATTEN file.outlinks as out
WHERE !(out.file) AND !contains(meta(out).path, ".")
WHERE !contains(file.folder, "Fleetings") AND !contains(file.folder, "Templates") AND  !contains(file.folder, "Periodics") AND !contains(file.folder, "Dailies")
SORT file.mtime DESC

But this had me sometimes to misclick and clicked the already created notes (on the id table). what I want to modify is to modify the id table place so that it is on the right of the “uncreated files” column.

I found the solution, that is to add without id first then queries the original file using file.link, the implementation are this:

TABLE without id out AS "Uncreated files", file.link AS "Source file"
FLATTEN file.outlinks as out
WHERE !(out.file) AND !contains(meta(out).path, ".")
WHERE !contains(file.folder, "Fleetings") AND !contains(file.folder, "Templates") AND  !contains(file.folder, "Periodics") AND !contains(file.folder, "Dailies")
SORT file.mtime DESC

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