I have 4 documents with 3 property
{
id:”id1Main”,
title:”title1Main”,
path:”path1/”
}

I’m trying to write a cosmos query that return a list of ids, which contain duplicates in a string array that exists on each record.

How to round the result of an aggregate operation (SUM, AVG, MAX, MIN) in cosmosDB?

I’m trying to see how I can efficiently get a list of courses a student is registered for. All courses are stored in Cosmos DB using the Course object that looks like this:

I’m trying to extract different parts of an string input based on the occurrence of a character. But whatever I do is not working.

I have items in my cosmosdb and I want to order them by the orderStatus. RECEIVED item will be listed first, then PROCESSING items and then COMPLETED items.

Is it possible to have parameter passed to SQLQuery if yes how.