update() not returning records

Not sure if I'm doing something wrong, but

update()

update()

update()

update() is not returning any data and the docs say by default it returns the updated record. Also, the returning property does not seem to exist as per the docs.

.update({val: 123}, {returning: 'representation})

.update({val: 123}, {returning: 'representation})

.update({val: 123}, {returning: 'representation})

.update({val: 123}, {returning: 'representation}) and TS complains that only

count

count

count

count is valid. The data is actually being updated in the database. In the below code, the

if (data) {}

if (data) {}

if (data) {}

if (data) {} condition never fires, and the first console.log always returns undefined. If i force an error, error is working as expected.

      const { data, error } = await supabase.from('inventory').update(newRow).match({ id: newRow.id })

      console.log('data below await', data)

      if (data) {
        console.log('data from inside conditional', data)
      }

      if (error) {
        console.log('error!', error)
      }

      const { data, error } = await supabase.from('inventory').update(newRow).match({ id: newRow.id })

      console.log('data below await', data)

      if (data) {
        console.log('data from inside conditional', data)
      }

      if (error) {
        console.log('error!', error)
      }

      const { data, error } = await supabase.from('inventory').update(newRow).match({ id: newRow.id })

      console.log('data below await', data)

      if (data) {
        console.log('data from inside conditional', data)
      }

      if (error) {
        console.log('error!', error)
      }

      const { data, error } = await supabase.from('inventory').update(newRow).match({ id: newRow.id })

      console.log('data below await', data)

      if (data) {
        console.log('data from inside conditional', data)
      }

      if (error) {
        console.log('error!', error)
      }

gorbyparkOP•9/6/22, 11:38 AM

ugh, turns out i was somehow on 2.0.0 rc8 not the latest stable.

hankg•9/6/22, 11:40 AM

Are they going to using selectselect at the end to return data from updates like in the RC of the Dart library?

garyaustin•9/6/22, 1:12 PM

1.35.6 is the latest v1.
2.0.0.rc8 is the latest v2. If you want to use v2 make sure to ready the release notes or the v2 refrence docs. You now neede .select("col") or .select() at end of update as hankg says. https://supabase.com/docs/reference/javascript/next/release-notes#data-operations-return-minimal

Release Notes | Supabase

Supabase.js v2 release notes.

gorbyparkOP•9/6/22, 1:23 PM

great, thanks! I wasn't intentionally on v2, not quite sure how that happened.

update() not returning records

Similar Threads

Similar Threads

Similar Threads