Pagination of Filtered Database Results

Ask the community
,
1

Hello! I’ve been scouring the forum for days now, and have yet to find a solution to this issue. I’ve tried pagination and a lazy load on scroll, but both reset the filtered results and show the default database items.

I’ve been working to do this on both of these pages (currently with lazy load, I’ve deleted the pagination). Thank you for any insight into whether this is possible at present! If yes, I’ll be happy to share my code for another set of eyes :).

https://londonmiddlebury.wixsite.com/afv1/innovative-resources
https://londonmiddlebury.wixsite.com/afv1/neurodiverse-resources

2 Likes
2

++1

3

Set the table’s pagination options

$w("#myTable").pagination = {"type": "pagination", "rowsPerPage": 4};
4

This example does not address the problem like so many others in this forum that I have found. Is there a definitive answer to coordinate the paginator with results of a query?

In testing all samples shown, after a query and I click on the paginator to another page number, the underlying data in the repeater reverts back to the original, un-filtered data.

5

Instead of bumping up all the old posts, you better should describe your ISSUE as most detailed as possible.
You can link all these old posts, if needed.

Generating a PAGINATOR is possible, also one, which do hold all data and do not lose search-results.

Your INGRIDIENTS would be…

  1. SKIP
  2. LIMIT
  3. HASNEXT
  4. Wix-Data-API

Sure it would also be possible to generate such function, by the usage of a DATASET.