Need help with querying results off of table reference array


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!

1
2 replies