Sort by name, not by whether note created

[AnthonyH]

What I’m trying to do

I am trying to create a 2 column table of published articles. Column 1 is article title, column 2 is date (YYYYMMDD). The date column format links to my daily notes, which means articles appear in the relevant daily note for when they were published.

Each article has a link to [[articles]] and [[YYYYMMDD]] in a ‘published’ frontmatter field

Here is my code:

table published
from [[articles]] 
sort published desc

This creates a list of articles by publication date. BUT: the list sorts FIRST by created notes in date order, and then by uncreated notes in date order.

I want the entire list in date order, regardless of whether or not a Daily Note exists yet for that day.

Things I have tried

tbh no idea what to try. I need some sort of ‘over-ride’ to tell dataview to ignore whether the note is created or not

[splendidemendax]

I’m trying to do the same thing: sort by dates, where the date is a link and I want to ignore whether the linked file has been created. My whole thing is a little more complicated:

TABLE WITHOUT ID 
	"[[" + file.name + "|" + regexreplace(regexreplace(file.name, "^\d+", ""), "\([^\(]*\)$", "") + "]]" as "title", 
	regexreplace(join(flat([nonnull(creator), nonnull(editor)]), "; "), "\(\W*\)", "") as "creator(s)",
	date

FROM (#source or #text) and -#note

FLATTEN dates as date

WHERE contains(meta(date).path, "2024")
WHERE typeof(whole) = "null"

SORT date ASC

I’ve tried string(date) and meta(date).path, which seem to do very little. I’ve also tried meta(date).name, date.name, and date.path which do make things worse (in that I can no longer even tell on what criteria the list is being sorted—certainly not the date).

[splendidemendax]

Got it! Sorting by date(date) worked for me.