# Как сделать правельно запро в котором исключаются одни записи из других
**URL:** https://discuss.elastic.co/t/topic/351560
**Category:** Elastic Search
**Tags:** elastic-app-search
**Created:** [January 22, 2024, 3:30pm UTC](https://discuss.elastic.co/t/topic/351560 "2024-01-22T15:30:49Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@vsemirmd](https://discuss.elastic.co/u/vsemirmd)
#### Post date: [January 22, 2024, 3:30pm UTC](https://discuss.elastic.co/t/topic/351560/1 "2024-01-22T15:30:50Z")
в таблице всего 6 записей
{
"query": {
"bool": {
"must": [
{ "term": { "meta\_key.normalized": "Content" } }
]
}
}
}
{ "meta\_key.normalized": "Content" } содержится только у некоторых поэтому получаю 4 записи
{ "query": {
"bool": {
"must": [
{ "term": { "meta\_values.normalized": "Text" } }
]
}
}
}
{ "meta\_values.normalized": "Text" } содержится у всех поэтому у меня по этому запросу получается 6 записей как мне получить все записи у которых есть { "meta\_values.normalized": "Text" } но отсутствует { "term": { "meta\_key.normalized": "Content" } }
---
### Author:  [@Kathleen\_DeRusso](https://discuss.elastic.co/u/Kathleen_DeRusso)
#### Post date: [January 22, 2024, 3:47pm UTC](https://discuss.elastic.co/t/topic/351560/2 "2024-01-22T15:47:02Z")
Hi there, you can add both as individual `must` clauses to your boolean query.
---
### Author:  [@vsemirmd](https://discuss.elastic.co/u/vsemirmd)
#### Post date: [January 22, 2024, 4:32pm UTC](https://discuss.elastic.co/t/topic/351560/3 "2024-01-22T16:32:42Z")
how to make notes in the first request from the second
---
### Author:  [@Kathleen\_DeRusso](https://discuss.elastic.co/u/Kathleen_DeRusso)
#### Post date: [January 22, 2024, 5:55pm UTC](https://discuss.elastic.co/t/topic/351560/4 "2024-01-22T17:55:08Z")
I assume you mean you want to exclude the content. Add an [exists](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-exists-query.html) query as a `must_not` clause to the boolean query.
---
### Author:  [@vsemirmd](https://discuss.elastic.co/u/vsemirmd)
#### Post date: [January 23, 2024, 7:43am UTC](https://discuss.elastic.co/t/topic/351560/5 "2024-01-23T07:43:02Z")
{
"query": {
"bool": {
"must": [
{ "term": { "meta\_values.normalized": "Text" } }
],
"must\_not": [
{ "term": { "meta\_key.normalized": "Content" } }
]
}
}
}
I make a query like this and it returns all 6 records but there should be 2
---
### Author:  [@Kathleen\_DeRusso](https://discuss.elastic.co/u/Kathleen_DeRusso)
#### Post date: [January 23, 2024, 3:00pm UTC](https://discuss.elastic.co/t/topic/351560/6 "2024-01-23T15:00:18Z")
Your must\_not clause is a term query, don't you want an exists query?
---
### Author:  [@vsemirmd](https://discuss.elastic.co/u/vsemirmd)
#### Post date: [January 23, 2024, 3:54pm UTC](https://discuss.elastic.co/t/topic/351560/7 "2024-01-23T15:54:09Z")
{
"size": 0,
"query": {
"bool": {
"should": [
{
"bool": {
"must": [
{ "match": { "meta\_key.normalized": "Asset Type" } },
{ "wildcard": { "meta\_values.normalized": "Text" } }
]
}
},
{
"bool": {
"must\_not": [
{ "match": { "meta\_key.normalized": "Content" } }
]
}
}
]
}
},
"aggs": {
"id": {
"terms": {
"field": "id",
"size": 500
},
"aggs": {
"the\_filter": {
"bucket\_selector": {
"buckets\_path": { "the\_doc\_count": "\_count" },
"script": "params.the\_doc\_count == 2"
}
}
}
}
}
}
So I made the following request where I select all assets that have Asset Type Text and that do not have Content, but it doesn’t give me the same results
---
### Author:  [@Kathleen\_DeRusso](https://discuss.elastic.co/u/Kathleen_DeRusso)
#### Post date: [January 23, 2024, 4:08pm UTC](https://discuss.elastic.co/t/topic/351560/8 "2024-01-23T16:08:58Z")
I don't understand why you're nesting your boolean must\_not query under the must clauses instead of creatin a must\_not clause in the same boolean query. The [boolean query](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html) docs should be helpful here.
Also, you're doing a bunch of stuff with wildcards etc. that aren't related to the original question. Keep it as simple as possible. Also make sure that your mappings are correct (text vs. keyword).
---
### Author:  [@vsemirmd](https://discuss.elastic.co/u/vsemirmd)
#### Post date: [January 24, 2024, 12:55pm UTC](https://discuss.elastic.co/t/topic/351560/9 "2024-01-24T12:55:54Z")
{
"size": 0,
"aggs": {
"grouped\_by\_id": {
"terms": {
"field": "id",
"size": 100
},
"aggs": {
```
"content_count": {
"sum": {
"script": {
"source": "doc['meta_key'].value == 'Content' ? 1 : 0"
}
}
},
"filter_no_content": {
"bucket_selector": {
"buckets_path": {
"contentCount": "content_count"
},
"script": "params.contentCount == 0"
}
}
}
}
```
}
}
I made a working request as I need it
but if I try to play it in C#
SELECT \* FROM mediaassets.assetmetadata WHERE es\_query='{"size": 0, "aggs": { "grouped\_by\_id": { "terms": { "field": "id", "size": 1000 }, "aggs": { "content\_count": { "sum": { "script": { "source": "doc['meta\_key'].value == 'Content' ? 1 : 0" } } }, "filter\_no\_content": { "bucket\_selector": { "buckets\_path": { "contentCount": "content\_count" }, "script": "params.contentCount == 0" } } } } AND es\_options='indices=assetmetadata\*' ALLOW FILTERING';
I get this error, tell me how to write it correctly
line 1:205 mismatched input 'meta\_key' expecting EOF (... mediaassets.assetmetadata WHERE es\_query='{"size": 0, "aggs": { "grouped\_by\_id": { "terms": { "field": "id", "size": 1000 }, "aggs": { "content\_count": { "sum": { "script": { "source": "doc['[meta\_key]...)
---
### Author:  [@Kathleen\_DeRusso](https://discuss.elastic.co/u/Kathleen_DeRusso)
#### Post date: [January 24, 2024, 2:26pm UTC](https://discuss.elastic.co/t/topic/351560/10 "2024-01-24T14:26:35Z")
Not sure what to tell you about your calling code other than to point out that we have a [.NET client](https://www.elastic.co/guide/en/elasticsearch/client/net-api/current/introduction.html).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 21, 2024, 2:27pm UTC](https://discuss.elastic.co/t/topic/351560/11 "2024-02-21T14:27:28Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.