using term in elasticsearch for queries

Question

I have downloaded a sample accounts json database from the elasticsearch website.https://www.elastic.co/guide/en/elasticsearch/reference/current/_exploring_your_data.html

I am trying to do some queries on top of it.

For example,

curl -XGET 'http://localhost:9200/bank/account/_count?pretty' -d '{
    "query":{
    "filtered":{
    "filter":{
    "bool":{
    "should":[{"term":{"gender":"M"}},{"term":{"age":35}}]
    }
    }
    }
    }
    }'

getting the output for this correctly with the count.

But If I try like the query below, I am not getting the correct result.

curl -XGET 'http://localhost:9200/bank/account/_count?pretty' -d '{
"query":{
"filtered":{
"filter":{
"bool":{                        
"should":[{"term":{"gender":"F"}},{"term":{"state":"PA"}}]
}             
}               
}                    
}      
}'

I am not getting the correct result.. Is there anything wrong in the query syntax or the way of using it?

Can anyone help here!

Which is the correct result? What do you expect and what do you get? — davide
– davide, Commented Sep 20, 2016 at 11:20
for example with the gender F and state PA there are results. but still im getting the count as 0. but for the first query, im getting it correctly. — Soundarya Thiagarajan
– Soundarya Thiagarajan, Commented Sep 20, 2016 at 11:21
maybe use "pa" and not "PA". but yes, what are you trying to get here ? — blackmamba
– blackmamba, Commented Sep 20, 2016 at 11:22
Possible duplicate of ElasticSearch not returning results for terms query against string property — davide
– davide, Commented Sep 20, 2016 at 11:33

Community · Accepted Answer · 2017-05-23 11:51:46Z

1

Use lowercase while searching

eg- f not F
    pa not PA

read this for better understanding ElasticSearch not returning results for terms query against string property

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Sep 20, 2016 at 11:27

blackmamba

5563 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

using term in elasticsearch for queries

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