Hi,

I have some document fields with value like "CLOUD_TYPE": "AWS-EC2"

I'm trying below query to get the results, but it's giving me 0 values. 
Please let me know the correct way to fetch the query

POST /aricloud/_search
{
    "query": {
        "filtered": {
           "query": {
           "bool": {
              "must": [
                 {
                     "match": {
                        "NODE_STATUS": "ACTIVE"
                     }
                  },
                  {
                      "constant_score": {
                         "filter": {
                         "term": {
                            "CLOUD_TYPE": "\"aws\"-ec2"
                         }
                         },
                         "boost": 1.2
                      }
                  }
                  
              ] ,
              "must_not": [
                 {
                   "term": {
                     "NODE_ID": {
                      "value": "12235"
                    }
                }     
                 }
              ],
              "should": [
                 {
                    "term": {
                       "NODE_STATUS": {
                          "value": "active"
                       }
                    } 
                 }
              ]
           }
           },
           "filter": {
               "range": {
                  "NODE_CREATE_TIME": {
                     "from": "2014-03-14 16:20:35",
                     "to": "2014-03-14 18:43:55"
                  }
               }
           }
        }
    },
    "sort": [
       {
          "NODE_ID": {
             "order": "desc"
          }
       }
    ]
}

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/fa712488-e8b1-4cc8-93c2-2029c4054558%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to