I have this query:
const {data, error} = await supabase
.from('profiles')
.select(`
*,
station (
station_name, user_id
),
type (
*
)
`)
.eq('id', searchParams.id)
I can see the data already, however, for the type I can only see the: [ [Object], [Object], [Object] ]
The types here may have multiple rows:
Sample output of the data:
[
{
id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
email: '[email protected]',
full_name: 'Raven',
`station: {
station_name: 'Water Station 1',
user_id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f'
},
type: [ [Object], [Object], [Object] ]
}
]
This is the sample data for the type when I query it:
const {data, error} = await supabase
.from('type')
.select(`
*,
profiles(
*
)
`)
.eq('user_id', searchParams.id)
Output:
[
{
id: 'c12c5e82-c569-48d9-ae25-4c68f0ac2935',
name: 'Distilled Water',
price: 20,
user_id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
profiles: {
id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
email: '[email protected]',
full_name: 'Raven'
}
},
{
id: 'f6759420-8ae7-485f-99da-0f248a964d63',
name: 'Mineral Water',
price: 50,
user_id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
profiles: {
id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
email: '[email protected]',
full_name: 'Raven'
}
},
{
id: '70e2e497-37b0-4294-a3b3-94bbd95c989a',
name: 'Sparkling Water',
price: 500,
user_id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
profiles: {
id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
email: '[email protected]',
full_name: 'Raven'
}
}
]
Expected Data is to show the list of types on this data:
[
{
id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
email: '[email protected]',
full_name: 'Raven',
station: {
station_name: 'Water Station 1',
user_id: '2d6c72a1-175c-4c08-823e-10e35c0d1d7f',
},
type: [
{
id: 'c12c5e82-c569-48d9-ae25-4c68f0ac2935',
name: 'Distilled Water',
price: 20,
},
{
id: 'f6759420-8ae7-485f-99da-0f248a964d63',
name: 'Mineral Water',
price: 50,
},
{
id: '70e2e497-37b0-4294-a3b3-94bbd95c989a',
name: 'Sparkling Water',
price: 500,
},
],
},
];