<a href="https://stackoverflow.com/questions/28538760/elasticsearch-bool-query-combine-must-with-or">https://stackoverflow.com/questions/28538760/elasticsearch-bool-query-combine-must-with-or</a>&nbsp;다음과 같이 조회를 하고 싶다고 하자.&nbsp;<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:11.3pt;">SELECT * FROM TEMP WHERE STATUS = 'DONE' AND (NAME = 'foo' OR INFO = 'bar')</pre>&nbsp;&nbsp;아래와 같이 must 안에 bool이 중첩으로 들어갈 수 있다.&nbsp;<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:11.3pt;">GET temp/_search { "query": { "bool": { "must": [ { "term": { "STATUS": "DONE" } }, { "bool": { "should": [ { "term": { "NAME": "foo" } }, { "term": { "INFO": "bar" } } ] } } ] } } }</pre>&nbsp;&nbsp;또는 필터를 사용할 수도 있을 것 같다.<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:11.3pt;">GET temp/_search { "from": 0, "size": 2147483647, "query": { "bool": { "must": [ { "term": { "STATUS": "DONE" } } ], "filter": [ { "bool": { "should": [ { "terms": { "NAME": ["foo"] } }, { "terms": { "INFO": ["bar"] } } ] } } ] } }, "sort": [{ "createTime": { "order": "asc" } }] }</pre>&nbsp;&nbsp;&nbsp;<hr>&nbsp;template에서는 다음과 같이 필터를 사용했다.&nbsp;<pre style="background-color:#2b2b2b;color:#a9b7c6;font-family:'D2Coding',monospace;font-size:11.3pt;">resultdBoolQueryBuilder = QueryBuilders.boolQuery() .should(QueryBuilders.termsQuery("id", idList)) .should(QueryBuilders.termsQuery("parentId.keyword", idList)); BoolQueryBuilder boolQueryBuilder = QueryBuilders.boolQuery() .must(QueryBuilders.termQuery("sessionId", sessionId)) .filter(resultdBoolQueryBuilder); Query resultQuery = new NativeSearchQueryBuilder() .withQuery(boolQueryBuilder) .withPageable(Pageable.ofSize(Integer.MAX_VALUE)) .withSort(SortBuilders .fieldSort("createTime") .order(SortOrder.ASC)) .build(); SearchHits&lt;QnaMessage&gt; resultQnaMessage = elasticsearchOperations .search(resultQuery, QnaMessage.class, IndexCoordinates.of(INDEX_QNA_PREFIX));</pre>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

AND와 OR가 함께 들어간 쿼리 작성하기