I must mis something, it has cost days already of tinkering without success. Googling doesn't give me anytying. When I ask GPT it says its a very common thing for noSql. But nowhere its discussed. I'm going nuts.
(Mind, i'm ew to both NoSQAL and Xano (came from Adalo, because there the thing I need is not possible, so have to do external DB))
Two tables
Games
Players
Each game has 2 or more players and these are stored as an object inside of the games-document.
What I want to achieve is setting up a custom API/Query, that gives me back a list of only certain games where a certain specific group of players were in.
Input could be a
game_id (find all games with the same player groups) or,
array of player_id's (find all games that have these players)
Ideally the latter, but then I'm not 100 sure I can get this to work from Adalo.
Use-case: Mainly statistics and cool insights.
"This group of players has played this specific game 34 times. Of that, Player A won the most, etc."
How do I set up this function?
I tried many variations, but all return errors.
I'm desperate for help, it has taken me already so much time (first like weeks in Adalo to give up there. So much thanks in advance.