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 jmaslac <jm...@gmail.com> on 2011/04/20 09:41:11 UTC
Selecting (and sorting!) by the min/max value from multiple fields
Hello,
short question is this - is there a way for a search to return a field that
is not defined in the schema but is a minimal/maximum value of several
(int/float) fields in solrDocument? (and how would that search look like?)
Longer explanation. I have products and each of them can have a several
prices (price for cash, price for credit cards, coupon price and so on) -
not every product has all the price options. (Don't ask why - that's the use
case:) )
<field name="priceCash" type="tfloat" indexed="true" stored="true" />
<field name="priceCreditCard" type="tfloat" indexed="true" stored="true"
/>
<field name="priceCoupon" type="tfloat" indexed="true" stored="true" />
+2 more
Is there a way to ask "give me the products containing for example 'sony'
and in the results return me the minimal price of all possible prices (for
each product) and SORT the results by that (minimal) price"?
I know I can calculate the minimal price at import/index time and store it
in one separate field but the idea is that users will have checkboxes in
which they could say - i'm only interested in products that have the
priceCreditCard and priceCoupon, show me the smaller of those two and sort
by that value.
My idea is something like this:
?q=sony&minPrice:min(priceCash,priceCreditCard,priceCoupon...)
(the field minPrice is not defined in schema but should return in the
results)
For searching this actually doesn't represent a problem as I can easily
programatically compare the prices and present it to the user. The problem
is sorting - I could do that also programatically but that would mean that
I'd have to pull out all the results query returned (which can be quite big
of course) and then sort them, so that a option I would naturally like to
avoid.
Don't know if I'm asking too much of solr:) but I can see usefulness of
something like this in other examples other then mine.
Hope the question is clear and if I'm going about things completely the
wrong way please advise in the right direction.
(If there is a similar question asked somewhere else please redirect me - i
didn't find it)
Help much appreciated!
Josip
--
View this message in context: http://lucene.472066.n3.nabble.com/Selecting-and-sorting-by-the-min-max-value-from-multiple-fields-tp2841944p2841944.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Selecting (and sorting!) by the min/max value from multiple
fields
Posted by jmaslac <jm...@gmail.com>.
Tanguy, thanks for the anwser.
Yes I have already tried that but the problem is that min() function is not
yet available (it is set for Solr 3.2).
:(
Btw. in my original post I've asked if the query could in the results return
a new field with this computed minimal value - that is redudant, I'm only
interested in sorting part of the question.
Tanguy Moal wrote:
>
> Hello,
>
> Have you tried reading :
> http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
>
> From that page I would try something like :
> http://host:port/solr/select?q=sony&sort=min(min(priceCash,priceCreditCard),priceCoupon)+asc&rows=10&indent=on&debugQuery=on
>
> Is that of any help ?
>
> --
> Tanguy
>
> On 04/20/2011 09:41 AM, jmaslac wrote:
>> Hello,
>>
>> short question is this - is there a way for a search to return a field
>> that
>> is not defined in the schema but is a minimal/maximum value of several
>> (int/float) fields in solrDocument? (and how would that search look
>> like?)
>>
>> Longer explanation. I have products and each of them can have a several
>> prices (price for cash, price for credit cards, coupon price and so on) -
>> not every product has all the price options. (Don't ask why - that's the
>> use
>> case:) )
>>
>> <field name="priceCash" type="tfloat" indexed="true" stored="true" />
>> <field name="priceCreditCard" type="tfloat" indexed="true"
>> stored="true"
>> />
>> <field name="priceCoupon" type="tfloat" indexed="true" stored="true"
>> />
>> +2 more
>>
>> Is there a way to ask "give me the products containing for example 'sony'
>> and in the results return me the minimal price of all possible prices
>> (for
>> each product) and SORT the results by that (minimal) price"?
>>
>> I know I can calculate the minimal price at import/index time and store
>> it
>> in one separate field but the idea is that users will have checkboxes in
>> which they could say - i'm only interested in products that have the
>> priceCreditCard and priceCoupon, show me the smaller of those two and
>> sort
>> by that value.
>>
>> My idea is something like this:
>> ?q=sony&minPrice:min(priceCash,priceCreditCard,priceCoupon...)
>> (the field minPrice is not defined in schema but should return in the
>> results)
>>
>> For searching this actually doesn't represent a problem as I can easily
>> programatically compare the prices and present it to the user. The
>> problem
>> is sorting - I could do that also programatically but that would mean
>> that
>> I'd have to pull out all the results query returned (which can be quite
>> big
>> of course) and then sort them, so that a option I would naturally like to
>> avoid.
>>
>> Don't know if I'm asking too much of solr:) but I can see usefulness of
>> something like this in other examples other then mine.
>> Hope the question is clear and if I'm going about things completely the
>> wrong way please advise in the right direction.
>> (If there is a similar question asked somewhere else please redirect me -
>> i
>> didn't find it)
>>
>> Help much appreciated!
>>
>> Josip
>>
>> --
>> View this message in context:
>> http://lucene.472066.n3.nabble.com/Selecting-and-sorting-by-the-min-max-value-from-multiple-fields-tp2841944p2841944.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
> --
> --
> Tanguy
>
--
View this message in context: http://lucene.472066.n3.nabble.com/Selecting-and-sorting-by-the-min-max-value-from-multiple-fields-tp2841944p2842232.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Selecting (and sorting!) by the min/max value from multiple fields
Posted by Tanguy Moal <ta...@gmail.com>.
Hello,
Have you tried reading :
http://wiki.apache.org/solr/FunctionQuery#Sort_By_Function
From that page I would try something like :
http://host:port/solr/select?q=sony&sort=min(min(priceCash,priceCreditCard),priceCoupon)+asc&rows=10&indent=on&debugQuery=on
Is that of any help ?
--
Tanguy
On 04/20/2011 09:41 AM, jmaslac wrote:
> Hello,
>
> short question is this - is there a way for a search to return a field that
> is not defined in the schema but is a minimal/maximum value of several
> (int/float) fields in solrDocument? (and how would that search look like?)
>
> Longer explanation. I have products and each of them can have a several
> prices (price for cash, price for credit cards, coupon price and so on) -
> not every product has all the price options. (Don't ask why - that's the use
> case:) )
>
> <field name="priceCash" type="tfloat" indexed="true" stored="true" />
> <field name="priceCreditCard" type="tfloat" indexed="true" stored="true"
> />
> <field name="priceCoupon" type="tfloat" indexed="true" stored="true" />
> +2 more
>
> Is there a way to ask "give me the products containing for example 'sony'
> and in the results return me the minimal price of all possible prices (for
> each product) and SORT the results by that (minimal) price"?
>
> I know I can calculate the minimal price at import/index time and store it
> in one separate field but the idea is that users will have checkboxes in
> which they could say - i'm only interested in products that have the
> priceCreditCard and priceCoupon, show me the smaller of those two and sort
> by that value.
>
> My idea is something like this:
> ?q=sony&minPrice:min(priceCash,priceCreditCard,priceCoupon...)
> (the field minPrice is not defined in schema but should return in the
> results)
>
> For searching this actually doesn't represent a problem as I can easily
> programatically compare the prices and present it to the user. The problem
> is sorting - I could do that also programatically but that would mean that
> I'd have to pull out all the results query returned (which can be quite big
> of course) and then sort them, so that a option I would naturally like to
> avoid.
>
> Don't know if I'm asking too much of solr:) but I can see usefulness of
> something like this in other examples other then mine.
> Hope the question is clear and if I'm going about things completely the
> wrong way please advise in the right direction.
> (If there is a similar question asked somewhere else please redirect me - i
> didn't find it)
>
> Help much appreciated!
>
> Josip
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Selecting-and-sorting-by-the-min-max-value-from-multiple-fields-tp2841944p2841944.html
> Sent from the Solr - User mailing list archive at Nabble.com.
--
--
Tanguy