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


P

pestuser12

Joined
Aug 27, 2022
Messages
1
Reaction score
0
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.
 
Ad

Advertisements

Ad

Advertisements

BigDady

BigDady

Joined
Nov 13, 2020
Messages
250
Reaction score
31
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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking dynamically populated data using ajax with user entered value 5
Multi select options in a menu 1
Javascript fill function data from multidimensonal array 0
I Need Help with making a function that draws in a canvas using location data. 1
Why is this WordPress comments form not submitting? 1
Working on mobile css menu with plenty of frustration! 1
Fatal error: Uncaught Error: Cannot use object of type WP_Error as array in 0
Help with my responsive home page 2

Top