Re: My problem with T-shirts and nested documents

2019-05-27 Thread Walter Underwood
If it really is a search problem, without transactional updates, I’d flatten and denormalize. Make a non-nested document for each kind of search response you want. wunder Walter Underwood wun...@wunderwood.org http://observer.wunderwood.org/ (my blog) > On May 27, 2019, at 3:55 AM, Gian Marco

Re: My problem with T-shirts and nested documents

2019-05-27 Thread Gian Marco Tagliani
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 wrote: > If you are really keeping inventory, use a relational database. Solr is a > really poor choice for this kind of application. > > wund

Re: My problem with T-shirts and nested documents

2019-05-24 Thread Walter Underwood
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 wrote: > > It's possible to search

Re: My problem with T-shirts and nested documents

2019-05-24 Thread Gian Marco Tagliani
Hi Mikhail, thanks for the quick response! I'll try to do it with your suggestion Many thanks :) On Fri, May 24, 2019 at 3:12 PM Mikhail Khludnev 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,

Re: My problem with T-shirts and nested documents

2019-05-24 Thread Bernd Fehling
How about "Pivot (Decision Tree) Faceting"? http://lucene.apache.org/solr/guide/6_6/faceting.html#Faceting-Pivot_DecisionTree_Faceting Regards Bernd Am 24.05.19 um 14:16 schrieb Gian Marco Tagliani: Hi all, I'm facing a problem with Nested Documents. To illustrate my problem I'll use the exa

Re: My problem with T-shirts and nested documents

2019-05-24 Thread Mikhail Khludnev
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#TransformingR

My problem with T-shirts and nested documents

2019-05-24 Thread Gian Marco Tagliani
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, f