Link Search Menu Expand Document Documentation Menu

You're viewing version 2.13 of the OpenSearch documentation. This version is no longer maintained. For the latest version, see the current documentation. For information about OpenSearch version maintenance, see Release Schedule and Maintenance Policy.

Boolean field type

A Boolean field type takes true or false values, or "true" or "false" strings. You can also pass an empty string ("") in place of a false value.

Example

Create a mapping where a, b, and c are Boolean fields:

PUT testindex
{
  "mappings" : {
    "properties" :  {
      "a" : {
        "type" : "boolean"
      },
      "b" : {
        "type" : "boolean"
      },
      "c" : {
        "type" : "boolean"
      }
    }
  }
}

Index a document with Boolean values:

PUT testindex/_doc/1 
{
  "a" : true,
  "b" : "true",
  "c" : ""
}

As a result, a and b will be set to true, and c will be set to false.

Search for all documents where c is false:

GET testindex/_search 
{
  "query": {
      "term" : {
        "c" : false
    }
  }
}

Parameters

The following table lists the parameters accepted by Boolean field types. All parameters are optional.

Parameter Description
boost A floating-point value that specifies the weight of this field toward the relevance score. Values above 1.0 increase the field’s relevance. Values between 0.0 and 1.0 decrease the field’s relevance. Default is 1.0.
doc_values A Boolean value that specifies whether the field should be stored on disk so that it can be used for aggregations, sorting or scripting. Default is true.
index A Boolean value that specifies whether the field should be searchable. Default is true.
meta Accepts metadata for this field.
null_value A value to be used in place of null. Must be of the same type as the field. If this parameter is not specified, the field is treated as missing when its value is null. Default is null.
store A Boolean value that specifies whether the field value should be stored and can be retrieved separately from the _source field. Default is false.

Boolean values in aggregations and scripts

In aggregations on Boolean fields, key returns numeric values (1 for true or 0 for false), and key_as_string returns strings ("true" or "false"). Scripts return true and false for Boolean values.

Example

Run a terms aggregation query on the field a:

GET testindex/_search
{
  "aggs": {
    "agg1": {
      "terms": {
        "field": "a"
      }
    }
  },
  "script_fields": {
    "a": {
      "script": {
        "lang": "painless",
        "source": "doc['a'].value"
      }
    }
  }
}

The script returns the value of a as true, key returns the value of a as 1, and key_as_string returns the value of a as "true":

{
  "took" : 1133,
  "timed_out" : false,
  "_shards" : {
    "total" : 1,
    "successful" : 1,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : {
      "value" : 1,
      "relation" : "eq"
    },
    "max_score" : 1.0,
    "hits" : [
      {
        "_index" : "testindex",
        "_type" : "_doc",
        "_id" : "1",
        "_score" : 1.0,
        "fields" : {
          "a" : [
            true
          ]
        }
      }
    ]
  },
  "aggregations" : {
    "agg1" : {
      "doc_count_error_upper_bound" : 0,
      "sum_other_doc_count" : 0,
      "buckets" : [
        {
          "key" : 1,
          "key_as_string" : "true",
          "doc_count" : 1
        }
      ]
    }
  }
}
350 characters left

Have a question? .

Want to contribute? or .