Documents list not being sorted by publishedAt data

[avitorio]

Based on this discussion.

Lists are not currently being sorted by date.

[joaoalberto-dev]

@avitorio looks like this issue was fixed here. Do you mind closing it?

[avitorio]

@joaoalberto-dev ah yes, thanks for the reminder!

[h34lthbybr33]

Just want to call out, while the fix works on the client it doesn't remediate a core issue on the server. Because this field (publishedAt) is typed as a string, sorting becomes wonky when you try to filter through db.find({ ... }).

Assuming:

type BlogPost = OstDocument & { ... };

I would expect the following to work:

const posts = await db.find<({ collection: 'posts', publishedAt: { $lte: Date.now().toString() } })

Because it's a string, the filter really can't do much other than a string comparison (which inverts the logic now to use $gte vs $lte).

I came across this while trying to "future publish" (set date for future, not caring about sensitivity of the post, just that it didn't bubble up to UX "formally" until the date had passed).