Can't escape single quote in json input in kibana visualization

[WAFA_Mardiney]

I'm using kibana data table visualization and i need to make an aggregation that counts all fields that contains a specific message THAT contains single-quote, the problem is that i'm using painless lang in json input field and I can't escape this single quote, i've tried backslash and double single-quotes but nothing worked, here is an example of what i have:

{
"script": {
"inline": "doc['<field name>'].value == 'I can't escape single quote' ? 1 : 0", 
"lang": "painless"
}
}

[tiagocosta]

@WAFA_Mardiney have u tried to do something like ?

...
"inline": 'doc["<field name>"].value == "I can't escape single quote" ? 1 : 0', 
....

There is also some mentions to examples here https://www.elastic.co/guide/en/elasticsearch/painless/current/painless-literals.html#string-literals

[WAFA_Mardiney]

hi @tiagocosta,I tried the way you mentioned but it didn't work also i tried using backslash and all I get is error in json input like this:

[tiagocosta]

Have you tried to escape every single quote you have inside the main double quote string?

[WAFA_Mardiney]

thanks @tiagocosta for your replies, and yes i tried that also but nothing worked unfortunately.

[tiagocosta]

@markov00 do you have any idea here?

[markov00 (Marco Vettorello)]

Hi, could you please try:

{
  "script": {
    "inline": "doc['<field name>'].value == \"I can't escape single quote\" ? 1 : 0", 
    "lang": "painless"
  }
}

you should just escape double quote around your string

[WAFA_Mardiney]

Thank you @markov00 and @tiagocosta , finally!! it worked.