Hi,
----- Original Message ---- > From: Yonik Seeley <yo...@lucidimagination.com> > Subject: Re: Parent-child options > > On Thu, Mar 17, 2011 at 1:49 AM, Otis Gospodnetic > <otis_gospodne...@yahoo.com> wrote: > > The dreaded parent-child without denormalization question. What are one's > > options for the following example: > > > > parent: shoes > > 3 children. each with 2 attributes/fields: color and size > > * color: red black orange > > * size: 10 11 12 > > > > The goal is to be able to search for: > > 1) color:red AND size:10 and get 1 hit for the above > > 2) color:red AND size:12 and get *no* matches because there are no red > > shoes >of > > size 12, only size 10. > > What if you had this instead: > > color: red red orange > size: 10 11 12 > > Do you need for color:red to return 1 or 2 (i.e. is the final answer > in units of child hits or parent hits)? The final answer is the parent, which is "shoes" in this example. So: if the query is color:red AND size:10 the answer is: Yes, we got red shoes size 10 if the query is color:red AND size:11 the answer is: Yes, we got red shoes size 11 if the query is color:red AND size:12 the answer is: No, we don't have red shoes size 12 Thanks, Otis
