title: Couchbase query about dynamic object (stored in the map in java)
body: <pre><code>[
    {
      "_class": "com.netas.netmetriks.common.model.entity.WorkOrder",
      "failCount": 0,
      "id": "1",
      "messageType": "RESET_DCU",
      "ongoingWorks": [
        1
      ],
      "status": "IN_PROGRESS",
      "successCount": 0,
      "type": "workorder",
      "workOrderDetailMap": {
        "1": {
          "data": {
            "_class": "com.netas.netmetriks.common.model.converted.DeviceId",
            "manufacturerFlag": "DSM",
            "serialNumber": "87654321"
          },
          "dcuId": {
            "manufacturerFlag": "DSM",
            "serialNumber": "87654321"
          },
          "id": 1,
          "requestDate": "20160818114933",
          "resultDocuments": [],
          "status": "IN_PROGRESS"
        },
      "2": {
      "data": {
        "_class": "com.netas.netmetriks.common.model.converted.DeviceId",
        "manufacturerFlag": "DSM",
        "serialNumber": "87654322"
      },
      "dcuId": {
        "manufacturerFlag": "DSM",
        "serialNumber": "87654322"
      },
      "id": 2,
      "requestDate": "20160818114934",
      "resultDocuments": [],
      "status": "IN_PROGRESS"
       }
      }
    }
  ]
  </code></pre>
  
  <p>Simply i want to obtain inner of "1" and "2" objects.</p>
  
  <p>I am trying to obtain data,dcuId,id,requestDate,resultDocuments,status.</p>
  
  <pre><code>SELECT wd.* FROM netmetriks n
  UNNEST workOrderDetailMap wd
  WHERE  n.type = 'workorder' and n.id = '1'  ORDER BY n.documentId ASC LIMIT 10 OFFSET 0
  </code></pre>
  
  <p>I wrote a query but could not get rid of "1" and "2".</p>
  
  <p>HashMap is used in entity when storing data so the result shows 1,2,3,4 so on...</p>