# No mapping found for \[\['amount'\]\] in order to sort on\]\] haschild query exception

**URL:** <https://discuss.elastic.co/t/no-mapping-found-for-amount-in-order-to-sort-on-haschild-query-exception/9733>\
**Category:** Elasticsearch\
**Created:** [November 15, 2012, 10:21pm UTC](https://discuss.elastic.co/t/no-mapping-found-for-amount-in-order-to-sort-on-haschild-query-exception/9733 "2012-11-15T22:21:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharath](https://avatars.discourse-cdn.com/v4/letter/s/b3f665/32.png) [@sharath](https://discuss.elastic.co/u/sharath)\
**Post date:** [November 15, 2012, 10:21pm UTC](https://discuss.elastic.co/t/no-mapping-found-for-amount-in-order-to-sort-on-haschild-query-exception/9733/1 "2012-11-15T22:21:34Z")

</div>

I am getting this search parse exception all I am doing is haschild filter  
and want to sort on a parent field called "amount" which actually exists.

SearchParseException[[index][2]:

query[ConstantScore(child\_filter[childelement  
/parent](filtered(filtered(filtered(filtered(text:water)-\>

cache(dates:[1199170800000 TO 1354280400999]))-\>cache(industry:10168299))-\>

cache(child\_type:childelement  
))-\>cache(\_type:childelement)))],from[0],size[10]:

Parse Failure [No mapping found for [['amount']] in order to sort on]]; }]

If anybody faced this exception before. I would appreciate if you share it.

--

---

<div class="post-metadata">

**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\
**Post date:** [November 16, 2012, 12:37am UTC](https://discuss.elastic.co/t/no-mapping-found-for-amount-in-order-to-sort-on-haschild-query-exception/9733/2 "2012-11-16T00:37:25Z")

</div>

Are you searching on all types or only on the parent type?

On Thursday, November 15, 2012 5:21:34 PM UTC-5, Helium wrote:

> I am getting this search parse exception all I am doing is haschild filter  
> and want to sort on a parent field called "amount" which actually exists.
> 
> SearchParseException[[index][2]:
> 
> query[ConstantScore(child\_filter[childelement  
> /parent](filtered(filtered(filtered(filtered(text:water)-\>
> 
> cache(dates:[1199170800000 TO 1354280400999]))-\>cache(industry:10168299))-\>
> 
> cache(child\_type:childelement  
> ))-\>cache(\_type:childelement)))],from[0],size[10]:
> 
> Parse Failure [No mapping found for [['amount']] in order to sort on]]; }]
> 
> If anybody faced this exception before. I would appreciate if you share it.

--

---

<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 6, 2017, 3:04am UTC](https://discuss.elastic.co/t/no-mapping-found-for-amount-in-order-to-sort-on-haschild-query-exception/9733/3 "2017-07-06T03:04:01Z")

</div>

Closed on July 6, 2017, 3:04am UTC