Now we will build a simple query to retrieve all the high scores defined for each video game flattened into a single array. The following query will take advantage of the IN keyword, which makes it possible to iterate over properties that are of the array type. The code file for the sample is included in the learning_cosmos_db_03_01 folder in the sql_queries/videogame_1_14.sql file:
SELECT * FROM h IN Videogames.highestScores
The following lines show a pseudo-code that rewrites the previous query with imperative code:
resultArray = [];
foreach (var v in Videogames)
{
foreach (var h in v.highestScores)
{
resultArray.Add(h);
}
}
return resultArray; The following lines show the results of the query. Notice that each highest score document is an element of the generated array:
[
{
"player": {
"nickName": "Brandon in Wonderland",
"clan": "Wonderland Warriors"
},
"score": "750"
},
...