Is it possible to search by inner collection?

[ma3yta]

Is it possible to search by inner collection?

[damieng]

This kind of query is not supported at this time but you might be able to get the results you want with a similar query;

_context.Query(c => c.Id == companyId && c.Officer.Contains(term)).AsEnumerable().SelectMany(c => c.Officers)

This basically moves the SelectMany part to LINQ to Objects while retaining the Where criteria on Elasticsearch.

[ma3yta]

@damieng How I can do if Officers is collection of objects? Thank you

_context.Query<Company>().Query(c => c.Id == companyId && c.Officer.Contains(term)).AsEnumerable().SelectMany(c => c.Officers)

[damieng]

Sorry _context.Query(c => c.Id == companyId && c.Officers.Where(o => o.Name.Contains(term))).AsEnumerable().SelectMany(c => c.Officers)

[ma3yta]

@damieng I tried but got error "Enumerable.Where method is not supported"

public IEnumerable<Officer> SearchOfficers(Guid companyId, string term)
        {
            return _context.Query<Company>().Query(c => c.Id == companyId && c.Officers.Where(o => o.Name.Contains(term)).Count() > 0)
                                            .AsEnumerable().SelectMany(c => c.Officers).ToList();
        }

[ma3yta]

@damieng I solved it using nest. thanks for your help

public IEnumerable<Officer> SearchOfficers(Guid companyId, string term)
        {
            var searchResponse = _client.Search<Company>(s => s
                                            .Source(false)
                                            .Query(q => q.MatchAll())
                                              .Query(f => f.Nested(nf => nf
                                                .InnerHits()
                                                .Path(p => p.Officers)
                                                .Query(qq => qq.Match(m => m.Field(c => c.Officers.First().Name).Query(term))))));

            return searchResponse.Hits?.SelectMany(h => h.InnerHits.Values.SelectMany(v => v.Documents<Officer>()));
        }