is it possible to call `.order()` an a `.rpc()` re...
# help
u
is it possible to call
.order()
an a
.rpc()
request? the types seem to allow it, but then when the request goes through in the browser I get an error:
Copy code
js
{ message: "column pgrst_source.created_at does not exist", code: "42703", details: null, hint: null }
n
Hello @(d,f,g)=> 🥁! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates. Want to change the title? Use the ``/title`` command! We have solved your problem? Click the button below to archive it.
🆕 order by on a stored procedure?
g
Can you show your client call?
n
order by on a stored procedure?
u
Copy code
js
await supabase.rpc('threaded_comments', { slug })
  .order('created_at', {ascending: false})
I know there's a created_at column, I explicitly select it in the function ...oh right I'm returning json, no wonder it doesnt recognize the column whoops! I'll have to add the
order by
to the
json_agg
call thanks for popping in and helping me rubber duck lol
n
Thread was archived by @(d,f,g)=> 🥁. Anyone can send a message to unarchive it.