Hi Walter, It was just an example, I thought it was simpler to explain than my real problem.
thanks, GM On Fri, May 24, 2019 at 4:47 PM Walter Underwood <wun...@wunderwood.org> wrote: > If you are really keeping inventory, use a relational database. Solr is a > really poor choice for this kind of application. > > wunder > Walter Underwood > wun...@wunderwood.org > http://observer.wunderwood.org/ (my blog) > > > On May 24, 2019, at 6:12 AM, Mikhail Khludnev <m...@apache.org> wrote: > > > > It's possible to search for stocks filtering by M, sorting by qty, and > then > > parent docs need to be added to result list. > > Unfortunately, there is no [parent] result transformer. Thus it can be > done > > with generic > > > https://lucene.apache.org/solr/guide/6_6/transforming-result-documents.html#TransformingResultDocuments-_subquery_ > > . > > > > > > On Fri, May 24, 2019 at 3:16 PM Gian Marco Tagliani < > gm.tagli...@gmail.com> > > wrote: > > > >> Hi all, > >> I'm facing a problem with Nested Documents. > >> > >> To illustrate my problem I'll use the example with T-shirts in stock. > >> For every model of a T-shirt, we can have different colors and sizes, > for > >> each combination we have the number of items in stock. > >> > >> In Solr, for every model we have a document, for every combination of > color > >> and size we have a nested child document. > >> > >> > >> model A > >> - color : red, size M, quantity 8 > >> - color : blue, size L, quantity 4 > >> - color : white, size M, quantity 1 > >> > >> model B > >> - color yellow, size S, quantity 7 > >> - color yellow, size M, quantity 3 > >> > >> model C > >> - color red, size M, quantity 5 > >> - color black, size L, quantity 6 > >> > >> > >> I'm interested in size M only, and I want to know our stock ordered by > >> quantity. > >> > >> model A, color red, quantity 8 > >> model C, color red, quantity 5 > >> model B, color yellow, quantity 3 > >> model A, color white, quantity 1 > >> > >> > >> > >> My first idea was using the Json Nested Facet ( > >> > >> > https://lucene.apache.org/solr/guide/json-facet-api.html#nested-facet-example > >> ) > >> In that case I'm not able to sort by quantity nor discriminate between > the > >> "color red" and "color white" lines for model A. > >> > >> My second idea was to use the Analytics Component ( > >> https://lucene.apache.org/solr/guide/analytics.html) > >> In this case I'm not able to get data from father and child document to > >> build a facet. > >> > >> Has any of you encountered a similar problem? Do you have any idea on > how > >> to address my case? > >> > >> > >> Thanks in advance > >> Gian Marco Tagliani > >> > > > > > > -- > > Sincerely yours > > Mikhail Khludnev > >
