I'm using Query bar (at the top of Kibana) to search like this:
bin: 123456*
I get a lot of hits, however when I add filter; bin -> is -> 123456*, I get 0 hits (No results found), bin field contains 6 OR 7 numbers and I'd like to include 6 AND 7 numbers results into my filter.
I apologize for confusion, let me try to put it in a different way:
search #1:
I put bin: 123456* into Query Bar - got plenty of results
search #2:
I tried to create a filter to accomplish same as method #1 by Add a filter (UNDER Query Bar), then in Filter drop down select bin followed by is as operator and for value I entered 123456* and got no results.
bin field is a keyword type field that contains following bins: 123456, 1234560, 1234561, 1234562 ... 1234569 (in different documents of course) and I'd like to capture all of them without specifying each (using operator is one of).
When you select a keyword to filter on, Kibana tries to give you a list of keywords to select from and then creates a query to match phrase. Apparently you can still edit it and add a wildcard.
But according to this page, (go to the very bottom of the page in the box) you can't use wildcards in a phrase match query. https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-match-query.html
Actually, you can use wildcards but they're either ignored completely or they are trying to match the literal string 123456* with an asterisk in it.
Compare that with the query you get if you put the query in the query bar;
I couldn't get wildcard to work through Query bar and if I understand correctly, it's simply not possible to do (to me, wildcard is "a must", apparently not).
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.