[openstreetmap/openstreetmap-website] Convert note pagination to newer/older note pages (PR #4532)

[Anton Khorev]

> is there a way we can use the comment ID values, which are nice and stable, as the cursor?

Something like this?

1. don't do #4481, otherwise not all notes have a comment
2. mark the last note comment / unmark previously last comment when updating the note
3. get marked comments sorted by ids

Not sure about table joins if we want to replicate the existing behavior where user's notes are all notes acted upon by the user. We get a comment then join it with a note, then join it again with comments to see if one of them is the user's.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/4532#issuecomment-1992697807
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/4532/c1992697807 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20240312/c9a13732/attachment.htm>