Hi, I have a problem and I don't know how should I solve it in Solr.
I have products indexed. Every product can be in lists. It is possible that a product isn't in any list or it is in multiple list. In a list the products are ordered. I would like to search for products in a specified list with the correct order. Earlier I tried to create a field for every list the product is in and these fields stored the index value of the product in that list. For example: list_23=1, list_841=8, ... After that I could do a query for list N: product where list_N exists order by list_N asc In this case the index size were extremely large because there are lot of lists and I guess every document stored a value for every field (it was long time ago, I don't know if it would be still a problem in current version of Solr) Do you have any idea how could I solve this problem? Thanks, Tamas