documentdb-lumenize icon indicating copy to clipboard operation
documentdb-lumenize copied to clipboard

ParitionKey required on sum

Open mregni opened this issue 6 years ago • 1 comments

Hi, thanks for the nice store procedure!

One quick question. I'm using this one on a shared CosmosDB with partition key 'pk', when I query my db with the following code I get an error:

"System.Private.CoreLib: Exception while executing function: Horizontal. Microsoft.Azure.DocumentDB.Core: PartitionKey value must be supplied for this operation."

Any idea how I can fix this?

string cubeConfigString = @"{
        cubeConfig: {
        groupBy: 'startDateTime', 
        field: 'timeserie', 
        f: 'sum'
    }, 
    filterQuery: 'SELECT * FROM c'
}";
Object cubeConfig = JsonConvert.DeserializeObject<Object>(cubeConfigString);
var result = await client.ExecuteStoredProcedureAsync<dynamic>(uri + "/sprocs/cube", cubeConfig);

mregni avatar Jul 24 '19 07:07 mregni

dynamic result = await this.Client.ExecuteStoredProcedureAsync<dynamic>("db", "collection", "cube", new RequestOptions() {PartitionKey = new PartitionKey("PK key vaule")}, new[] {config});

adamlepkowski avatar Aug 30 '19 20:08 adamlepkowski