I have multiple JSON objects within items in COSMOS DB. For example: "Fruit": { "Apples": 200, "Oranges": 130, "Strawberries": { "Small": 30, "Large": "Finished" } "Fruit": { "Apples": 78, "Oranges": 90, "Strawberries": { "Small": 10, "Large": 30 } And I want to return all fruit where large is "Finished". So in this example just the… Read More COSMOS DB Find object within an object based on a value
I’m using the CosmosDB noSQL API and I feel like I’m not doing it right. The methods in the container class all return these iterator objects, which only have one method: next(). I need to get a list of records out of my container, and my only thought is to do this: def to_list(iterator): list… Read More CosmosDB Python get multiple items
I have a LINQ query where I need to use the CosmosDB ToString method within a query that is built via LINQ in C#. However I have not been able to figure out how to do this. Simply calling ToString() in the C# LINQ expression on the entity value does not work. I am trying… Read More Call CosmosDB ToString method in LINQ
In JPA we can create indexes for the entity using annotations like – @Table(indexes = @Index(columnList = "firstName")) Do we have a similar way of creating indexes for the Cosmos DB? >Solution : With Spring data cosmos, you can define custom indexing policy using @CosmosIndexingPolicy annotation for your container. Example: @Container(containerName = "users") @CosmosIndexingPolicy( includePaths… Read More Is there any annotation for creating indexes in Cosmos document?
I have a Python code to manage a collection in Cosmos DB by utilizing CosmosClient. It provides upsert_item, query_item, create_item, etc. But I need to delete properties from an existing item. Because the item could contain lots of properties, I wonder if there any better approach other than updating the whole item. I tried following… Read More How to delete properties from an item in CosmosDB
I have a table with data that looks like the following project | environment | timestamp —————————————- project1 | dev | 1644515845 project1 | dev | 1644513211 project1 | qa | 1644515542 project2 | dev | 1644513692 project2 | qa | 1644514822 There are multiple projects and each project has multiple environments. There are multiple… Read More SQL query for grouping by (project, environment) and finding the newest entry for each combination?