Query string embeded with bool query

Question

HI iam using the following query with bool must

{
  "query": { 
  "bool" : {
    "must" : [ {
      "match" : {
        "orgid" : {
          "query" : 13831,
          "type" : "boolean"
        }
      }
    }, {
      "query_string" : {
        "query" : "*07* AND *fres*"
      }
    } ]
  }
}
}

It's hitting null even though there documents with org id as 13831 & in documents there is one data in all fields as 07 and fres.Is anything wrong in this query

paqash · Accepted Answer · 2017-02-27 10:19:52Z

1

Edit: A problem might be you're using a match query instead of a term query. Term queries are used for exact matches. The following will filter the result set to only the org_id you want, and it will then look for 07 and fres. Please give it a try.

"query": {
    "bool" : {
      "must" : {
        "query_string" : {
          "query" : "*07* AND *fres*"
         }
      },
      "filter": {
        "term" : { "orgid" : 13831 }
      }
    }
  }

edited Feb 27, 2017 at 10:19

answered Feb 27, 2017 at 9:51

paqash

2,3141 gold badge20 silver badges22 bronze badges

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

4 Comments

prasad kp Over a year ago

Thanks for your suggestion, but my need is to get the documents with orgid:13831 AND that document must also contain characters like 07 AND fres in any of the fields in that document

prasad kp Over a year ago

if i wrote the above query as "orgid" : 13831 } it will return all the documents in which orgid is 13831 but how about the 07 AND fres condition

paqash Over a year ago

I didn't say to remove the other condition. What does this return:

{   "query": {    "bool" : {     "must" : [ {       "match" : {         "orgid" : 13831       }     }, {       "query_string" : {         "query" : "*07* AND *fres*"       }     } ]   } } }

prasad kp Over a year ago

Thanks, pqqash.....Both query worked i was checking with wrong orgId,even my query was fine it was just a wrong orId ,Thank for your help

Collectives™ on Stack Overflow

Query string embeded with bool query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related