I have a collection in MongoDb and the data in it is as follows. [ { "_id" : ObjectId(""), "at" : ISODate("2022-03-27T11:56:00.000Z"), "personIds" : 13355, "productIds" : [ "c3cc8b62-f9f7-4845-8585-effb1efd790d", "af59b890-61b6-45a6-b2a1-32e16ba1a136" ] }, { "_id" : ObjectId(""), "at" : ISODate("2022-03-28T11:56:00.000Z"), "personIds"…
I want to search autocomplete on the following fields :contactfirstname, contactlastname and name Also, want to filter based on userid(s) first then perform autocomplete search Issue: Without filter criteria, autocomplete is working fine With filter criteria in compound query not…
I have collection with numeric value in string format. I want to get distinct value sorted by numeric order. Here is the sample data and query I have https://mongoplayground.net/p/Z9VRzlHjD7J Data [ { id: "1" }, { id: "1005" }, {…
I have a document that's look like this if it hasn't got any items in the itemList field: { "_id":{ "$oid":"62e12a0b73a8c3469e635d93" }, "listName":"name of list", "alloweUidList":[ { "uid":"prQUKkIxljVqbHlCKah7T1Rh7l22", "role":"creator", "boolId": 1, } ], "itemList":[ ], "crDate":"2022-07-27 14:05", "modDate":"2022-07-27 14:05", "boolId":1…
Objects of my collection have a field, that is an array of objects with one of the field being a string date { citizens: [{ name: 'John' birthday: '1993/07/13' }, { name: 'Sarah' birthday: '1996/07/13' }, { name: 'Natalia', birthday:…
My MongoDB looks something like this : {"_id": "1234aa", "maturity_dt":"2022-07-10", "countryCode":"BLG"}, {"_id": "123ab", "maturity_dt":"2022-07-30", "countryCode":"BLG"} Note that maturity_dt is a string. I want to fetch the records with maturity_dt lesser than Today's date. Please help me build a query with…
I have a sample collection of documents in mongo db like below [{"name":"hans","age":30,"test":"pass","pre":"no","calc":"no"}, {"name":"abs","age":20,"test":"not_pass","pre":"yes","calc":"no"}, {"name":"cdf","age":40,"test":"pass"}, {"name":"cvf","age":30,"test":"not_pass","pre":"no","calc":"yes"}, {"name":"cdf","age":23,"test":"pass"}, {"name":"asd","age":35,"test":"not_pass"}] For some documents the fields pre and calc are not present. I want to add those two fields to the documents which…
I am working with 1.000 documets in a collection in MongoDb. Each document can be made of many topics, and a topic can be made of many keywords. The mongo structure for each document is the following: _id:ObjectId(6d5fc0922982bb550e08502d), id_doc:"1234-678-436-42" topic:Array…
I have a MongoDB collection in the form of: users: { { user_id: 1000, activities: [ {id: 1, activity: 'swimming'}, {id: 2, activity: 'running'}, {id: 3, activity: 'biking'},... ] },... } and I want to get the activity document that…
I have the following aggregation stage that I'd like to add to my pipeline, but it keeps failing. When I use the MongoDB Compass Aggregation GUI, everything works as it should. I even exported that pipeline from the GUI and…