How to find all parents elements in a JSON file

How to find all parents elements in a JSON file?

Source: StackOverflow

Question

How to find all parents elements in a Json file? I'm currently working on a recursive menu which is built on top of jQuery which looks quite good already. The structure of the JSon file containing the menu looks as the following:

[
   { 
       "Id": "menuOfficeWebControlsForWebApplication", 
       "Title": "Office Web Controls", 
       "Resource": "/Documentation/Data/index.html" },
   { 
       "Id": "menuGettingStarted", 
       "Title": "Getting Started", 
       "Resource": "/Documentation/Data/getting-started.html", 
       "Categories": [{ 
             "Id": "menuCompilingFromSource", 
             "Title": "Compiling From Source", 
             "Resource": "/Documentation/Data/Getting-Started/compiling-from-source.html" 
          },{ 
             "Id": "menuDownloadReleasePackage", 
             "Title": "Download Release Package", 
             "Resource": "/Documentation/Data/Getting-Started/downloading-release-package.html"
          },{ 
             "Id": "menuBuildingYourFirstApplication", 
             "Title": "Building your first application", 
             "Resource": "/Documentation/Data/Getting-Started/building-your-first-application.html" 
        }]
   }
]

Now, I want to retrieve all the elements which are at a higher level and all the items which are directly below that item.

Answer

You can do it with AlaSQL SEARCH operator:

    var res = alasql('SEARCH /(Categories/)? WHERE(Id) FROM ?', [data]);

To list only valid keys you can use:

    var res = alasql('SEARCH /(Categories/)? Id FROM ?', [data]);