Assume I have a collection, things, with the following documents: [ { "_id": 1, "name": "one", "others": [2, 3] }, { "_id": 2, "name": "two" }, { "_id": 3, "name": "three" }, { "_id": 4, "name": "four" } ] As…
I have a document as follows: { "_id": "1234", "created_at": 1678787680 } I want to modify the document and add a new key updated_at which will be a datetime equivalent of the created_at UNIX timestamp. { "_id": "1234", "created_at": 1678787680,…
I have over 1,000 JSON files representing game elements. This is a typical example: { "name": "Reeve Hunter", "edition": 3, "revision": "2021 v1", "keywords": [ "Circle", "Wolf Sworn", "Reeve of Orboros", "Solo" ], "point cost": 4, "field allowance": 2, "models":…
How can I compare month in spring mongo criteria with a hard corded value, month in criteria is in a spring format and the value is present in an integer format. This is what i have so far i just…
I have a following monogodb collections coll1 coll2 -------- ------- _id _id name coll1_ids coll2 can have multiple reference to coll1 but coll1 will only have one reference I want to populate coll2 data in coll1. Is there easier way…
I'm working with node and mongo 5. I am trying to select the field "TOTAL DUE" with a value other than '$0.00' . I think I'm able to select for '$0.00' with: {'TOTAL DUE': {$regex: /$0./}} as in the screenshot.…
please how can i make only admin access a specific route this is my mongodb database { "_id": { "$oid": "640e16b3186c0b1910c1dedf" }, "isAdmin": true, "name": "sample name", "email": "[email protected]", "password": "$2a$10$tbi9fblLS9NXai3Osb7H7OdLVqq34I0OTKgvB5BmVBEASabvX/ybu", "__v": 0 } isAdmin is set to true i…
Want to pass an integer holding microseconds since Epoch, to MongoDB shell's (version ~ 4.2) Date function to obtain a date. I understand MongoDB Date can take as argument, integer of milliseconds not microseconds, so need to convert from micro…
I have a collection of phrases with the following structure: phrase - string phraseLength (the length of the phrase string) author - string I would like to group phrases by author. And for each author, the maximum length of all…
Everytime my command ends I get this error. I have no idea what to do, the command gas been working before but it went downhill when I added a new function that updated another array. MongoServerError: Plan executor error during…