Re: Indexing relations for sorting

2011-05-02 Thread Chris Hostetter

: Every product-to-category relation has its own sorting order which we would
: like to index in solr. 
...
: We want all products of subcat1 (no mather what the parent category is)
: ordered by their sorting order
:  
: We want all products of cat2_subcat1 ordered by their sorting order

the best suggestion i can think of is to create a field per category and 
use it to index the sort order for that category -- you haven't said what 
type of cardinality you are dealing with in your categorization, so if 
it's relatively small this should work well ... if it's unbounded it will 
have some serious problems however.

: Our solr version is 1.3.0

Please, Please, Please consider upgrading when you are working on this 
project of yours.  there have been too many bug fixes and performance 
enhancements since then to even remotely dream of listing them all in this 
email (that's what the CHANGES.txt file is for)


-Hoss


Indexing relations for sorting

2011-04-15 Thread derk.h
Hi everybody,

I have the following problem/question:

In our system we have some categories and products in those categories. Our
structure looks a bit like this:

 
product X belongs to category: cat1_subcat1 (10)
 
product X belongs to category: cat2_subcat1 (20)
 
product Y belongs to category: cat1_subcat2 (30)
 
product Z belongs to category: cat2_subcat1 (15)


Every product-to-category relation has its own sorting order which we would
like to index in solr. 

To make the problem more complex, we have two ways of searching for a
product:

 
We want all products of subcat1 (no mather what the parent category is)
ordered by their sorting order
 
We want all products of cat2_subcat1 ordered by their sorting order



This probably is not what solr is designed for, but everything else in our
system is indexed and searched by solr. 
So it would be very helpfull if someone has an idea or suggestion to make
this work.

Our solr version is 1.3.0

Many thanks!
Derk

--
View this message in context: 
http://lucene.472066.n3.nabble.com/Indexing-relations-for-sorting-tp2824223p2824223.html
Sent from the Solr - User mailing list archive at Nabble.com.