Pagination with Supabase

Hi everyone,
I would like to know how you have been doing pagination with Supabase through the collection and ask some questions.

  1. We have the option to limit the number of items, and the plugin itself adds the offset, but when I jump to the next page through elementor pagination it pushes the collection instead of replacing it with the next items.
  2. Are items with a null value when pagination is applied something that cannot be resolved?

Due to these points it may be better to create a var and use SELECT with the range than to use the collection to bring in a lot of data.
I thank everyone for being able to help.
I think @Broberto would have a relevant opinion on this.

Hello, the two points you describe can be solved by using the SELECT Workflow indeed. There is probably no other way.

2 Likes

Thanks Bro

1 Like

If you bind the div to the collection instead of collection.data, the pagination will work fine.

Screen Recording 2024-09-07 at 3.16.24 PM

1 Like