Query DSL regexp pattern doesn't work with some strings

Question

I have a pattern ".TP-V." which returns strings like "SSTP-VPN". But the pattern ".SSH." Does not return anything, although there are lines like "core:Login:SSH:Cisco". I have no idea what pattern is need.

I would strongly suggest to use the new wildcard field type for this purpose as regular expression are not performant at all: elastic.co/blog/…. Also see this answer: stackoverflow.com/questions/66672162/… — Val
– Val, Commented Jun 17, 2021 at 8:27

Bhavya · Accepted Answer · 2021-06-17 08:15:31Z

1

You need to use ".*SSH.*" instead of ".SSH.". Adding a working example -

Index Data:

{
    "name":"core:Login:SSH:Cisco"
}
{
    "name":"SSTP-VPN"
}

Search Query:

{
  "query": {
    "regexp": {
      "name.keyword": {
        "value": ".*SSH.*"
      }
    }
  }
}

Search Result:

"hits": [
      {
        "_index": "68015371",
        "_type": "_doc",
        "_id": "2",
        "_score": 1.0,
        "_source": {
          "name": "core:Login:SSH:Cisco"
        }
      }
    ]

Search Query:

{
  "query": {
    "regexp": {
      "name.keyword": {
        "value": ".*TP-V.*"
      }
    }
  }
}

answered Jun 17, 2021 at 8:15

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query DSL regexp pattern doesn't work with some strings

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related