In MongoDB, can we get distinct values of a field regardless of hierarchy?

Asked Mar 24 '22 at 18:42

Active Mar 24 '22 at 18:42

Viewed 53 times

I am creating an application to store and display multiple hierarchies. I am storing json data in nested tree format like the following

{
  "text":"Node1",
  "children":
      [{
         "text":"Node2",
         "children":[...]
       },
       {
          "text":"Node3",
          "children":[...]
       }]
}

Is there a way to get the distinct values for the field text regardless of where the field appears in hierarchy. It could be the text of the parent, child, grandchild or further descendants.

Desired output is ["Node1","Node2","Node3",...]

asked Mar 24 '22 at 18:42

Udhayha Karthik

1

You might be able to use `"$function"` to recursively descend `children`. – rickhg12hs Mar 25 '22 at 19:00
Related, but as yet [unanswered question](https://stackoverflow.com/q/71638088/1409374 "Link to related question -->"). – rickhg12hs Mar 28 '22 at 15:20
2

And now it has an [answer](https://stackoverflow.com/a/71650522/1409374) that I think you can use. – rickhg12hs Mar 28 '22 at 17:43

In MongoDB, can we get distinct values of a field regardless of hierarchy?

0 Answers0

Linked