Re: sort by score in join with geodist()

2019-11-14 Thread Vasily Ogar
Wow, it's working as expected, thank you very much. I spent three weeks to define Solr structure and build a query with expected results. Thanks again because I am almost lost a hope to get what I want. On Fri, Nov 15, 2019 at 6:05 AM Mikhail Khludnev wrote: > Hm... > q={!join param=param.. v=$g

Re: sort by score in join with geodist()

2019-11-14 Thread Mikhail Khludnev
Hm... q={!join param=param.. v=$g}&q={!bool must='{!geofilt}' should='{!func}geodist()'} ? On Thu, Nov 14, 2019 at 10:11 PM Vasily Ogar wrote: > I tried and this way also, but here is another error. > { "responseHeader":{ "status":400, "QTime":6, "params":{ "hl":"on", "pt": > "54.6973867999,

Re: sort by score in join with geodist()

2019-11-14 Thread Vasily Ogar
I tried and this way also, but here is another error. { "responseHeader":{ "status":400, "QTime":6, "params":{ "hl":"on", "pt": "54.6973867999,25.22481530046", "fl":"score,*,store:[subquery fromIndex=stores]", "store.rows":"1", "fq":"{!edismax qf=\"title description\" v=\"iphone xr 64gb\" m

Re: sort by score in join with geodist()

2019-11-14 Thread Mikhail Khludnev
Space matters. Check my snippet once again please. On Thu, Nov 14, 2019 at 9:56 PM Vasily Ogar wrote: > I tried today with plus but always got same error. > { "responseHeader":{ "status":400, "QTime":2, "params":{ "hl":"on", "pt": > "54.6973867999,25.22481530046", "fl":"score,*,store:[su

Re: sort by score in join with geodist()

2019-11-14 Thread Vasily Ogar
I tried today with plus but always got same error. { "responseHeader":{ "status":400, "QTime":2, "params":{ "hl":"on", "pt": "54.6973867999,25.22481530046", "fl":"score,*,store:[subquery fromIndex=stores]", "store.rows":"1", "fq":"{!edismax qf=\"title description\" v=\"iphone xr 64gb\" mm=3

Re: sort by score in join with geodist()

2019-11-14 Thread Mikhail Khludnev
It should be like "q":"{!join from=site_id to=site_id fromIndex=stores score=max}+{!geofilt} {!func}geodist() ", post debugQuery On Thu, Nov 14, 2019 at 4:44 PM Vasily Ogar wrote: > I was glad too early because it can only sort or only filter, but can't do > together :(. It takes the only first

Re: sort by score in join with geodist()

2019-11-14 Thread Vasily Ogar
I was glad too early because it can only sort or only filter, but can't do together :(. It takes the only first argument, in my case it geodist or geofilt On Thu, Nov 14, 2019 at 11:11 AM Vasily Ogar wrote: > Hello, > I fixed it. If I need to sort by price: > "q":"{!join from=site_id to=site_id

Re: sort by score in join with geodist()

2019-11-14 Thread Vasily Ogar
Hello, I fixed it. If I need to sort by price: "q":"{!join from=site_id to=site_id fromIndex=stores}*:*", "fq":"{!edismax qf=\"title description\" v=\"iphone xr 64gb\" mm=3<90%}", " fl":"score,*,store:[subquery fromIndex=stores]", "store.q":"{!terms f=site_id v=$row.site_id}", "store.rows":"1", "st

Re: sort by score in join with geodist()

2019-11-12 Thread Vasily Ogar
Thank you for advice, now it working as expected. Maybe you know how to integrate with dismax? On Tue, Nov 12, 2019 at 6:10 PM Mikhail Khludnev wrote: > tlrd; > I noticed func under fq that make no sense. Only q or sort yield scores. > > On Tue, Nov 12, 2019 at 6:43 PM Vasily Ogar wrote: > > >

Re: sort by score in join with geodist()

2019-11-12 Thread Mikhail Khludnev
tlrd; I noticed func under fq that make no sense. Only q or sort yield scores. On Tue, Nov 12, 2019 at 6:43 PM Vasily Ogar wrote: > First of all, thank you for your help. > Now it doesn't show any errors, but somehow score is based on the title and > description but not on the geodist. > "params

Re: sort by score in join with geodist()

2019-11-12 Thread Vasily Ogar
First of all, thank you for your help. Now it doesn't show any errors, but somehow score is based on the title and description but not on the geodist. "params":{ "hl":"on", "pt":"54.6973867999,25.22481530046", "fl":"score,*,store:[subquery fromIndex=stores]", "store.rows":"1", "fq":"{!join

Re: sort by score in join with geodist()

2019-11-12 Thread Mikhail Khludnev
Hello, It seems like I breached the limit on unconscious replies in mailing list I'd rather start with this: q={!join from=site_id to=site_id fromIndex=stores score=max}+{!geofilt} {!func}geodist()&sfield=coordinates&pt=54.6973867999,25.22481530046&d=10 On Mon, Nov 11, 2019 at 11:11 PM

Re: sort by score in join with geodist()

2019-11-11 Thread Mikhail Khludnev
Is it something like https://issues.apache.org/jira/browse/SOLR-10673 ? On Mon, Nov 11, 2019 at 3:47 PM Vasily Ogar wrote: > it's show nothing because I got an error > "metadata":[ "error-class","org.apache.solr.common.SolrException", > "root-error-class","org.apache.solr.search.SyntaxError"],

Re: sort by score in join with geodist()

2019-11-11 Thread Vasily Ogar
it's show nothing because I got an error "metadata":[ "error-class","org.apache.solr.common.SolrException", "root-error-class","org.apache.solr.search.SyntaxError"], "msg":"org.apache.solr.search.SyntaxError: geodist - not enough parameters:[]", If I set parameters then I got another error "metada

Re: sort by score in join with geodist()

2019-11-11 Thread Mikhail Khludnev
Hello, Vasily. Why not? What have you got in debugQuery=true? On Mon, Nov 11, 2019 at 1:19 PM Vasily Ogar wrote: > Hello, > Is it possible to sort by score in join by geodist()? For instance, > something like this > q={!join from=site_id to=site_id fromIndex=stores score=max} > +{!func}gedist()

sort by score in join with geodist()

2019-11-11 Thread Vasily Ogar
Hello, Is it possible to sort by score in join by geodist()? For instance, something like this q={!join from=site_id to=site_id fromIndex=stores score=max} +{!func}gedist() +{!geofilt sfield=coordinates pt=54.6973867999,25.22481530046 d=10} sort=score desc Thank you