Skip to main content
Solved

Odata Pagination

  • December 8, 2022
  • 2 replies
  • 115 views

Forum|alt.badge.img+1

Hi everyone, we’ve been using the ODATA API for quite some time, but recently we’ve ran into a bit of a limitation. It seems like the Odata API does not support SKIP & LIMIT, which are necessary if we want to build pagination in the application we’re building. The only option right now is to use TOP as a initial limit, but that does not scale well when working with large & increasing datasets.

Best answer by Mark Jongeling

Hi @ssital,

What is exactly your question?

Indicium does support the usage of both Top and Skip, f.e.: "&$skip=425&$top=25”. This will skip the first 425 rows and thereafter select the 25 records after. Our Universal GUI does also support pagination once a Page size is set up for a table in the model.

More info on it here: https://docs.thinkwisesoftware.com/docs/indicium/api#supported-odata-operations

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

Mark Jongeling
Administrator
Forum|alt.badge.img+23
  • Administrator
  • 3940 replies
  • Answer
  • December 8, 2022

Hi @ssital,

What is exactly your question?

Indicium does support the usage of both Top and Skip, f.e.: "&$skip=425&$top=25”. This will skip the first 425 rows and thereafter select the 25 records after. Our Universal GUI does also support pagination once a Page size is set up for a table in the model.

More info on it here: https://docs.thinkwisesoftware.com/docs/indicium/api#supported-odata-operations


Forum|alt.badge.img+1
  • Author
  • Apprentice
  • 5 replies
  • December 12, 2022

Hi Mark,

I thought skip was not supported as it wasn’t documented. We tried it and it does help our issue.

 

Thanks for the feedback!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings