Hello Xano community!
I'm stuck on trying to query a list of results filtered on a table reference array.
I have two tables - "stacks" and "athletes"
stacks has a field that's an athlete table reference which is an array (can add as many athletes as needed)
I've tried what seems like everything when it comes to building a function or api call to return a list of stacks based on a list of athlete ids (or any other athlete field). Just cannot get it to work.
Here's my input: (athlete_uuids) string array
{
"athlete_uuids": [
"b0579bda-6f58-4036-8c26-2deb55001519",
"28367a9f-ec5e-4f53-80b4-aec713641105"
]
}
My filter:
My result:
I have a solid amount of hours with Xano but cannot find a way for this to work. Any help would be greatly appreciated!