If at all possible, denormalize the data.... But you can also use Solr's Join capability here, see: https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-JoinQueryParser
Best, Erick On Mon, Aug 8, 2016 at 8:47 AM, Pithon Philippe <ppithon.si...@gmail.com> wrote: > Hello, > I have two documents type : > - tickets (type_s:"ticket", customerid_i:10) > - customers (type_s:customer,customerid_i:10,name_s:"FISHER" ) > > I want a query to find all tickets for name customer FISHER > In document ticket (type_s:"ticket") , I have id customer but not name > customer... > > Any ideas ??? > > Thanks