# Potential issue with bool and nested term
**URL:** https://discuss.elastic.co/t/potential-issue-with-bool-and-nested-term/204413
**Category:** Elasticsearch
**Created:** [October 21, 2019, 8:31am UTC](https://discuss.elastic.co/t/potential-issue-with-bool-and-nested-term/204413 "2019-10-21T08:31:00Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Spansh](https://discuss.elastic.co/u/Spansh)
#### Post date: [October 21, 2019, 8:31am UTC](https://discuss.elastic.co/t/potential-issue-with-bool-and-nested-term/204413/1 "2019-10-21T08:31:00Z")
I think I have found an issue with arrays of nested fields and bool matching.
I have a nested field which has multiple values where I want to search for records which have multiple values within it. If I search for a single value, it works fine. If I search for multiple values it does not.
I think I've created a somewhat minimal test case below.
```auto
curl -X PUT "localhost:9200/nested_bool?pretty=true&refresh=true" -H 'Content-Type: application/json' -d'
{
"mappings": {
"properties": {
"export_commodities": {
"type": "nested",
"properties": {
"name": { "type": "text", "fields": { "keyword": { "type": "keyword" } } }
}
}
}
}
}
'
curl -X POST "localhost:9200/nested_bool/_doc/?pretty" -H 'Content-Type: application/json' -d'
{
"export_commodities" : [{"name": "Hydrogen Fuel"},{"name": "Animal Monitors"}]
}
'
curl -X POST "localhost:9200/nested_bool/_doc/?pretty" -H 'Content-Type: application/json' -d'
{
"export_commodities" : [{"name": "Hydrogen Fuel"},{"name": "Biowaste"}]
}
'
curl -X POST "localhost:9200/nested_bool/_doc/?pretty" -H 'Content-Type: application/json' -d'
{
"export_commodities" : {"name":" Biowaste"}
}
'
curl -X POST "localhost:9200/nested_bool/_doc/?pretty" -H 'Content-Type: application/json' -d'
{
"export_commodities" : [{"name": "Platinum"},{"name": "Animal Monitors"}]
}
'
```
This search returns nothing
```auto
curl -H 'Content-Type: application/json' -X GET "http://localhost:9200/nested_bool/_search?pretty=true&size=10" -d '
{
"query": {
"nested": {
"path": "export_commodities",
"query": {
"bool": {
"filter": [
{
"term": {
"export_commodities.name.keyword": "Animal Monitors"
}
},
{
"term": {
"export_commodities.name.keyword": "Hydrogen Fuel"
}
}
]
}
}
}
}
}
'
```
This search returns as expected
```auto
curl -H 'Content-Type: application/json' -X GET "http://localhost:9200/nested_bool/_search?pretty=true&size=10" -d '
{
"query": {
"nested": {
"path": "export_commodities",
"query": {
"bool": {
"filter": [
{
"term": {
"export_commodities.name.keyword": "Hydrogen Fuel"
}
}
]
}
}
}
}
}
'
```
I'm happy to register an issue on github, but I thought it would be best to ask here first in case I've missed something really obvious.
---
### Author:  [@Glen\_Smith](https://discuss.elastic.co/u/Glen_Smith)
#### Post date: [October 21, 2019, 7:55pm UTC](https://discuss.elastic.co/t/potential-issue-with-bool-and-nested-term/204413/2 "2019-10-21T19:55:23Z")
Try this instead:
```auto
GET /nested_bool/_search
{
"query": {
"bool": {
"filter": [
{
"nested": {
"path": "export_commodities",
"query": {
"term": {
"export_commodities.name.keyword": "Animal Monitors"
}
}
}
},
{
"nested": {
"path": "export_commodities",
"query": {
"term": {
"export_commodities.name.keyword": "Hydrogen Fuel"
}
}
}
}
]
}
}
}
```
---
### Author:  [@Spansh](https://discuss.elastic.co/u/Spansh)
#### Post date: [October 22, 2019, 7:58am UTC](https://discuss.elastic.co/t/potential-issue-with-bool-and-nested-term/204413/3 "2019-10-22T07:58:52Z")
Yep that works, a little counter intuitive since the singular works but at least I can get around it. Is it worth registering an issue on github about it or is it "working as intended"?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 19, 2019, 7:58am UTC](https://discuss.elastic.co/t/potential-issue-with-bool-and-nested-term/204413/4 "2019-11-19T07:58:58Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.