1

I want to display all entries of an elasticsearch database with kibana, that contain the special character @. To be more specific, I search for that in the field friendly_name.

I have tried the following:

*@
*\@
*"\@"*
friendly_name:*@
friendly_name:*\@
friendly_name:*"\@"*

Neither one of those worked, I also found pages like: https://lucene.apache.org/core/2_9_4/queryparsersyntax.html#Escaping%20Special%20Characters

which tell to escape special characters with '\', which does not work here, apparently.

s1st
  • 31
  • 2
  • 5
  • possible duplicate of [ElasticSearch searching with hyphen inside a word](http://stackoverflow.com/questions/31301849/elasticsearch-searching-with-hyphen-inside-a-word) – Andrei Stefan Jul 09 '15 at 13:55
  • Kibana uses `query_string` behind the scene, thus why marking this as a duplicate. Matching `-` or `@` is the same. – Andrei Stefan Jul 09 '15 at 13:57

2 Answers2

1

As per Apache Lucene documentation of query syntax @ is not a part of special characters group, therefore we cannot search for @ in Kibana as well.

Special characters allowed are:-

Special characters: + – & || ! ( ) { } [ ] ^ ” ~ * ? : \

Yuvraj Gupta
  • 2,475
  • 16
  • 26
0

I would give the following a try:

friendly_name:"@"

Let me know if it works.

mathakoot
  • 1,692
  • 2
  • 14
  • 26
  • I tried it too. Doesn't work. I wanted to put that as a comment but didn't have enough reputation so had to put as an answer!! :/ – mathakoot Jul 14 '15 at 15:20