How to fetch data from superbase view

Ask us anything How do I?
1

Hi!
How do I fetch data from a superbase view instead of a table and apply pagination for it?
Should I do it via REST api or Superbase connection

Context:
I have two table: tasks and reviews. Each task can have many reviews.
I want to aggregate an average review rating for each task, so I created a view task_with_rating in superbase. How do I display that collection in weweb so with a dashboard of tasks, each of the has a rating with it?
Thanks!

2

Just use the Supabase collection and fetch the view :slight_smile: Then bind it as normal.

3

But the superbase collection only has the table dropdown, I don’t see my view in there?

image
image358×741 25 KB

4

It’s in the table dropdown, just look for it. Obviously you also need the view to be created.

1 Like
5

Got it. It’s showing up now!.. I guess it needed some time to sync with supabase. Thanks!