title: JasperReports MongoDB Query How to access subdocument?
body: <p>We have a document stored in <code>MongoDB</code> which looks like this:</p>
  
  <pre><code>{
      "id" : 1,
      "name" : "demo-name",
      "lastModified" : ISODate("2015-01-07T07:19:35Z"),
      "snapshot" : {
          "rows" : [
              {
                  "quantity" : 100,
                  "rate" : 32,
                  "description" : "22MM SHROUDED PBA RED",
                  "productCatlgNo" : "3MA40 00 AA0"
              },
              {
                  "quantity" : 125,
                  "rate" : 32,
                  "description" : "22MM SHROUDED PBA BLACK",
                  "productCatlgNo" : "3MA40 01 AA0"
              }
          ]
      }
  }
  </code></pre>
  
  <p>I am trying to access this document and read only the data stored in the <code>snapshot.rows</code> in <code>JasperStudio</code> report designer using the following query:</p>
  
  <pre><code>{
      'collectionName' : 'views.abcdefghi',
      'findQuery' : {
          'name': 'demo-name'
      },
      'findFields':{
          'snapshot.rows': 1
      }
  }
  </code></pre>
  
  <p>But the output contains only <code>snapshot.rows</code> whereas I want the inner details of the documents present in the <code>rows</code>.</p>
  
  <p>How should I go about it?</p>