# Query to the alias with multiple indices

**URL:** <https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010>\
**Category:** Elasticsearch\
**Created:** [April 3, 2017, 1:56pm UTC](https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010 "2017-04-03T13:56:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![opuzakov](https://avatars.discourse-cdn.com/v4/letter/o/ac91a4/32.png) [@opuzakov](https://discuss.elastic.co/u/opuzakov)\
**Post date:** [April 3, 2017, 1:56pm UTC](https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010/1 "2017-04-03T13:56:53Z")

</div>

I use one alias for multiple indices and when i do searching i receive the exception "No mapping found for [FieldName] in order to sort on" , but this exception appear for type, which i do not use for searching. Why elastic do searching for all types in alias , if i use specific type?

**Aliases:**

```
{
   "test2": {
      "aliases": {
         "alias1": {}
      }
   },
   "test1": {
      "aliases": {
         "alias1": {}
      }
   }
}

```

**Mappings:**

```
{
   "test2": {
  "mappings": {
     "type2": {
        "properties": {
           "field2": {
              "type": "string"
           },
           "field22": {
              "type": "string"
           },
           "field222": {
              "type": "string"
           }
        }
     }
  }
   },
   "test1": {
  "mappings": {
     "type1": {
        "properties": {
           "field1": {
              "type": "string"
           },
           "field11": {
              "type": "string"
           }
        }
     }
  }
   }
}

```

**Query:**

```
POST /alias1/type2/_search
{
"from": 0,
"size": 100,
"sort": [
  "field222"]
}

```

**Result:**

```
{
   "took": 3,
   "timed_out": false,
   "_shards": {
      "total": 10,
      "successful": 5,
      "failed": 5,
      "failures": [
         {
            "shard": 0,
            "index": "test1",
            "node": "lMhjTXnGSmazRBrTUqJy4Q",
            "reason": {
               "type": "search_parse_exception",
               "reason": "No mapping found for [field222] in order to sort on"
            }
         }
      ]
   },
   "hits": {
      "total": 1,
      "max_score": null,
      "hits": [
         {
            "_index": "test2",
            "_type": "type2",
            "_id": "type2_1",
            "_score": null,
            "_source": {
               "field2": "field2",
               "field22": "field22",
               "field222": "field222"
            },
            "sort": [
               "field222"
            ]
         }
      ]
   }
}
```

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 4, 2017, 12:16am UTC](https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010/2 "2017-04-04T00:16:45Z")

</div>

> [@opuzakov](#):
>
> Why elastic do searching for all types in alias , if i use specific type?

Aliases don't pay attention to types, so it'll still try to query both indices.

---

<div class="post-metadata">

**Author:** ![opuzakov](https://avatars.discourse-cdn.com/v4/letter/o/ac91a4/32.png) [@opuzakov](https://discuss.elastic.co/u/opuzakov)\
**Post date:** [April 4, 2017, 7:29am UTC](https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010/3 "2017-04-04T07:29:48Z")

</div>

Do we have any ways to search by type in the alias?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 4, 2017, 8:02am UTC](https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010/4 "2017-04-04T08:02:33Z")

</div>

A filtered alias will do 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:** [May 2, 2017, 8:02am UTC](https://discuss.elastic.co/t/query-to-the-alias-with-multiple-indices/81010/5 "2017-05-02T08:02:45Z")

</div>

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