I’m trying to build a OData api on top of scylla using the c# Cassandra library.
Do you have any recommendation to “navigate” between pages like getting the next / previous page or pointing directly to a specific page ?
I already implement the pagination with the PagingState but this allow me only to move to the next page
@Guy I saw your comment into the Slack channel telling us to ping you to get an answer, hope it doesn’t bother you
Have a good day 
One suggestion is to “cache” previous PaginingState between calls
And a bit more elaborate explanation on how to implement next/previous queries, by using revered queries:
https://community.ibm.com/community/user/supplychain/blogs/tanvi-kakodkar1/2020/01/24/paging-filtering-apache-cassandra
I didn’t tested if mixing pagingState with reverse queries, it might also do the trick.
1 Like