Is there anyway to return count as a single value, not an object in an array?

When doing a join like so:

 const { data, error } = await supabase
        .from(LISTINGS_TABLE)
        .select("*, comments:listingComments(count), likes:listingLikes(count)", { count: "estimated" })

 const { data, error } = await supabase
        .from(LISTINGS_TABLE)
        .select("*, comments:listingComments(count), likes:listingLikes(count)", { count: "estimated" })

I then have to access the amount of comments as

listing?.comments[0]?.count

listing?.comments[0]?.count

. Same thing with the likes:

listing?.likes[0]?.count

listing?.likes[0]?.count

I'd ideally like to just use

listing?.likes?.count

listing?.likes?.count

or even better

listing?.likes

listing?.likes

Supabase•4y ago•

26 replies

lewisd

Is there anyway to return count as a single value, not an object in an array?

When doing a join like so:

 const { data, error } = await supabase
        .from(LISTINGS_TABLE)
        .select("*, comments:listingComments(count), likes:listingLikes(count)", { count: "estimated" })

 const { data, error } = await supabase
        .from(LISTINGS_TABLE)
        .select("*, comments:listingComments(count), likes:listingLikes(count)", { count: "estimated" })

I then have to access the amount of comments as

listing?.comments[0]?.count

listing?.comments[0]?.count

. Same thing with the likes:

listing?.likes[0]?.count

listing?.likes[0]?.count

I'd ideally like to just use

listing?.likes?.count

listing?.likes?.count

or even better

listing?.likes

listing?.likes

Is there anyway to return count as a single value, not an object in an array?

Similar Threads

Is there anyway to return count as a single value, not an object in an array?

Similar Threads

Similar Threads

Similar Threads