Guide to NoSQL with Azure Cosmos DB

Using array iteration

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 ...