title: How to apply complex data filters like SQL where clause on JSON
body: <p>I am Using Json to represent data at client side(javascript), I converted .net datatable object to json and now need to apply filter on Json data.  I used _.where to apply basic data filter , but need complex filtering like: </p>
  
  <pre><code>where = (stundentID = 55 and school='abc') AND (City='xyz' or City ='abc')
  </code></pre>
  
  <p>Its a basic type of filtration that we used in Oracle or sql server queries.  Now how can i apply such mechanism using underscore.js or some thing equivelant on Json or javascript structures. I might also need to do query of getting Top N record , using aggregation [ Sum(sales)==500] at javascript.  Waiting for your valuable suggestions. </p>
  
  <p>Thanks,</p>