Hello Mikhail,
I was using the functions as fl and sort parameters, and this
gives no result.
When sorting by score, as you did in your blog, I get the values
from the child documents. (I missed the score=max parameter)
However, i need to combine values from the parent and child, like
this: {!func}sum(price_i, field_from_parent).
At this point I get a SyntaxError like this:
"org.apache.solr.search.SyntaxError: Expected ')' at position 32 in
'sum(shipping_cost_f,startup_cost'"
But the ')' is there: sum(shipping_cost_f,startup_cost)
Do I have the syntax wrong? Or is this function not allowed in this
context?
Thanks,
Ewald
On 2017-02-01 12:59, Mikhail Khludnev wrote:
> Ewald,
>
> Functional queries combines well with block join as well as query time
> join, here are examples for latter one
> http://blog-archive.griddynamics.com/2015/08/scoring-join-party-in-solr-53.html
> It must be the same for block join.
> What doesn't work exactly?
>
> On Wed, Feb 1, 2017 at 1:39 PM, Ewald Moitzi <ewald.moi...@student.tugraz.at
>> wrote:
>
>> Hello,
>>
>> I am unsure if solr is the right solution for a problem
>> that we have, of if it is better to stick with a relational
>> database (and if it should be done in solr how to implement it).
>> The explanation is a bit lengthy, but please
>> bear with me.
>>
>> The problem:
>> Sort results of a vendor search for a product according to price
>> including delivery costs.
>>
>> The data:
>> The store itself is a marketplace, and each product can be
>> supplied by different vendors. The vendors can define delivery
>> costs for different price ranges.
>> E.g:
>>
>> _price from_| price to_| delivery cost |
>> | 0 | 49 | 10 |
>> vendor --| 50 | 99 | 5 |
>> | 100 | max | 0 |
>>
>> So, for product with a price of 55, I want the result to be 60.
>>
>> Additional requirements:
>> - The product price is also calculated, based on properties
>> of the vendor.
>> - There is also a pickup option, and there should be no
>> duplicate results.
>> - Different shipping costs for different countries.
>>
>> Progress so far:
>> My idea is to store each range as a subdocument for a vendor, but
>> I don't know how to construct a query for that. So far I have
>> managed to implement a simpler version that gives the right result for
>> each country using dynamic fields, but this uses only a free delivery
>> above x approach and that is not what we want.
>>
>> I have looked into the Block Join Query parser, but as far as I can
>> tell this does not allow to construct a function query with inputs
>> from parent and child documents.
>>
>> Why solr:
>> - sort and limit result according to geolocation.
>> - we will deploy solr anyhow in this project, for a classic
>> full text search.
>>
>> As said above, I'm not really sure if this is a good application
>> for solr, but the geolocation features are quite handy. And the
>> query is not really fast in a relational db either.
>>
>> Any input is greatly appreciated.
>>
>> Regards,
>> Ewald
>>
>>
>
>
