Query with match and wildcard

[kay-is (K.)]

I have some tagged images in my Elasticsearch and want to query them with a wildcard and an exact match.

POST images/image
{
  "fileName": "1319410514097402934+test",
  "tags": ["someTag", "someOtherTag"]
}
POST images/_search
{
  "query": {
    "bool": {
      "must": { "wildcard": { "fileName": "*test" },
      "filter": { "match": { "tags": ["someTag"] } }
    }
  }
}

But I'm getting the following error:

{
  "type": "illegal_state_exception",
  "reason": "Can't get text on a START_ARRAY at 1:79"
}

How do I fix this?

[dadoonet (David Pilato)]

Try this:

POST images/_search
{
  "query": {
    "bool": {
      "must": [{ "wildcard": { "fileName": "*test" }],
      "filter": [{ "match": { "tags": ["someTag"] } }]
    }
  }
}

BTW this is scary to run: { "wildcard": { "fileName": "*test" }. Unless you like slow queries, don't do that.

[kay-is (K.)]

Thanks, I will try this

BTW this is scary to run: { "wildcard": { "fileName": "*test" } . Unless you like slow queries, don't do that.

What should I do instead?

[kay-is (K.)]

Your query didn't work.

I'm still getting the array error:

{
    "type": "illegal_state_exception",
    "reason": "Can't get text on a START_ARRAY at 1:82"
}

Sent this:

{
    "query": {
        "bool": {
            "must": [
                {
                    "wildcard": {
                        "fileName": "*test"
                    }
                }
            ],
            "filter": [
                {
                    "match": {
                        "tags": [
                            "no"
                        ]
                    }
                }
            ]
        }
    }
}

[dadoonet (David Pilato)]

The match query is incorrect.

GET _search
{
  "query": {
    "bool": {
      "must": [
        {
          "wildcard": {
            "fileName": "*test"
          }
        }
      ],
      "filter": [
        {
          "match": {
            "tags": "no"
          }
        }
      ]
    }
  }
}

[kay-is (K.)]

I see, so I "have to" use "tags": "no" for one value in the array and "tags": ["no", "people"] for multiple ones?

[dadoonet (David Pilato)]

Multiple match queries I'd say.