Create a recursive Json object from categories to display on the website menu

pestuser12 · Aug 27, 2022

I created a categories document in mongodb like this

JSON:

{

    id: 1,

    name: 'digital',

    parent: null

},

{

    id: 3,

    name: 'tv',

    parent: 1

},

{

    id: 4,

    name: 'samsung',

    parent: 3

},

{

    id: 2,

    name: 'kitchen',

    parent: null

},

{

    id: 5,

    name: 'electronic',

    parent: 2

}

While Thanking the forum, i had a request a aggregate command to reach this Json

JSON:

[

  {

    "id": 1,

    "name": "digital",

    "children":[

      {

        "id": 3

        "name": "tv",

        "children": [

          {

            "id": 4,

            "name": "samsung",

            "children": []

          }

        ]

      }

    ]

  },

  {

    "id": 2,

    "name": "kitchen",

    "children": [

      {

        "id": 5,

        "name": "electronic",

        "children": []

      }

    ]

  }

]

In all records, the children field needs to be identified.
I will be very grateful for your answers.

BigDady · Aug 28, 2022

You have a couple of mistakes in that last object. How did you get it?

BigDady · Aug 29, 2022

Please check your json array with mine to find your errors. I just gave you the ids of the children and the last reveal was looking at the last empty child so you can see how to get the others. Any questions?

Code:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
</head>

<body>
    <p id="here"></p>
    <p id="there"></p>
    <p id="nowhere"></p>
    <p id="nothere"></p>
<script>

var myArray = [
    {
        "id": 1,
        "name": "digital",
        "children":[
        {
            "id": 3,
            "name": "tv",
            "children": [
                {
                    "id": 4,
                    "name": "samsung",
                    "children": []
                }
            ]
        }
        ]
    },
    {
        "id": 2,
        "name": "kitchen",
        "children": [
            {
                "id": 5,
                "name": "electronic",
                "children": []
            }
        ]
    }
]
document.getElementById('here').innerHTML = myArray[0].children[0].id;
document.getElementById('there').innerHTML = myArray[0].children[0].children[0].id;
document.getElementById('nowhere').innerHTML = myArray[1].children[0].id;
document.getElementById('nothere').innerHTML = myArray[1].children[0].children[0];
</script>
</body>
</html>

Collect Excel Data from Website	5	Apr 30, 2022
Working on mobile css menu with plenty of frustration!	2	Dec 29, 2022
java restful receive json	0	Apr 29, 2014
Iteration through a json object	5	Sep 5, 2008
menu bar and banner responsive issues....any guidance is appreciated!	0	Apr 5, 2016
Nokia N97 mini Unlocked - 3.2 inches TFT 16M Colors Touchscreen - 5MPCamera - with WiFi and A-GPS Su	0	Jul 7, 2010
Passing an array from FORTRAN to C then passing it within C andReturning it to FORTRAN	1	Nov 6, 2010
Populating a tree structure from a recursive query	6	Oct 25, 2005

Create a recursive Json object from categories to display on the website menu

pestuser12

BigDady

BigDady

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads