summaryrefslogtreecommitdiff
path: root/docs/reference/query-dsl/filters/and-filter.asciidoc
blob: 6f171cf91894a1d1a0572860dab7ee1a5e6f8525 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
[[query-dsl-and-filter]]
=== And Filter

A filter that matches documents using `AND` boolean operator on other
filters. Can be placed within queries that accept a filter.

[source,js]
--------------------------------------------------
{
    "filtered" : {
        "query" : {
            "term" : { "name.first" : "shay" }
        },
        "filter" : {
            "and" : [
                {
                    "range" : { 
                        "postDate" : { 
                            "from" : "2010-03-01",
                            "to" : "2010-04-01"
                        }
                    }
                },
                {
                    "prefix" : { "name.second" : "ba" }
                }
            ]
        }
    }
}
--------------------------------------------------

[float]
==== Caching

The result of the filter is not cached by default. The `_cache` can be
set to `true` in order to cache it (though usually not needed). Since
the `_cache` element requires to be set on the `and` filter itself, the
structure then changes a bit to have the filters provided within a
`filters` element:

[source,js]
--------------------------------------------------
{
    "filtered" : {
        "query" : {
            "term" : { "name.first" : "shay" }
        },
        "filter" : {
            "and" : { 
                "filters": [
                    {
                        "range" : { 
                            "postDate" : { 
                                "from" : "2010-03-01",
                                "to" : "2010-04-01"
                            }
                        }
                    },
                    {
                        "prefix" : { "name.second" : "ba" }
                    }
                ],
                "_cache" : true
            }
        }
    }
}
--------------------------------------------------