Filter ids across multiple indexes

Elastic Stack Elasticsearch
1

I'm querying all searchable fields across all indexes and need to filter certain ids of documents returned from different indexes, how would I be able to filter/query for these kinds of results?

2

This? https://www.elastic.co/guide/en/elasticsearch/reference/6.2/query-dsl-ids-query.html

3

Yes, I need to make the ID's query work, but across multiple indexes. I.e. specify an array of ID's and the index that the different arrays of ID's need to be filtered on

4 
DELETE test1,test2 
PUT test1/doc/1
{
  "foo": "bar"
}
PUT test1/doc/2
{
  "foo": "bar"
}
PUT test2/doc/1
{
  "foo": "bar"
}
PUT test2/doc/2
{
  "foo": "bar"
}
GET _search
{
  "query": {
    "bool": {
      "should": [
        {
          "bool": {
            "must": [
              {
                "term": {
                  "_index": {
                    "value": "test2"
                  }
                }
              },
              {
                "ids": {
                  "values": [
                    "1"
                  ]
                }
              }
            ]
          }
        },        {
          "bool": {
            "must": [
              {
                "term": {
                  "_index": {
                    "value": "test1"
                  }
                }
              },
              {
                "ids": {
                  "values": [
                    "2"
                  ]
                }
              }
            ]
          }
        }

      ]
    }
  }
}

Gives:

{
  "took": 20,
  "timed_out": false,
  "_shards": {
    "total": 17,
    "successful": 17,
    "skipped": 0,
    "failed": 0
  },
  "hits": {
    "total": 2,
    "max_score": 2,
    "hits": [
      {
        "_index": "test1",
        "_type": "doc",
        "_id": "2",
        "_score": 2,
        "_source": {
          "foo": "bar"
        }
      },
      {
        "_index": "test2",
        "_type": "doc",
        "_id": "1",
        "_score": 2,
        "_source": {
          "foo": "bar"
        }
      }
    ]
  }
}
5

Would this support multiple search terms? I'll still need the ability to search for documents on specific properties along with limiting the ids that get returned

6

You can add whatever clause wherever you want in the bool tree.

7

It looks like this is going to do what I need, thank you so much for the help dadoonet!

8

I'm actually running into a slight hiccup. By specifying additional "must" fields in the query with the "ids" param I am getting unwanted results. I am thinking I need to move the "ids" part of the query into a "filter" so that this doesn't happen?

9

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