Can someone help me with a query on how to remove strings from an array in mongodb only if the string has a substring "abc.com" Current result in a collection : { _id: '1', users: ['[email protected]', '[email protected]', '[email protected]'] } {…
None of the following filters worked when I tried to update a document, in JS/Node.js filtered by "_id", where the value is the generic ObjectId (ObjectId('6365050650c6be6d5d090135')) : {_id : ObjectId(123....7890)} {_id : ObjectId('123....7890')} {_id : "ObjectId('123....7890')"} + other variantions I…
I am trying to do the following questions. Find the ISBN and title of books that was published in 2022. Find the ISBN, title of book and publisher of books that have at least two authors and at most three…
How do I use the method 𝑢𝑝𝑑𝑎𝑡𝑒() to implement the following changes? Add a new experience "HIVE" to the employee whose empeId is 'e001'. and Change the email account for employee e001 to "jamesbond$hotmail.com". Below is the database in question…
I have a collection where I want to find one data based on another object data: const data = [ { _id :0, name:"jane", joined : ISODate("2011-03-02"), likes : 30, dislikes: 9}, { _id :1, name: "joe", joined : ISODate("2012-07-02"),…
I want to get Descending order data by date on playDate Attribute, but descending condition is apply on gameName : hockey object Data [ { "gameDetails": [ { "gameName": "hockey", "playDate": "2014-05-05T00:00:00.000Z" }, { "gameName": "football", "playDate": "2022-06-05T00:00:00.000Z" } ]…
I need the first part of $or (or equivalent query) to be resolved first and to make sure that the first query is always part of the result. Must use query, not aggregation. [ { "docId": "x1" }, { "docId":…
How to know what all methods in mongoDb has an inbuilt promise in it. eg: "updateOne() , findOne()" these methods have inbuilt promises and and we can access the response using ".then" but for lots of other mongoDB methods lack…
Consider collection with following documents: [ { "_id": "3981396a-9fcb-4c24-976f-d500f20c4fab", "entries": [ { "key": "var1" "value": "value1" }, { "key": "var1" "value": "value11" } { "key": "var2" "value": "value2" } ] } ] What would be the appropriate approach to de-duplicate…
I'm trying to get the second latest full hour. So if the time is 15:30 now, I'm trying to get 14:00, so I basically need to truncate the current minutes and then furthermore truncate an hour.. I'm trying to project…