Add option to order content by latest updated

[emilymclean]

Requirements

• [X] Is this a feature request? For questions or discussions use https://lemmy.ml/c/lemmy_support
• [X] Did you check to see if this issue already exists?
• [X] Is this only a feature request? Do not put multiple feature requests in one issue.
• [X] Is this a backend issue? Use the lemmy-ui repo for UI / frontend issues.

Is your proposal related to a problem?

I am working on a moderation bot. Allowing content to be sorted by most recently updated would make it easier to moderate modified content and automatically resolve reports once an issue has been resolved.

Describe the solution you'd like.

Add a sort type of "RecentlyUpdated" to the API that sorts results by most recently changed or created.

Describe alternatives you've considered.

The only other alternative would be to scan through an entire community periodically to find any changed content, which is not feasible for large communities.

Additional context

No response

[Nutomic]

By recently updated do you mean posts that were recently edited? Or something like the existing "New comments" sort?

[dessalines]

We already have auto-resolving reports in the back-end.

Also PostAggregates::newest_comment_time already exists.

This is also not a good way to handle this, you'll likely just be spamming the API, when the moderation queue already exists.

[emilymclean]

This is about content updates to comments or posts, for the purposes of passing changes through moderation rules. It would prevent people from modifying their posts to add rule-breaking content after it has already been scanned by a moderation bot.

This is an important part of automated moderation and allowing the development of effective moderation tools.