Or like in and

Elastic Stack Elasticsearch
4

Please format your code using </> icon as explained in this guide. It will make your post more readable.

Or use markdown style like:

```
CODE
```

I edited your post.

The sample query you pasted does not really look like to the one you asked for.

Was:

WHERE (colD like 'abc%' OR colC like '%abc%') AND (colA IN ('a','b') OR colB IN ('a','b'))

And you wrote something with hil* and colA=10216.

Let me give you some advices:

  • Don't use wildcards
  • Use the bool query. or clauses can be translated as should clauses. and clauses can be translated as must clauses.
  • You can use bool queries inside bool queries. Here I'd write something like (not tested):
{
  "query": {
    "bool": {
      "must": [
        {
          "bool": {
            "should": [
              {
                "wildcard": { "colD": "'abc%" } 
              },{
                "wildcard": { "colC": "'%abc%" } 
              }
            ]
          }
        }, {
          "bool": {
            "should": [
              {
                 // colA IN ('a','b')
              },{
                 // colB IN ('a','b')
              }
            ]
          }
        }
      ]
    }
  }
}

If you need more help, please provide a full recreation script as described in

It will help to better understand what you are doing.
Please, try to keep the example as simple as possible.