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…
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…
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":…
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 },…
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":…
I'm working with this query: customers.aggregate: [ {$lookup: { from: "users", localField: "_id", foreignField: "customerId", as: "users" }}, {$lookup: { from: "templates", let: {localField: "$_id"}, pipeline: [{ $match: { $and: [{ $expr: { $eq: ["$customerId", "$$localField"]}}, {module: false}] }}], as:…
I would like to get price and date info and send to ejs the between two specific dates and names. My first document is like this and I have many. For instance I want all Bitcoin infos between 2022-4-1 and…
I have a large set of records in this schema: { username: "[email protected]", timestamp: 1646006400000 //unix timestamp in milliseconds amount: 100 } Given an arbitrary range of dates, I need to find the change in average amount value vs a…
I am trying to count how many times does a particular value occur in a collection. { _id:1, field1: value, field2: A, } { _id:2, field1: value, field2: A, } { _id:3, field1: value, field2: C, } { _id:4, field1:…
{ "_id" : ObjectId("5c139771d79ac8eac11e754a"), "title" : "API", "content" : "API stands for Application Programming Interface. It is a set of subroutine definitions, communication protocols, and tools for building software. In general terms, it is a set of clearly defined methods…