Delete Documents from CosmosDB based on condition through Query Explorer

azure azure-cosmosdb
GorvGoyl picture GorvGoyl · Jun 27, 2017 · Viewed 31.6k times · Source

What's the query or some other quick way to delete all the documents matching the where condition in a collection?
I want something like DELETE * FROM c WHERE c.DocumentType = 'EULA' but, apparently, it doesn't work.

Note: I'm not looking for any C# implementation for this.

Answer

Stopped Contributing picture Stopped Contributing · Jun 27, 2017

I want something like DELETE * FROM c WHERE c.DocumentType = 'EULA' but, apparently, it doesn't work.

Deleting documents this way is not supported. You would need to first select the documents using a SELECT query and then delete them separately. If you want, you can write the code for fetching & deleting in a stored procedure and then execute that stored procedure.

Related questions

Get record count in Azure DocumentDb

It seems like 'select count(*) from c' in the SQL queries allowed by documentdb in the azure site and through the documentdb explorer (https://studiodocumentdb.codeplex.com/) is not supported. To date, the only way to get a record count …

Read More
Azure Cosmos DB - Understanding Partition Key

I'm setting up our first Azure Cosmos DB - I will be importing into the first collection, the data from a table in one of our SQL Server databases. In setting up the collection, I'm having trouble understanding the meaning …

Read More
Cosmos DB - Deleting a document

How can I delete an individual record from Cosmos DB? I can select using SQL syntax: SELECT * FROM collection1 WHERE (collection1._ts > 0) And sure enough all documents (analogous to rows?) are returned However this doesn't work when I attempt …

Read More