в таблице всего 6 записей { "query": { "bool": { "must": [ { "term": { "meta_key.normalized": "Content" } } ] } } } { "meta_key.normalized": "Content" } содержится только у некоторых поэтому получаю 4 записи { "query": { "bool": { "must": [ { "term": { "meta_values.normalized": "Text" …

Hi there, you can add both as individual must clauses to your boolean query.

how to make notes in the first request from the second

I assume you mean you want to exclude the content. Add an exists query as a must_not clause to the boolean query.

{ "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

{ "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"…

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 docs should be helpful here. Also, you're doing a bunch of stuff with wildcards etc. that aren't related to the original questio…

{ "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"…

Not sure what to tell you about your calling code other than to point out that we have a .NET client .

Как сделать правельно запро в котором исключаются одни записи из других

Elastic Search

Kathleen_DeRusso (Kathleen DeRusso) January 23, 2024, 3:00pm 6

Your must_not clause is a term query, don't you want an exists query?

Topic		Replies	Views
Must_not field exists query returning documents with those fields excluded Elasticsearch	2	1562	May 18, 2018
Using must and must_not on same field Elasticsearch	2	2331	October 22, 2018
Must_not but include some data Elasticsearch	1	415	February 18, 2020
Excluding multiple documents from query Elasticsearch	3	11872	February 3, 2014
Problem Using 'must_not' to Exclude Matches Elasticsearch	4	1887	March 13, 2020

Как сделать правельно запро в котором исключаются одни записи из других

Related topics