Understanding query results in JSON arrays
The following lines show one of the simplest queries that we can run against the previously created VideoGames1 collection and retrieves the document whose id is equal to 2. The code file for the sample is included in the learning_cosmos_db_03_01 folder in the sql_queries/videogame_1_01.sql file:
SELECT * FROM Videogames v WHERE v.id = '2'
In the Azure portal, make sure you are in the page for the Cosmos DB account in the portal. Click on the Data Explorer option, click on the database name (Competition) to expand the collections for the database, and click on the collection name (VideoGames1). Click on New SQL Query in the toolbar located at the top of the panel and the portal will add a new query tab with a default query at the top: SELECT * FROM c. Select this text, paste the new text for the query, and click Execute Query. Cosmos DB will execute the query and the portal will display the JSON document with the results in the Results tab, as...
