You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Denis Kuzmenok <fo...@ukr.net> on 2011/06/06 16:36:32 UTC

Need query help

For now i have a collection with:
id (int)
price (double) multivalue
brand_id (int)
filters (string) multivalue

I  need  to  get available brand_id, filters, price values and list of
id's   for   current   query.  For  example now i'm doing queries with
facet.field=brand_id/filters/price:
1) to get current id's list: (brand_id:100 OR brand_id:150) AND (filters:p1s100 OR filters:p4s20)
2) to get available filters on selected properties (same properties but
another  values):  (brand_id:100 OR brand_id:150) AND (filters:p1s* OR
filters:p4s*)
3) to get available brand_id (if any are selected, if none - take from
1st query results): (filters:p1s100 OR filters:p4s20)
4) another request to get available prices if any are selected

Is there any way to simplify this task?
Data needed:
1) Id's for selected filters, price, brand_id
2) Available filters, price, brand_id from selected values
3) Another values for selected properties (is any chosen)
4) Another brand_id for selected brand_id
5) Another price for selected price

Will appreciate any help or thoughts!

Cheers,
Denis Kuzmenok


Re: Need query help

Posted by Alexey Serba <as...@gmail.com>.
See "Tagging and excluding Filters" section

* http://wiki.apache.org/solr/SimpleFacetParameters#Tagging_and_excluding_Filters

2011/6/6 Denis Kuzmenok <fo...@ukr.net>:
> For now i have a collection with:
> id (int)
> price (double) multivalue
> brand_id (int)
> filters (string) multivalue
>
> I  need  to  get available brand_id, filters, price values and list of
> id's   for   current   query.  For  example now i'm doing queries with
> facet.field=brand_id/filters/price:
> 1) to get current id's list: (brand_id:100 OR brand_id:150) AND (filters:p1s100 OR filters:p4s20)
> 2) to get available filters on selected properties (same properties but
> another  values):  (brand_id:100 OR brand_id:150) AND (filters:p1s* OR
> filters:p4s*)
> 3) to get available brand_id (if any are selected, if none - take from
> 1st query results): (filters:p1s100 OR filters:p4s20)
> 4) another request to get available prices if any are selected
>
> Is there any way to simplify this task?
> Data needed:
> 1) Id's for selected filters, price, brand_id
> 2) Available filters, price, brand_id from selected values
> 3) Another values for selected properties (is any chosen)
> 4) Another brand_id for selected brand_id
> 5) Another price for selected price
>
> Will appreciate any help or thoughts!
>
> Cheers,
> Denis Kuzmenok
>
>