return only one document for each filter defined in the query

Posted by Garytxo on Stack Overflow See other posts from Stack Overflow or by Garytxo
Published on 2010-05-05T13:21:13Z Indexed on 2010/05/05 13:28 UTC
Read the original article Hit count: 118

Filed under:

Hi all,
In one of my latest projects I use Solr 1.4 for searching products.However I have ran into a slight problem, which I aint sure if its possible to do using Solr.

All products are indexed by "country" and "category" and the "id", "class" and "description" are stored values. I now have been requested to extract a sample list of products that we have for a give "category" and "ONLY RETURNING ONE" product for each country where the product is available.

In my current implementation, I have a dismax query to get a list of all the countries that correspond to the catergory, then I call again solr to extract all products for each country, limiting the no. rows by the size of the countries found in the previous query.

The problem I have with this current implementation is I can not be certain that I have one product for each country in the list. Therefore would anyone know if it possible to tell solr that you want only one product per country provided in the query?

Any guidance would be useful.

© Stack Overflow or respective owner

Related posts about solr