请用NEST 7.17.5的库,用c#代码替换以下代码 private static IEnumerable<CountResult>…
- User
请用NEST 7.17.5的库,用c#代码替换以下代码 private static IEnumerable ReadFacets(ISearchResponse queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)) .Cast(); var result = filterTypes .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString())) .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet }) .Select(facet => new CountResult() { FilterType = facet.value, Name = facet.value.ToString(), FilterCounts = facet.termFacet.Items.Select(s => new FilterCount() { Count = (int)s.Count, Id = s.Term }).ToList() }); return result; } private static SearchDescriptor AddFacetsFromAttributeId(SearchDescriptor searchDescriptor, SearchRequest request) { if (!request.ReturnFacets) { return searchDescriptor; }
- Assistant
using Nest; using System; using System.Collections.Generic; using System.Linq;
private static IEnumerable ReadFacets(ISearchResponse queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast(); var result = filterTypes .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString())) .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregation }) .Select(aggregation => new CountResult() { FilterType = aggregation.value, Name = aggregation.value.ToString(), FilterCounts = aggregation.termAggregation.Buckets.Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key }).ToList() }); return result; }
private static SearchDescriptor AddAggregationsFromAttributeId(SearchDescriptor searchDescriptor, SearchRequest request) { if (!request.ReturnFacets) { return searchDescriptor; }
var aggregations = new AggregationContainerDescriptor<SparePartEntity>(); foreach (var filterType in Enum.GetValues(typeof(FilterType)).Cast<FilterType>()) { aggregations.Terms(filterType.ToString(), t => t.Field(f => f.AttributeId)); } searchDescriptor.Aggregations(a => aggregations); return searchDescriptor;}
- User
Buckets属性未找到
- Assistant
请尝试修改代码如下:
private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString())) .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregation }) .Select(aggregation => new CountResult() { FilterType = aggregation.value, Name = aggregation.value.ToString(), FilterCounts = aggregation.termAggregation.Buckets.Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key }).ToList() }); return result; }在这段代码中,我们假设使用了TermsAggregation来聚合结果,并使用Buckets属性来获取聚合桶。请确保在使用时,查询响应中返回了可以聚合的字段,并且使用正确的聚合名称。
- User
DocCount属性没找到
- Assistant
我很抱歉,我之前犯了一个错误。在NEST 7版本中,聚合桶的
DocCount属性已经被重命名为DocCount.Value。请修改代码如下:private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString())) .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregate }) .Select(aggregation => new CountResult() { FilterType = aggregation.value, Name = aggregation.value.ToString(), FilterCounts = aggregation.termAggregation.Buckets.Select(s => new FilterCount() { Count = (int)s.DocCount.Value, Id = s.Key }).ToList() }); return result; }现在,我们使用
DocCount.Value来获取聚合桶的文档计数。希望这次可以正确地访问到Count属性。 - User
aggregation.termAggregation.Buckets中没有Buckets,只有Aggregations
- Assistant
非常抱歉,似乎是我给出了错误的建议。根据您提供的信息,似乎是聚合的结构有所不同。
在这种情况下,可以尝试使用
aggregation.termAggregation.Aggregations属性来获取聚合桶。请将代码修改如下:private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Aggregations != null && queryResponse.Aggregations.ContainsKey(v.ToString())) .Select(value => new { value, termAggregation = queryResponse.Aggregations[value.ToString()] as TermsAggregate }) .Select(aggregation => new CountResult() { FilterType = aggregation.value, Name = aggregation.value.ToString(), FilterCounts = aggregation.termAggregation.Aggregations.Values.OfType<KeyedBucket<object>>().Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key.ToString() }).ToList() }); return result; }这里我们使用了
aggregation.termAggregation.Aggregations.Values来获取聚合桶,并使用KeyedBucket<object>来访问桶中的文档计数和键。希望这次可以正确地获取到聚合桶的信息。 - User
没有termAggregation,只有termFacet
- Assistant
非常抱歉,对于NEST 7.17.5版本,没有对应的
TermAggregation类,但是有TermFacet类可用。因此,您可以将代码修改如下:private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString())) .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet }) .Select(facet => new CountResult() { FilterType = facet.value, Name = facet.value.ToString(), FilterCounts = facet.termFacet.Items.Select(s => new FilterCount() { Count = (int)s.Count, Id = s.Term }).ToList() }); return result; }现在,我们使用
queryResponse.Facets和TermFacet来访问聚合桶的信息。希望这次可以正确地获取到聚合桶的数据。 - User
facet.termFacet.Items中有termFacet,但是没有Items,termFacet里有Aggregations
- Assistant
非常抱歉给出了错误的代码建议。根据您提供的信息,似乎聚合的结构与我之前的假设不同。
基于新的信息,可以尝试使用
termFacet.Aggregations访问聚合桶。请将代码修改如下:private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString())) .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet }) .Select(facet => new CountResult() { FilterType = facet.value, Name = facet.value.ToString(), FilterCounts = facet.termFacet.Aggregations.Values.OfType<KeyedBucket<object>>().Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key.ToString() }).ToList() }); return result; }在这里,我们使用
facet.termFacet.Aggregations.Values来获取聚合桶,并使用KeyedBucket<object>来访问桶中的文档计数和键。希望这次可以正确地获取到聚合桶的信息。 - User
facet.termFacet.Aggregations.Values里没有values
- Assistant
非常抱歉给出了错误的代码建议。根据您提供的信息,似乎聚合的结构与我之前的假设不同。
在这种情况下,可以尝试使用
termFacet.Aggregations.Terms("your_terms_aggregation_name")来访问聚合桶。请将代码修改如下:private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString())) .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet }) .Select(facet => new CountResult() { FilterType = facet.value, Name = facet.value.ToString(), FilterCounts = facet.termFacet.Aggregations.Terms("your_terms_aggregation_name").Buckets.Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key }).ToList() }); return result; }请将"your_terms_aggregation_name"替换为您在查询中使用的实际聚合名称。这将帮助我们访问正确的聚合桶。希望这次可以正确地获取到聚合桶的信息。
- User
acet.termFacet.Aggregations.Terms里没有terms属性,是否可以直接使用aggregation.termFacet.Aggregations.OfType<KeyedBucket>()
- Assistant
非常抱歉之前给出的代码建议不正确。根据您的反馈,确实不能在
termFacet.Aggregations中直接获取聚合桶。请修改代码如下:
private static IEnumerable<CountResult> ReadFacets(ISearchResponse<SparePartEntity> queryResponse) { var filterTypes = Enum.GetValues(typeof(FilterType)).Cast<FilterType>(); var result = filterTypes .Where(v => queryResponse.Facets != null && queryResponse.Facets.ContainsKey(v.ToString())) .Select(value => new { value, termFacet = queryResponse.Facets[value.ToString()] as TermFacet }) .Select(facet => new CountResult() { FilterType = facet.value, Name = facet.value.ToString(), FilterCounts = facet.termFacet.Aggregations.OfType<KeyedBucket<object>>().Select(s => new FilterCount() { Count = (int)s.DocCount, Id = s.Key.ToString() }).ToList() }); return result; }这次使用
facet.termFacet.Aggregations.OfType<KeyedBucket<object>>()来获取聚合桶,并遍历每个桶以获取计数和键。希望这次可以正确地获取到聚合桶的信息。 - User
继续用NEST 7.17.5的库,用c#语言替换以下代码 public SearchDescriptor GetFullDescriptor(SearchRequest request) { var sd = new SearchDescriptor().Skip(request.Skip).Take(request.Take);
var searchText = string.IsNullOrWhiteSpace(request.DynamicText) ? "*" : request.DynamicText.ToLower(); var escapedText = EscapeText(searchText); var fuzzySearchText = escapedText; var userInputs = searchText.Split(new[] { " " }, StringSplitOptions.RemoveEmptyEntries); if (userInputs.Count() > 1) { fuzzySearchText = string.Join("~ AND ", userInputs) + "~"; } else { fuzzySearchText += "~"; } //sd = sd.Query(qd => qd // .Bool(bqd => bqd) sd = sd.Query(qd => qd.Filtered(fqd => ApplyFilters(request, fqd) .Query(qdi => { var q = qdi.Prefix(s => s.SparePartId, escapedText, 40) || qdi.Prefix(s => s.Oem, escapedText, 39) || qdi.Prefix(s => s.NamePrefix, escapedText, 3) || qdi.QueryString(mmqd => mmqd.Query(fuzzySearchText).OnFields(new[] { "_all" })) || qdi.QueryString(mmqd => mmqd.Query("\"" + escapedText + "\"").OnFields(new[] { "_all" }).Boost(3)) || qdi.QueryString(qsd => { qsd.FuzzyMinimumSimilarity(0.7).FuzzyPrefixLength(0) .Query(fuzzySearchText) .OnFieldsWithBoost(fd => fd.Add(s => s.SparePartId, 5) .Add(s => s.Oem, 5) .Add(s => s.Name, 2) .Add(s => s.ProductLineNamesAnalyzed, 2) .Add(s => s.Bom, 6)); }); //var boosts = new int[] { 20, 6, 4 }; //var index = 0; //foreach (var str in userInputs.Take(3)) //{ // q = q || qdi.Wildcard(s => s.Name, str, boosts[index++]); //} return q; }))); if (request.OrderbyFilter != null) { //sd = sd.SortDescending(s => s.IsRepkit); sd = sd.Sort(s => { var order = request.OrderbyFilter.Direction == OrderDirection.Ascending ? SortOrder.Ascending : SortOrder.Descending; s = s.Order(order); switch (request.OrderbyFilter.Field) { case SortField.Relevance: s = s.OnField("_score"); break; case SortField.IdNumber: s = s.OnField(sp => sp.SparePartId); break; case SortField.Name: s = s.OnField("name.sort"); break; //case SortField.PartsGroup: // s = s.OnField("groupNames.sort"); // break; case SortField.AssemblyGroup: s = s.OnField("assemblyGroupNames"); s = s.Mode(SortMode.Min); break; default: throw new ArgumentOutOfRangeException(); } return s; }); if (request.OrderbyFilter.Field == SortField.AssemblyGroup) { sd = sd.Sort(s => { var order = request.OrderbyFilter.Direction == OrderDirection.Ascending ? SortOrder.Ascending : SortOrder.Descending; s = s.Order(order); s = s.OnField(sp => sp.SparePartId); return s; }); } } return sd; } - Assistant
请使用以下代码替换前面的代码:
public SearchDescriptor<SparePartEntity> GetFullDescriptor(SearchRequest request) { var sd = new SearchDescriptor<SparePartEntity>().Skip(request.Skip).Take(request.Take); var searchText = string.IsNullOrWhiteSpace(request.DynamicText) ? "*" : request.DynamicText.ToLower(); var escapedText = EscapeText(searchText); var fuzzySearchText = escapedText; var userInputs = searchText.Split(new[] { " " }, StringSplitOptions.RemoveEmptyEntries); if (userInputs.Length > 1) { fuzzySearchText = string.Join("~ AND ", userInputs) + "~"; } else { fuzzySearchText += "~"; } sd = sd.Query(qd => qd .Bool(bqd => bqd.Filter(fqd => ApplyFilters(request, fqd)) .Must(qdi => { var q = qdi.Prefix(s => s.SparePartId, escapedText, 4) || qdi.Prefix(s => s.Oem, escapedText, 4) || qdi.Prefix(s => s.NamePrefix, escapedText, 1) || qdi.QueryString(mmqd => mmqd.Query(fuzzySearchText).Fields(f => f.Field("_all")) ) || qdi.QueryString(mmqd => mmqd.Query("\"" + escapedText + "\"").Fields(f => f.Field("_all")).Boost(3) ) || qdi.QueryString(qsd => qsd.Fuzzy(fsd => fsd .Value(fuzzySearchText) .Fields(fd => fd .Field(s => s.SparePartId).Boost(5) .Field(s => s.Oem).Boost(5) .Field(s => s.Name).Boost(2) .Field(s => s.ProductLineNamesAnalyzed).Boost(2) .Field(s => s.Bom).Boost(6) ) .FuzzyMinimumSimilarity(0.7) .FuzzyPrefixLength(0) ) ); //var boosts = new int[] { 20, 6, 4 }; //var index = 0; //foreach (var str in userInputs.Take(3)) //{ // q = q