Retrieve latest posts by ID

[Falco]

@hkremer

Rafael has the right base, but I don’t think you can order by created date (I hope I’m wrong?).

The default ordering is the created date AFAIK.

@hkremer

And if you could, I don’t believe IDs are assigned to posts based on when they are created.

They are.

@hkremer

Anecdotally in our Discourse instance, we are seeing many examples of IDs being assigned to posts outside of their chronological order.

The gaps in the order are posts your user can’t see, most likely posts inside PMs.

@hkremer

This becomes an issue when you try to pull all posts using the method discussed here. If we can’t order posts by ID then it becomes impossible.

If your goal is to extract ALL the posts, loading a full backup in a local PostgreSQL instance or even using our Data Explorer Plugin may be easier.