my problem is: with a query I have a huge amount of found data / objects. Is there any way of having some kind of pagination on just the page, which is containing this query output?
I searched this community and also the documentation of Silverbullet, but I was not able to find such thing as “pagination”.
Or maybe there might be other ideas on how to solve the problem of querying a large set of pages? Thanks for any ideas and thoughts!
Hi, it’s not exactly what you’re asking for, but usually when I have too many results I use order by and limit clauses. All query syntax is documented at Query Language
However, this doesn’t give any way to show any subsequent page of results. Maybe if we had a skip clause, we could make the pagination ourselves, like:
order by age desc
skip 30
limit 10
To show the fourth “page” of results. I’m no SQL expert, but some JSON APIs use a similar construct, shouldn’t be to hard to add to query language
And then make it nicer to use with some commands/shortcuts etc. in userland based on personal preferences
Hey Marek, thanks for your reply. To me the problem before the “query thing” itself would be that it would be necessary to modify such a query to see “other pages” or “different results”.
But besides that I did not even think about the query language not being able to skip results after all. So good point as well! This all seems more complex than I thought.
At the moment my workaround is to have different pages with different kind of queries. E.g. I am having a diary and for that I have one page for all entries (not the whole entry, of course, but a link to this entry) for a specific year, for example.
Looking forward to other thoughts on that. And thanks again! (=
@tagirijus HTML tables can be paginated using JS/CSS (I found some examples on Codepen) but that wouldn’t limit the amount of data actually rendered into the page.