# Special Character in query - Kibana

**URL:** <https://discuss.elastic.co/t/special-character-in-query-kibana/128108>\
**Category:** Kibana\
**Created:** [April 16, 2018, 6:46am UTC](https://discuss.elastic.co/t/special-character-in-query-kibana/128108 "2018-04-16T06:46:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SonChu](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SonChu](https://discuss.elastic.co/u/SonChu)\
**Post date:** [April 16, 2018, 6:46am UTC](https://discuss.elastic.co/t/special-character-in-query-kibana/128108/1 "2018-04-16T06:46:48Z")

</div>

Hi There,

I am looking for a way to search in Kibana with special characters. I have a field with plaintext json as value like:  
{"Total":2,"Data":[{"CompareName":"demo","CompareIsActive":true},"CompareName":"demo","CompareIsActive":false}]}

I want to search on Kibana with keyword: "Total":2 but i always receive error or no data returned.

Please advise.

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)\
**Post date:** [April 16, 2018, 1:02pm UTC](https://discuss.elastic.co/t/special-character-in-query-kibana/128108/2 "2018-04-16T13:02:03Z")

</div>

I would suggest looking into what Elasticsearch is doing with that field when the document is indexed. I think the default analyzer might strip out the quotation marks when it is creating tokens. I might also suggest that it would work out better to treat those plaintext json fields as their own documents and to index those separately. This would allow you to do field searches on the data like what you are trying to do.

---

<div class="post-metadata">

**Author:** ![SonChu](https://avatars.discourse-cdn.com/v4/letter/s/a698b9/32.png) [@SonChu](https://discuss.elastic.co/u/SonChu)\
**Post date:** [April 16, 2018, 5:42pm UTC](https://discuss.elastic.co/t/special-character-in-query-kibana/128108/3 "2018-04-16T17:42:37Z")

</div>

Hi Bill,

Thanks a lot for your reply. As far as I checked in json content, the data in json body is like "{"Total":2,"Data..}"

I have tried to searched with escapse character and no escapse character but no luck. The query just match in case of absolutely search, likely search is not.

Could you please advise?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 14, 2018, 5:43pm UTC](https://discuss.elastic.co/t/special-character-in-query-kibana/128108/4 "2018-05-14T17:43:09Z")

</div>

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