I am using typegoose and my Query and QueryRule models are as below. export class Query { @prop() queryRule: Ref<QueryRule>; } export class QueryRule { @prop() condition: Condition; @prop() rules: Ref<QueryRule | ChildRule>[]; } I am using the following query…
I have a document like this { "_id": ObjectId("626f942bb092f78afd9dad9d"), "item_id": "external _id222", "metadata": { "item_name": "abc", "quantity": 123, "state": null }, } What I would like to do is, $inc i.e. increment the count of quantity and then update the…
How might I query MongoDB for all documents where at least one value in an array falls inside a range, e.g. 8 to 10. If I query it as an enumeration, this works as desired: {x : {$in: [8, 9,…
I have a collection like this: { _id: "blabla", userName: "blablabla", .. interactedUsers: [ "blabla2" "some other user's id", "some other user's id", ] }, { _id: "blabla2", userName: "blablabla2", .. interactedUsers: [ "some other user's id", "some other user's…
I've indexed nuit, regNumber and _id for a faster query. You can find sample data and a solution which i'm not happy with because using $unwind and $lookup makes it iterate a million documents: https://mongoplayground.net/p/jR4Y-9-5As7 This is what i did:…
Given the following data in a Mongo collection: { _id: "1", dateA: ISODate("2021-12-31T00:00.000Z"), dateB: ISODate("2022-01-11T00:00.000Z") }, { _id: "2", dateA: ISODate("2022-01-02T00:00.000Z"), dateB: ISODate("2022-01-08T00:00.000Z") }, { _id: "3", dateA: ISODate("2022-01-03T00:00.000Z"), dateB: ISODate("2022-01-05T00:00.000Z") }, { _id: "4", dateA: ISODate("2022-01-09T00:00.000Z"), dateB: null },…
I am having a huge collection of objects where the data is stored for different employees. { "employee": "Joe", "areAllAttributesMatched": false, "characteristics": [ { "step": "A", "name": "house", "score": "1" }, { "step": "B", "name": "car" }, { "step": "C",…
We have the following records in a collection: { "_id" : ObjectId("1"), "date" : ISODate("2017-02-01T00:00:00Z") } { "_id" : ObjectId("2"), "date" : ISODate("2017-02-01T00:00:00Z") } { "_id" : ObjectId("3"), "date" : ISODate("2017-03-03T00:00:00Z") } { "_id" : ObjectId("4"), "date" : ISODate("2017-02-02T00:00:00Z") }…
Here is my mongo cluster (sharding with replicaset) configuration. replica sets: rs0 - IP1, IP2, IP3 || port - 27017 rs1 - IP4, IP5, IP6 || port - 27017 config server replica set - IP7, IP8, IP9 || port -…
I am trying to read data from a local collections from my mongodb database. Name of database Intuit name of collection post. Code inside PostController: <?php use IlluminateHttpRequest; use AppModelsPost; class PostController extends Controller{ public function home() { $posts =…