Count the occurrences of DISTINCT values using supabase

Question

I want alternative supabase code for this SQL command

SELECT order_date,COUNT(*) as count
FROM orders
GROUP BY order_date
ORDER BY order_date Desc;

What I am trying to do is, I want the number of orders of each day. This is how my table looks like

Since I am using supabase, I don't find any alternative for group by query. Can anyone please help?

Remember you can always make a stored procedure (function) that contains the SQL you want if you can't figure out how to do it with the API. It's often quicker to do it that way for one-off things. — Shorn, Apr 30 '21 at 10:31
Doing a group and count at the same time is not supported via supabase-js yet. As others mentioned create a view or stored proceedure first and then query it via supabase-js — everconfusedGuy, Apr 30 '21 at 14:30

score 3 · Accepted Answer · answered Apr 30 '21 at 13:58

3

Add this to a view or stored procedure, then it can be called via the API supabace.rpc()

answered Apr 30 '21 at 13:58

Hadi azeez

1 Answers1