# Retrieving nested objects using \`SearchRequestBuilder\`

**URL:** <https://discuss.elastic.co/t/retrieving-nested-objects-using-searchrequestbuilder/26937>\
**Category:** Elasticsearch\
**Created:** [August 6, 2015, 5:23am UTC](https://discuss.elastic.co/t/retrieving-nested-objects-using-searchrequestbuilder/26937 "2015-08-06T05:23:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arinto\_Murdopo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arinto_murdopo/32/1779_2.png) [@Arinto\_Murdopo](https://discuss.elastic.co/u/Arinto_Murdopo)\
**Post date:** [August 6, 2015, 5:23am UTC](https://discuss.elastic.co/t/retrieving-nested-objects-using-searchrequestbuilder/26937/1 "2015-08-06T05:23:54Z")

</div>

Hi all,

Here's our sample document:

```auto
{
  .... we have other fields in this document
  "urlEntities": [
    {
      "url": "https://x.xx/xxxxxxx",
      "expandedURL": "https://xxxxxxx.xxxx/p/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/",
      "end": 92,
      "start": 69,
      "displayURL": "xxxxxxxxxxxxxx.xxx/p/xxxxxxx..."
    }
  ],
  "createAtMilis": 1438757536000,
  "createdAt": "Aug 5, 2015 2:52:16 PM",
  .... we have other fields in this document
}

```

We tried to scan and filter the indices with many of those documents using this `SearchRequestBuilder`:

```auto
      SearchRequestBuilder srb = client.prepareSearch(index)
                .setTypes(type)
                .setSearchType(SearchType.SCAN)
                .addFields("createdAt", "createAtMilis", "urlEntities")
                .setQuery(QueryBuilders.matchAllQuery())
                .setPostFilter(FilterBuilders.andFilter(
                        FilterBuilders.rangeFilter( "createAtMilis").from(1398902400000L).to(1438757537000L),
                        FilterBuilders.existsFilter("urlEntities"))) 
                .setSize(100);

```

However, we don't get any `SearchHit`.

If we change the `addFields` line to `addFields("createdAt", "createAtMilis", "urlEntities.expandedUrl")`, we are able to get valid `SearchHit`, but the `SearchHit` doesn't contain field `urlEntities.expandedUrl`.

Is it the expected behavior of `addFields` and search with Scan in Elasticsearch? We would like to limit the number of resulting fields and to not retrieve the whole `_source` field.

How can we handle this case?

Thanks!

---

<div class="post-metadata">

**Author:** ![Arinto\_Murdopo](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arinto_murdopo/32/1779_2.png) [@Arinto\_Murdopo](https://discuss.elastic.co/u/Arinto_Murdopo)\
**Post date:** [August 13, 2015, 7:16am UTC](https://discuss.elastic.co/t/retrieving-nested-objects-using-searchrequestbuilder/26937/2 "2015-08-13T07:16:48Z")

</div>

Nevermind, apparently I use wrong field name. Problem solved! yay!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 11:56pm UTC](https://discuss.elastic.co/t/retrieving-nested-objects-using-searchrequestbuilder/26937/3 "2017-07-05T23:56:03Z")

</div>


