Hello Kelly,
Simple boolean algebra, you tell Solr you want color = green AND size = M so it will only return green t-shirts in size M. If you, however, turn the AND in a OR it will return all t-shirts that are green OR in size M, thus you can then get M sized shirts in the blue color or green shirts in size XXL. I suggest you'd just give it a try and perhaps come back later to find some improvements for your query. It would also be a good idea - if i may say so - to read the links provided in the earlier message. Hope you will find what you're looking for :) Cheers, Kelly Taylor zei: > > Hi Markus, > > Thanks for your reply. > > Using the current schema and query like you suggest, how can I identify > the unique combination of options and price for a given SKU? I don't > want the user to arrive at a product which doesn't completely satisfy > their search request. For example, with the "color:Green", "size:M", > and "price:[0 to 9.99]" search refinements applied, no products should > be displayed which only have "size:M" in "color:Blue" > > The actual data in the database for a product to display on the frontend > could be as follows: > > product id = 1 > product name = T-shirt > > related skus... > -- sku id = 7 [color=green, size=S, price=10.99] > -- sku id = 9 [color=green, size=L, price=10.99] > -- sku id = 10 [color=blue, size=S, price=9.99] > -- sku id = 11 [color=blue, size=M, price=10.99] > -- sku id = 12 [color=blue, size=L, price=10.99] > > Regards, > Kelly > > > Markus Jelsma - Buyways B.V. wrote: >> >> Hello Kelly, >> >> >> I am not entirely sure if i understand your problem correctly. But i >> believe your first approach is the right one. >> >> Your question: "Which products are available that contain skus with >> color Green, size M, and a price of $9.99 or less?" can be easily >> answered using a schema like yours. >> >> id = 1 >> color = [green, blue] >> size = [M, S] >> price = 6 >> >> id = 2 >> color = [red, blue] >> size = [L, S] >> price = 12 >> >> id = 3 >> color = [green, red, blue] >> size = [L, S, M] >> price = 5 >> >> Using the data above you can answer your question using a basic Solr >> query [1] like the following: q=color:green AND price:[0 TO 9,99] AND >> size:M >> >> Of course, you would make this a function query [2] but this, if i >> understood your question well enough, answers it. >> >> [1] http://wiki.apache.org/solr/SolrQuerySyntax >> [2] http://wiki.apache.org/solr/FunctionQuery >> >> >> Cheers, >> >> > > -- > View this message in context: > http://old.nabble.com/Encountering-a-roadblock-with-my-Solr-schema-design...use-dedupe--tp27118977p27120031.html > Sent from the Solr - User mailing list archive at Nabble.com.
