Hi, I'm having a problem where a Solr query on all items in one category is returning duplicated items when an item appears in more than one subcategory. My schema involves a document for each item's subcategory instance. I know this is not correct.
I'm not sure if I ever tried multiple values on subcategories. (Before the latest changes to the schema, I was only getting the first subcategory instance and I had a problem with parentcgyid.) Could you review the 3 results from 1 item below and advise how I can return only Distinct values for the itmid field? I think it's best that I change the schema to support multiple values. I'm currently already using faceting for the subcategories. Do I have to use it for this purpose also, or should I move forward to improve my schema configuration? <doc> <str name="cgyid">14440</str> <str name="itmdsc">Girl Costume</str> <str name="itmid">GIRLCOSTUME</str> <str name="itmkey">14440-GIRLCOSTUME</str> <str name="itmnam">Girl Costume Girl Child</str> <float name="lstprc">9.99</float> <str name="parcgyid">1400</str> <str name="parcgynam">Girls Costumes</str> <float name="prc">8.99</float> <str name="seoitm">girl-costume-for-child-GIRLCOSTUME</str> <str name="seoparcgy">girls+costumes</str> <str name="seosubcgy">occupational</str> - <arr name="size"> <str>L</str> <str>M</str> <str>S</str> </arr> <str name="stock">In Stock</str> <str name="subcgynam">Occupational|14440</str> </doc> - <doc> <str name="cgyid">14150</str> <str name="itmdsc">Girl Costume</str> <str name="itmid">GIRLCOSTUME</str> <str name="itmkey">14150-GIRLCOSTUME</str> <str name="itmnam">Girl Costume Girl Child</str> <float name="lstprc">9.99</float> <str name="parcgyid">1400</str> <str name="parcgynam">Girls Costumes</str> <float name="prc">8.99</float> <str name="seoitm">girl-costume-for-child-GIRLCOSTUME</str> <str name="seoparcgy">girls+costumes</str> <str name="seosubcgy">classic</str> - <arr name="size"> <str>L</str> <str>M</str> <str>S</str> </arr> <str name="stock">In Stock</str> <str name="subcgynam">Classic|14150</str> </doc> - <doc> <str name="cgyid">14010</str> <str name="itmdsc">Girl Costume</str> <str name="itmid">GIRLCOSTUME</str> <str name="itmkey">14010-GIRLCOSTUME</str> <str name="itmnam">Girl Costume Girl Child</str> <float name="lstprc">9.99</float> <str name="parcgyid">1400</str> <str name="parcgynam">Girls Costumes</str> <float name="prc">8.99</float> <str name="seoitm">girl-costume-for-child-GIRLCOSTUME</str> <str name="seoparcgy">girls+costumes</str> <str name="seosubcgy">50s+costumes</str> - <arr name="size"> <str>L</str> <str>M</str> <str>S</str> </arr> <str name="stock">In Stock</str> <str name="subcgynam">50's Costumes|14010</str> </doc> Thanks!
