Many to Many link only working one level
I have the following structure:
From a region level i am able to list all the muscle parts with the following query:
but when i try to do the same thing on the muscle_part level i don't get any results...
If I try this query it doesn't error but it doesn't show me any muscle results:
I have created composite keys and assigned them to the correct tables its just not rendering
Any clues?
- Muscle_Regions
- Muscle_Region_Muscle_Parts (M:M)
- Muscle_Parts
- Muscle_Parts_Mucles (M:M)
- MusclesFrom a region level i am able to list all the muscle parts with the following query:
let { data: muscle_regions, error } = await supabase
.from<MuscleRegion>('muscle_regions')
.select('*, muscle_parts (*)')but when i try to do the same thing on the muscle_part level i don't get any results...
If I try this query it doesn't error but it doesn't show me any muscle results:
let { data: muscle_regions, error } = await supabase
.from<MuscleRegion>('muscle_regions')
.select('*, muscle_parts (*, muscles(*))')
I have created composite keys and assigned them to the correct tables its just not rendering
Any clues?
