Configure Supabase collection to retrieve last added record

Ask us anything
1

Hi,

I am trying to retrieve the last added record from a Supabase table by using a collection. I know that I can retrieve all of the records and filter in WeWeb but I prefer to pull only the data that I need from the backend for performance and security reasons.

But I cannot see where in the collection creation process that I can do this.

Would appreciate any guidance.

Thanks
Steve

2

have a sort for created date and then a limit of 1

3

There is an option in the workflow action but I think itt’s been broken for like half a year now or more :upside_down_face:

4

I would suggest making a View in Supabase, that only holds the latest row.
Then your collection should just get the view.
then it will always (depending on your fetch interval) be updated to the latest row.

5

Thanks, will give it a try.

Steve