Mongodb – Mongo updateMany statement with date.withZoneSameInstant(xxx)
I have this collection in my Mongo database: id | place | local time -------------------------- 3 | A | 12pm 4 | A | 11pm 5 | B | 4pm 6 | | 7pm The local times are stored as…
Overwrite value and create key while update query in mongodb
I have a mongodb collection that looks like this: { "_id" : ObjectId("60471bd482c0da3c0e70d26f"), "owner" : "John", "propAvailable" : { "val1" : true } }, { "_id" : ObjectId("60471bd482c0da3c0e76523f"), "owner" : "Matt", "propAvailable" : { "val1" : { "val2" : true…
Extract field from mongodb query result set
How to extract json field from query response in node js? I have a query:- const Allposts = await Post.aggregate([pipeline]) Allposts:- { _id: 1, type: 'A', source: 'B', status: 'C', totalCount: 7, createdAt: 2022-04-13T17:12:28.097Z, updatedAt: 2022-04-13T17:12:28.097Z, __v: 0 }, {…
MongoDB Java – Create a new ObjectId for each element of an existing array
I have an existing collection, containing several documents. [{ "_id": "...1", "prop1": "...", "prop2": "...", "someArray": [ { "value": "sub element 1.1" }, { "value": "sub element 1.2" }, { "value": "sub element 1.3" } ] }, { "_id": "...2",…
Mongodb – How to check if an area intercepts with any one of other given areas
Before asking this question I read these answers, but could not find the solution: Check if coordinate is within area Geolocation - Check if a location belongs to an area Check if coordinate in selected area How to calculate intercepting…
Insert data with new fields OR update conditionally using updateOne mongodb
I have a document with format like this: { "f1": "v1", "f2": { "id": 1, "sub": "subv", "updatedAt": 123 } } I have an another source that give me a inputf2 object. I want to write an upsert query to…
Mongodb – Use limit and skip in MongoRepository<Customer,String>
We are working on a project to get data from mongoDB. We have created repository class as below @Repository public interface CustomerRepository extends MongoRepository<Customer,String>{ List<Customer> customers = findByCustomerId(final String customerId); } We are looking to add skip/offset and limit parameters…
extract subdocument in mongoDB
I am new to MongoDB and I'm struggling in extract a subdocument from a document. In my case, I have the following schema: [ { user_id: "u1", subscriptions: [ { "tier": "Basic", "requests": [ { "name": "aaaa" }, { "name":…
How do I retrieve all values for a particular field in MongoDB? – Twitter API
I have data from the Twitter API and I want to retrieve a list of all cities if the countryCode is equal to "AU". { "gnip" : { "matching_rules" : [ { "value" : "bio_location: "Australia"", "tag" : null },…
Why MongoDB saves Hash value in different format?
I am learning IPFS and trying to save IPFS file info in MongoDB. After uploading, I get one hash value ex: {fileHash: CID(QmbCaWPi9tSqcnykvBUMaH2M1d5PiVPLEfPwhJksSSeMak)} And in MongoDB, I see something like this: "fileHash": { "code": 112, "version": 0, "multihash": { "code":…