# Java driver - Filter queries migration
**URL:** https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499
**Category:** Elasticsearch
**Created:** [July 13, 2021, 7:53am UTC](https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499 "2021-07-13T07:53:16Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Leuteris](https://discuss.elastic.co/u/Leuteris)
#### Post date: [July 13, 2021, 7:53am UTC](https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499/1 "2021-07-13T07:53:16Z")
I need to translate my filter / query syntax (Elasticsearch 1.4) to Elasticsearch 7.x syntax. For `FilterBuilders.andFilter` I found that I should use `boolquery()` with filter clause and it works. But what about` FilterBuilders.orFilter`?
`FilterBuilders.boolFilter().must(nestedFilters)` translated to `QueryBuilders.boolQuery().must(nestedQueries)`
`FilterBuilders.andFilter(nestedFilters))` translated to `QueryBuilders.boolQuery().filter(nestedQueries)`
`FilterBuilders.boolFilter().should(nestedFilters)` translated to `QueryBuilders.boolQuery().should(nestedQueries)`
`FilterBuilders.orFilter(nestedFilters)` translated to ?
Thanks
---
### Author:  [@spinscale](https://discuss.elastic.co/u/spinscale)
#### Post date: [July 13, 2021, 2:10pm UTC](https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499/2 "2021-07-13T14:10:29Z")
The trick is to have a bool query, that does not contain anything in the `must`, `must_not` and `filter` parts, but only in the `should` clause. In that case this is considered an or... like this
```auto
DELETE test
PUT test/_doc/1
{
"brand" : "Nike"
}
PUT test/_doc/2
{
"brand" : "Puma"
}
GET test/_search
{
"query": {
"bool": {
"filter": [
{
"bool": {
"should" : [
{ "term" : {"brand.keyword":"Nike"}},
{ "term" : {"brand.keyword":"Puma"}}
]
}
}
]
}
}
}
```
---
### Author:  [@Leuteris](https://discuss.elastic.co/u/Leuteris)
#### Post date: [July 13, 2021, 4:14pm UTC](https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499/3 "2021-07-13T16:14:02Z")
Thanks Alexander. My understanding is that the following clause will be scored by ES since `should` is executed in [query context](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-filter-context.html). Is this true?
```auto
"bool": {
"should" : [
{ "term" : {"brand.keyword":"Nike"}},
{ "term" : {"brand.keyword":"Puma"}}
]
}
```
---
### Author:  [@spinscale](https://discuss.elastic.co/u/spinscale)
#### Post date: [July 14, 2021, 8:30am UTC](https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499/4 "2021-07-14T08:30:29Z")
Just run the above and check the scores... it's within the `filter` context already (that's why there are two `bool` queries).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 11, 2021, 8:30am UTC](https://discuss.elastic.co/t/java-driver-filter-queries-migration/278499/5 "2021-08-11T08:30:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.