# There are more than one indices when using a query condition with business id

**URL:** <https://discuss.elastic.co/t/there-are-more-than-one-indices-when-using-a-query-condition-with-business-id/68389>\
**Category:** Elasticsearch\
**Created:** [December 8, 2016, 2:28am UTC](https://discuss.elastic.co/t/there-are-more-than-one-indices-when-using-a-query-condition-with-business-id/68389 "2016-12-08T02:28:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![yongzhi\_yang](https://avatars.discourse-cdn.com/v4/letter/y/e47c2d/32.png) [@yongzhi\_yang](https://discuss.elastic.co/u/yongzhi_yang)\
**Post date:** [December 8, 2016, 2:28am UTC](https://discuss.elastic.co/t/there-are-more-than-one-indices-when-using-a-query-condition-with-business-id/68389/1 "2016-12-08T02:28:13Z")

</div>

I using a query condition like this :  
curl -XGET [http://192.168.8.205:9200/dmall\_order\_\_order\_consignee/union/\_search?pretty](http://192.168.8.205:9200/dmall_order__order_consignee/union/_search?pretty) -d '{

> ```
> "query": {
> "bool": {
> "filter": {
> "term": {
> "wm_order__id": 356541713
> }
> } 
> }
> }
> 
> ```
> 
> }'

I got three indices with a same id :  
{  
"took" : 136,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 3,  
"successful" : 3,  
"failed" : 0  
},  
"hits" : {  
"total" : 3,  
"max\_score" : 0.0,  
"hits" : [ {  
"\_index" : "dmall\_order\_\_order\_consignee",  
"\_type" : "union",  
"\_id" : "13534356541713",  
"\_score" : 0.0,  
"\_source":{.......................  
,"wm\_order\_\_id":356541713,  
.....................  
}, {  
"\_index" : "dmall\_order\_\_order\_consignee",  
"\_type" : "union",  
"\_id" : "13534356541713",  
"\_score" : 0.0,  
"\_source":{......................  
,"wm\_order\_\_id":356541713,  
......................  
}, {  
"\_index" : "dmall\_order\_\_order\_consignee",  
"\_type" : "union",  
"\_id" : "13534356541713",  
"\_score" : 0.0,  
"\_source":{....................  
"wm\_order\_\_id":356541713  
......................  
} ]  
}

but I using the getting method like this :  
curl -XGET [http://192.168.8.205:9200/dmall\_order\_\_order\_consignee/union/13534356541713](http://192.168.8.205:9200/dmall_order__order_consignee/union/13534356541713)

I got the only one result :  
{"\_index":"dmall\_order\_\_order\_consignee","\_type":"union","\_id":"13534356541713","\_version":1,"found":true,"\_source":{.........................","wm\_order\_\_id":1356541713,..............................}

why there are three indices when I query with field 'wm\_order\_\_id' ?

Thanks.

---

<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:** [January 5, 2017, 2:28am UTC](https://discuss.elastic.co/t/there-are-more-than-one-indices-when-using-a-query-condition-with-business-id/68389/2 "2017-01-05T02:28:20Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.