python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - mongodb-query

How to ignore case when using filters with the mongo driver in dot net core with C#

I have an aggregates pipeline query as below: string [] sids = { array of Student ids here }; string deptName = "math"; var pipeline = new BsonDocument[] { new BsonDocument(&qu...
test-img

user20358

c#

mongodb

.net-core

mongodb-query

Votes: 0

Answers: 1

Latest Answer

You could convert the two sides of the match expression to lowercase with ToLower() ToLower(left operand).equal(ToLower(right operand)) //so we can ignore case.
test-img

navylover

Update mongo collection with values from a javascript map

I have a collection that looks like this [ { "project":"example1", "stores":[ { "id":"10" "name&q...
test-img

s.demuro

javascript

node.js

typescript

mongodb

mongodb-query

Votes: 0

Answers: 2

Latest Answer

In the end, I resolved by updating the original database entity object with the values in the map, then I have generated a bulk query. for (let p of projects) { for(let s of p.stores) { i...
test-img

s.demuro

Updating a nested array using $indexOfArray and $slice in MongoDB

Using the following documents, we are able to do what we need to do which is essentially "re-parenting" a document that stores an array of ancestors like so: db.getCollection("myarrays&...
test-img

Tom

mongodb

mongodb-query

aggregation-framework

Votes: 0

Answers: 1

Latest Answer

You can first $unwind references for easier processing and reusing your working logic. Use $cond to conditionally perform your working logic on elements with parent2. Finally, $group to regroup the un...
test-img

ray

Mongo Group By query

I have data stored in a Mongo collection that is structured like this: { "numberAtPending" : 3, "numberAtInProgress" : 5, "numberAtCancelled" : 1, "...
test-img

R111

sql

mongodb

mongodb-query

aggregation-framework

grouping

Votes: 0

Answers: 1

Latest Answer

You can try this query (also I'm assuming the output you show is an example and not the real values because I don't know from where can you get 300, 150, 400...) So, try this: You have two options to ...
test-img

J.F.

Posts

Questions

Blogs

Jobs