Nested boolean query in elasticsearch

Question

I have an sql query like

select student_name,roll_number 
from
mytable
where
(course = 'CCNA' or course = 'MCSE') and course NOT Like '%network%'

How can i create an equivalent nested boolean query in elasticsearch?

Refer bool-query: elastic.co/guide/en/elasticsearch/reference/current/… — Praneeth
– Praneeth, Commented Apr 3, 2018 at 16:37

Sagar Vaghela · Accepted Answer · 2018-04-04 05:53:55Z

Below query might help you, This query responds with records which course does not contain a "network" keyword and course has a value "ccna" or "mcse". I have not considered a case sensitiveness feature here and assumed that you have a default mapping.

POST study-doc*/_search
{
"query": {
    "bool": {
        "must": [
           {
               "bool": {
                   "should": [
                      {
                          "term": {
                             "course": {
                                "value": "ccna"
                             }
                          }
                      },{
                          "term": {
                             "course": {
                                "value": "msce"
                             }
                          }
                      }
                   ]
               }},
               {
               "bool": {
                    "must": [
                       {
                           "wildcard": {
                              "course.keyword": {
                                 "value": "^((?!network).)*$"
                              }
                           }
                       }
                    ]    
               }
           }

        ]
    }
}
}

Collectives™ on Stack Overflow

Nested boolean query in elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related