[SERVER-58422] Deep find nested objects, almost like a graph db Created: 10/Jul/21  Updated: 17/Aug/21  Resolved: 17/Aug/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Trivial - P5
Reporter: Gerrie van Wyk Assignee: Edwin Zhou
Resolution: Done Votes: 0
Labels: feature
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:

 Description   

Not sure how feasible this is, but working with relational data in MongoDB is always a pain since finding nested documents requires writing an aggregation using $lookup, $unwind, etc. 

Just thought of a convenient implementation to solve this. If only ObjectIds included a collection id, then you could call a "deep find" method which fetches all nested objects where it encounters an ObjectId in the return documents. 

Other considerations here would be infinite loop protection and a max depth feature.



 Comments   
Comment by Edwin Zhou [ 17/Aug/21 ]

Hi gvw@lowdefy.com,

We haven’t heard back from you for some time, so I’m going to close this ticket. If this is still an issue for you, please provide additional information and we will reopen the ticket.

Best,
Edwin

Comment by Edwin Zhou [ 09/Aug/21 ]

Hi gvw@lowdefy.com,

We still need additional information to diagnose the problem. If this is still an issue for you, would you please let us know if $graphLookup describes the use case for the feature described by this ticket's description?

Best,
Edwin

Comment by Edwin Zhou [ 23/Jul/21 ]

Hi gvw@lowdefy.com,

You seem to be describing the existing $graphLookup aggregation stage.
Does this feature meet your criteria? Is there a use case you're interested in that the $graphLookup doesn't include?

Best,
Edwin

Comment by Brian Samek [ 12/Jul/21 ]

Moved to the SERVER project.

Comment by Gerrie van Wyk [ 10/Jul/21 ]

Sorry just see now that this was created under the wrong team.

Generated at Thu Feb 08 05:44:28 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.