I am trying to find hierarchy of documents (Aggregation) from a collection in MongoDB using $graphLookup with keys partOf and contains which are of Object datatype that store array of categories and the _id field inside. Input collection sample (relationships_collection):…
This post is a continuation of the previous posts: Intersection of the range of values MongoDB - Intersection of the range of multiple row values MongoDB: Intersection of the range of multiple row values with object fields Suppose we have…
Suppose we have a mongodb collection with 6 columns: RoomFrom RoomTo PoolFrom PoolTo FloorFrom FloorTo Now I would like to select rows where range *From / *To intersect with another ranges. For example: [ { _id: 1, RoomFrom: 100, RoomTo:…
With MongoDB id stored in Java LUUID (legacy representation), when a script is run to retrieve these ids, the output shows them in binary format: var myStringArray = ["string1", "string2"]; for (var i = 0; i < myStringArray.length; i++) {…
I have a MongoDB document with number field: [ { _id: 1, number: 10 }, { _id: 2, number: 11 }, { _id: 3, number: 12 } ] And I'm using MongoDB filter $gte and $lte it looks like this:…
I have a collection of documents in MongoDB that all look similar to this: { "WorkspacePartTeamsite" : { "SiteContents" : [ { "_id" : "00000000-0000-0000-0000-000000000002", "Name" : "PublicFiles", }, { "_id" : "ad57fee3-e478-46a6-a8c1-499dcc98995f", "Name" : "Private", }, ... ] }…
in MongoDB I want to group an array of documents that is nested in another document without it affecting the parent document. Database: db={ "users": [ { "firstName": "David", "lastName": "Mueller", "messages": [ { "text": "hello", "type": "PERSONAL" }, {…
I have mongo collection with objects with 2 fields: available_from and available_to Mongo collection: [ { "_id": ObjectId("66ed4d5ede0184e906f9397a"), "available_from": ISODate("2024-09-20T00:00:00.000Z"), "available_to": ISODate("2024-09-30T00:00:00.000Z") } ] I want to get all dates which are in specific array For example my input is:…
Currently by default when an expensive query is performed we apply a limit (as well as a time limit) to prevent a query from taking too long. We have a few simple indexes and are not ready to add any…
I have a data set that I am "mapping" into different names. Using Mongodb 7.0. I am using aggregate I am at the "$project stage { _id: 0, "First Name": "Executive First Name", "Last Name": "Executive Last Name", "Title": {…