RavenDB paging via cursor

user_670860 0
Viewed 42

Paging in RavenDB is done via skip+take. This is default implementation I'm happy with most of the time. However for frequently changing data I want paging via a cursor. The cursor/after parameter specifies which was the last record displayed and where the list should continue on the next page. This should work for data which can be dynamically sorted, so the sorting parameter is not fixed.

github is doing it this way on the "stars" page for example: https://github.com/[username]?after=Y3Vyc29&tab=stars

Any ideas how to achieve this in RavenDB?

ravendb
1 Answers

there is no cursor pagination in RavenDB. But you can use the 'last-modified to continuously iterate on frequently changing data.

from Orders as o
where o.'@metadata'.'@last-modified' > "2018-08-28:12:11" 
order by o.'@metadata'.'@last-modified'
select {
    A: o["@metadata"]["@last-modified"]
}.

You can also use Subscription

user_112705610
Related