title: Group by/order by On JSON data using javascript/jquery
body: <p>I have a JSON data and I need to do something like group by and i asked this question before here but i am not getting any satisfied answer so this time i would like to explain more in depth.</p>
  
  <p>First, Can anybody explain me difference between <code>groupby</code> and <code>orderby</code> in javascript as in sql we do required aggregate function in order to use <code>group by</code>. But I don't want anything like aggregate function. Here I provide a very sample JSON data and Output that I was looking for.</p>
  
  <p>All author names should be <code>sortby</code> alphanumeric order.</p>
  
  <p>JSON data:</p>
  
  <pre><code>var myObject = {
      "Apps": [
          {
              "Name": "app1",
              "id": "1",
              "groups": [
                  {
                      "id": "1",
                      "name": "test group 1",
                      "category": "clinical note",
                      "author": "RRP"
                  }, {
                      "id": "2",
                      "name": "test group 2",
                      "category": "clinical image",
                      "author": "LKP"
                  }, {
                      "id": "3",
                      "name": "test group 3",
                      "category": "clinical document",
                      "author": "RRP"
                  }, {
                      "id": "4",
                      "name": "test group 4",
                      "category": "clinical note",
                      "author": "John"
                  }
              ]
          }
      ]
  }
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>John
    4 testgroup4 clinicalnote 
  RRP
    1 testgroup1  clinicalnote
    3 testgroup3  clinicaldocument
  LKP
    2 testgroup2 clinicalimage    
  </code></pre>
  
  <p>Any idea/suggestion/direction/thought would be great help. </p>