Re: Using parameter values in a sort

[Erik Hatcher]

FYI - I recalled, and located, a solr-user thread from 2015 with subject 
“Parameter Substitution” with this same issue.   Tricky issue - overloaded `${` 
usage and interpretation time.

Erik

> On Mar 1, 2017, at 1:41 PM, Erik Hatcher  wrote:
> 
> I just found a workaround, check out this trick:
> 
> ${sort_field:${sort_field}} desc
> 
> when the core is loaded, it looks for a system property “sort_field”, doesn’t 
> find it, and defaults the value to ${sort_field} and voila:
> 
>/browse?q=*:*=xml_field=id
> 
>   Erik
> 
> 
>> On Mar 1, 2017, at 1:14 PM, Erik Hatcher  wrote:
>> 
>> Walter -
>> 
>> Apologies for not trying this sooner first-hand.   I’m used to passing in 
>> all the params (even the dynamic ${…} ones) in the request these days, not 
>> so much putting them into request handler definitions.
>> 
>> I finally tried it with a default (master/trunk) with modifying the /browse 
>> handler with this:
>> 
>> > useParams="query,facets,velocity,browse">
>>   
>> explicit
>> ${sort_field} desc
>>   
>> 
>> 
>> And get this startup error:
>> 
>> Caused by: org.apache.solr.common.SolrException: No system property or 
>> default value specified for sort_field value:${sort_field} desc
>>  at 
>> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>>  at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:303)
>> 
>> *sigh* and sorry for leading you astray.   Definitely a Solr bug.
>> 
>> However, this technique does work when everything is in the params:
>> 
>>   /select?q=*:*=${sort_field}%20desc_field=id
>> 
>> @Yonik or others - is this a known/filed issue?Workarounds or escaping 
>> that could make it work?
>> 
>>  Erik
>> 
>> 
>>> On Feb 27, 2017, at 10:39 PM, Walter Underwood  
>>> wrote:
>>> 
>>> No, I tried that before adding the default.
>>> 
>>> But the solrconfig.xml is rejected before there is a request, so this is 
>>> not about requests. I did try “scores” in the requests, but of course it 
>>> didn’t work because the solrconfig.xml was not loaded. I did not turn off 
>>> parameter substitutions. This is a pretty vanilla solrconfig.xml.
>>> 
>>> wunder
>>> Walter Underwood
>>> wun...@wunderwood.org
>>> http://observer.wunderwood.org/  (my blog)
>>> 
>>> 
 On Feb 27, 2017, at 6:44 PM, Erik Hatcher  wrote:
 
 `scores` (plural), you’ve got this below:   
 
 Remove that, and like my previous e-mail, and use `scores` (plural) from 
 the request and _should_ work?
 
Erik
 
> On Feb 27, 2017, at 9:42 PM, Walter Underwood  
> wrote:
> 
> I’ve passed in a score parameter, but the solrconfig.xml is rejected 
> before any requests.
> 
> Pretty ready to give up. The documentation around function queries and 
> params is not working for me, though I’ve been using Solr for ten years. 
> I have figured out a lot of systems. This is impenetrable.
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 
>> On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
>> 
>> You have an empty “scores” parameter in there.  You’re not showing your 
>> full search request, but did you provide that in the request?   Have you 
>> perhaps turned off parameter substitutions?
>> 
>>  Erik
>> 
>>> On Feb 27, 2017, at 9:26 PM, Walter Underwood  
>>> wrote:
>>> 
>>> With this in the config…
>>> 
>>> 
>>>  
>>> 
>>> edismax
>>> 0
>>> false
>>> id,
>>> image_thumb_large, image_thumb_medium, image_thumb_small,
>>> image_thumb_xlarge, uri, user_id, last_name, first_name,
>>> name, school, major, graduation_year, tutor_profile_id,
>>> positive_reviews, negative_reviews, gender, about_experience,
>>> about_extracurricular, time_approved
>>> *:*
>>> about_experience  about_extracurricular School  
>>> Major
>>> 
>>> >> name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>>  desc
>>> log(sum(1,max(positive_reviews,0)))
>>> 0.1
>>> 
>>> 
>>> 
>>> I see this… [Solr 6.3.0]
>>> 
>>> org.apache.solr.common.SolrException: Unable to reload core 
>>> [tutors_shard1_replica11]
>>> at 
>>> org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>>> at 
>>> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>>> at 
>>> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>>> at java.lang.Thread.run(Thread.java:745)
>>> Caused by: org.apache.solr.common.SolrException: Could not load 

Re: Using parameter values in a sort

[Erik Hatcher]

I just found a workaround, check out this trick:

 ${sort_field:${sort_field}} desc

when the core is loaded, it looks for a system property “sort_field”, doesn’t 
find it, and defaults the value to ${sort_field} and voila:

/browse?q=*:*=xml_field=id

Erik


> On Mar 1, 2017, at 1:14 PM, Erik Hatcher  wrote:
> 
> Walter -
> 
> Apologies for not trying this sooner first-hand.   I’m used to passing in all 
> the params (even the dynamic ${…} ones) in the request these days, not so 
> much putting them into request handler definitions.
> 
> I finally tried it with a default (master/trunk) with modifying the /browse 
> handler with this:
> 
>   useParams="query,facets,velocity,browse">
>
>  explicit
>  ${sort_field} desc
>
>  
> 
> And get this startup error:
> 
> Caused by: org.apache.solr.common.SolrException: No system property or 
> default value specified for sort_field value:${sort_field} desc
>   at 
> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>   at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:303)
> 
> *sigh* and sorry for leading you astray.   Definitely a Solr bug.
> 
> However, this technique does work when everything is in the params:
> 
>/select?q=*:*=${sort_field}%20desc_field=id
> 
> @Yonik or others - is this a known/filed issue?Workarounds or escaping 
> that could make it work?
> 
>   Erik
> 
> 
>> On Feb 27, 2017, at 10:39 PM, Walter Underwood  wrote:
>> 
>> No, I tried that before adding the default.
>> 
>> But the solrconfig.xml is rejected before there is a request, so this is not 
>> about requests. I did try “scores” in the requests, but of course it didn’t 
>> work because the solrconfig.xml was not loaded. I did not turn off parameter 
>> substitutions. This is a pretty vanilla solrconfig.xml.
>> 
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/  (my blog)
>> 
>> 
>>> On Feb 27, 2017, at 6:44 PM, Erik Hatcher  wrote:
>>> 
>>> `scores` (plural), you’ve got this below:   
>>> 
>>> Remove that, and like my previous e-mail, and use `scores` (plural) from 
>>> the request and _should_ work?
>>> 
>>> Erik
>>> 
 On Feb 27, 2017, at 9:42 PM, Walter Underwood  
 wrote:
 
 I’ve passed in a score parameter, but the solrconfig.xml is rejected 
 before any requests.
 
 Pretty ready to give up. The documentation around function queries and 
 params is not working for me, though I’ve been using Solr for ten years. I 
 have figured out a lot of systems. This is impenetrable.
 
 wunder
 Walter Underwood
 wun...@wunderwood.org
 http://observer.wunderwood.org/  (my blog)
 
 
> On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
> 
> You have an empty “scores” parameter in there.  You’re not showing your 
> full search request, but did you provide that in the request?   Have you 
> perhaps turned off parameter substitutions?
> 
>   Erik
> 
>> On Feb 27, 2017, at 9:26 PM, Walter Underwood  
>> wrote:
>> 
>> With this in the config…
>> 
>> 
>>  
>> 
>>  edismax
>>  0
>>  false
>>  id,
>>  image_thumb_large, image_thumb_medium, image_thumb_small,
>>  image_thumb_xlarge, uri, user_id, last_name, first_name,
>>  name, school, major, graduation_year, tutor_profile_id,
>>  positive_reviews, negative_reviews, gender, about_experience,
>>  about_extracurricular, time_approved
>>  *:*
>>  about_experience  about_extracurricular School  
>> Major
>>  
>>  > name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>  desc
>>  log(sum(1,max(positive_reviews,0)))
>>  0.1
>> 
>> 
>> 
>> I see this… [Solr 6.3.0]
>> 
>> org.apache.solr.common.SolrException: Unable to reload core 
>> [tutors_shard1_replica11]
>>  at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>>  at 
>> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>>  at 
>> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>>  at java.lang.Thread.run(Thread.java:745)
>> Caused by: org.apache.solr.common.SolrException: Could not load conf for 
>> core tutors_shard1_replica11: Error loading solr config from 
>> solrconfig.xml
>>  at 
>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>>  at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>>  ... 3 more
>> Caused by: org.apache.solr.common.SolrException: Error loading solr 
>> config from solrconfig.xml
>>  at 
>> 

Re: Using parameter values in a sort

[Erik Hatcher]

Walter -

Apologies for not trying this sooner first-hand.   I’m used to passing in all 
the params (even the dynamic ${…} ones) in the request these days, not so much 
putting them into request handler definitions.

I finally tried it with a default (master/trunk) with modifying the /browse 
handler with this:

  

  explicit
  ${sort_field} desc

  

And get this startup error:

Caused by: org.apache.solr.common.SolrException: No system property or default 
value specified for sort_field value:${sort_field} desc
at 
org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:303)

*sigh* and sorry for leading you astray.   Definitely a Solr bug.

However, this technique does work when everything is in the params:

/select?q=*:*=${sort_field}%20desc_field=id

@Yonik or others - is this a known/filed issue?Workarounds or escaping that 
could make it work?

Erik


> On Feb 27, 2017, at 10:39 PM, Walter Underwood  wrote:
> 
> No, I tried that before adding the default.
> 
> But the solrconfig.xml is rejected before there is a request, so this is not 
> about requests. I did try “scores” in the requests, but of course it didn’t 
> work because the solrconfig.xml was not loaded. I did not turn off parameter 
> substitutions. This is a pretty vanilla solrconfig.xml.
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 
>> On Feb 27, 2017, at 6:44 PM, Erik Hatcher  wrote:
>> 
>> `scores` (plural), you’ve got this below:   
>> 
>> Remove that, and like my previous e-mail, and use `scores` (plural) from the 
>> request and _should_ work?
>> 
>>  Erik
>> 
>>> On Feb 27, 2017, at 9:42 PM, Walter Underwood  wrote:
>>> 
>>> I’ve passed in a score parameter, but the solrconfig.xml is rejected before 
>>> any requests.
>>> 
>>> Pretty ready to give up. The documentation around function queries and 
>>> params is not working for me, though I’ve been using Solr for ten years. I 
>>> have figured out a lot of systems. This is impenetrable.
>>> 
>>> wunder
>>> Walter Underwood
>>> wun...@wunderwood.org
>>> http://observer.wunderwood.org/  (my blog)
>>> 
>>> 
 On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
 
 You have an empty “scores” parameter in there.  You’re not showing your 
 full search request, but did you provide that in the request?   Have you 
 perhaps turned off parameter substitutions?
 
Erik
 
> On Feb 27, 2017, at 9:26 PM, Walter Underwood  
> wrote:
> 
> With this in the config…
> 
> 
>  
> 
>   edismax
>   0
>   false
>   id,
>   image_thumb_large, image_thumb_medium, image_thumb_small,
>   image_thumb_xlarge, uri, user_id, last_name, first_name,
>   name, school, major, graduation_year, tutor_profile_id,
>   positive_reviews, negative_reviews, gender, about_experience,
>   about_extracurricular, time_approved
>   *:*
>   about_experience  about_extracurricular School  
> Major
>   
>    name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>  desc
>   log(sum(1,max(positive_reviews,0)))
>   0.1
> 
> 
> 
> I see this… [Solr 6.3.0]
> 
> org.apache.solr.common.SolrException: Unable to reload core 
> [tutors_shard1_replica11]
>   at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>   at 
> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>   at 
> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.solr.common.SolrException: Could not load conf for 
> core tutors_shard1_replica11: Error loading solr config from 
> solrconfig.xml
>   at 
> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>   at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>   ... 3 more
> Caused by: org.apache.solr.common.SolrException: Error loading solr 
> config from solrconfig.xml
>   at 
> org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
>   at 
> org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
>   at 
> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
>   ... 4 more
> Caused by: org.apache.solr.common.SolrException: No system property or 
> default value specified for scores 
> value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>  desc
>   

Re: Using parameter values in a sort

[Walter Underwood]

No, I tried that before adding the default.

But the solrconfig.xml is rejected before there is a request, so this is not 
about requests. I did try “scores” in the requests, but of course it didn’t 
work because the solrconfig.xml was not loaded. I did not turn off parameter 
substitutions. This is a pretty vanilla solrconfig.xml.

wunder
Walter Underwood
wun...@wunderwood.org
http://observer.wunderwood.org/  (my blog)


> On Feb 27, 2017, at 6:44 PM, Erik Hatcher  wrote:
> 
> `scores` (plural), you’ve got this below:   
> 
> Remove that, and like my previous e-mail, and use `scores` (plural) from the 
> request and _should_ work?
> 
>   Erik
> 
>> On Feb 27, 2017, at 9:42 PM, Walter Underwood  wrote:
>> 
>> I’ve passed in a score parameter, but the solrconfig.xml is rejected before 
>> any requests.
>> 
>> Pretty ready to give up. The documentation around function queries and 
>> params is not working for me, though I’ve been using Solr for ten years. I 
>> have figured out a lot of systems. This is impenetrable.
>> 
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/  (my blog)
>> 
>> 
>>> On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
>>> 
>>> You have an empty “scores” parameter in there.  You’re not showing your 
>>> full search request, but did you provide that in the request?   Have you 
>>> perhaps turned off parameter substitutions?
>>> 
>>> Erik
>>> 
 On Feb 27, 2017, at 9:26 PM, Walter Underwood  
 wrote:
 
 With this in the config…
 
 
   
  
edismax
0
false
id,
image_thumb_large, image_thumb_medium, image_thumb_small,
image_thumb_xlarge, uri, user_id, last_name, first_name,
name, school, major, graduation_year, tutor_profile_id,
positive_reviews, negative_reviews, gender, about_experience,
about_extracurricular, time_approved
*:*
about_experience  about_extracurricular School  
 Major

>>> name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
  desc
log(sum(1,max(positive_reviews,0)))
0.1
  
 
 
 I see this… [Solr 6.3.0]
 
 org.apache.solr.common.SolrException: Unable to reload core 
 [tutors_shard1_replica11]
at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
at 
 org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
at 
 org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
at java.lang.Thread.run(Thread.java:745)
 Caused by: org.apache.solr.common.SolrException: Could not load conf for 
 core tutors_shard1_replica11: Error loading solr config from solrconfig.xml
at 
 org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
... 3 more
 Caused by: org.apache.solr.common.SolrException: Error loading solr config 
 from solrconfig.xml
at 
 org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
at 
 org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
at 
 org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
... 4 more
 Caused by: org.apache.solr.common.SolrException: No system property or 
 default value specified for scores 
 value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
  desc
at 
 org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
 
 wunder
 Walter Underwood
 wun...@wunderwood.org
 http://observer.wunderwood.org/  (my blog)
 
 
> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
> 
> Walter -
> 
> How about this, for the latter part of your request:
> 
> /handler?features=a,b,c
> 
> with =sum(${features}) desc
> 
> That ought to do the trick.   At first I thought the #foreach nature of 
> the list of features was prohibitive, but since you’re literally plugging 
> in the exact string value and it’s used as a comma-separated list then 
> this should work.
> 
> But with the just a list of subject ID’s I think you’re in custom 
> development now (or a JavaScript stage in a Fusion query pipeline ;) in 
> building a SearchComponent that takes a `features` parameter and builds 
> the sort param as needed from that.
> 
>   Erik
> 
> 
> 
>> On Feb 27, 2017, at 7:17 PM, Walter Underwood 

Re: Using parameter values in a sort

[Erik Hatcher]

It looks like you’ve got score/scores mismatching going on.   

I feel your frustration through e-mail.   It’s voodoo for sure, but hopefully 
it’s just typos that are getting  you now.  I’d simplify it down to an example 
like I provided without mixing in any other variables or params (even for us 
seasoned pros, simplification is often the root of problem solving in 
frustrating times; get back to what works) and let’s see the request (and 
echoParam=all output when the request is successful).

Erik


> On Feb 27, 2017, at 9:48 PM, Walter Underwood  wrote:
> 
> I added that line because I was getting an error about it being undefined.
> 
>   
> 
> At this point, I’m just doing random shit hoping it will work. There is not 
> enough documentation to use this.
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 
>> On Feb 27, 2017, at 6:44 PM, Erik Hatcher  wrote:
>> 
>> `scores` (plural), you’ve got this below:   
>> 
>> Remove that, and like my previous e-mail, and use `scores` (plural) from the 
>> request and _should_ work?
>> 
>>  Erik
>> 
>>> On Feb 27, 2017, at 9:42 PM, Walter Underwood  wrote:
>>> 
>>> I’ve passed in a score parameter, but the solrconfig.xml is rejected before 
>>> any requests.
>>> 
>>> Pretty ready to give up. The documentation around function queries and 
>>> params is not working for me, though I’ve been using Solr for ten years. I 
>>> have figured out a lot of systems. This is impenetrable.
>>> 
>>> wunder
>>> Walter Underwood
>>> wun...@wunderwood.org
>>> http://observer.wunderwood.org/  (my blog)
>>> 
>>> 
 On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
 
 You have an empty “scores” parameter in there.  You’re not showing your 
 full search request, but did you provide that in the request?   Have you 
 perhaps turned off parameter substitutions?
 
Erik
 
> On Feb 27, 2017, at 9:26 PM, Walter Underwood  
> wrote:
> 
> With this in the config…
> 
> 
>  
> 
>   edismax
>   0
>   false
>   id,
>   image_thumb_large, image_thumb_medium, image_thumb_small,
>   image_thumb_xlarge, uri, user_id, last_name, first_name,
>   name, school, major, graduation_year, tutor_profile_id,
>   positive_reviews, negative_reviews, gender, about_experience,
>   about_extracurricular, time_approved
>   *:*
>   about_experience  about_extracurricular School  
> Major
>   
>    name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>  desc
>   log(sum(1,max(positive_reviews,0)))
>   0.1
> 
> 
> 
> I see this… [Solr 6.3.0]
> 
> org.apache.solr.common.SolrException: Unable to reload core 
> [tutors_shard1_replica11]
>   at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>   at 
> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>   at 
> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.solr.common.SolrException: Could not load conf for 
> core tutors_shard1_replica11: Error loading solr config from 
> solrconfig.xml
>   at 
> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>   at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>   ... 3 more
> Caused by: org.apache.solr.common.SolrException: Error loading solr 
> config from solrconfig.xml
>   at 
> org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
>   at 
> org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
>   at 
> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
>   ... 4 more
> Caused by: org.apache.solr.common.SolrException: No system property or 
> default value specified for scores 
> value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>  desc
>   at 
> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>   at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 
>> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
>> 
>> Walter -
>> 
>> How about this, for the latter part of your request:
>> 
>> /handler?features=a,b,c
>> 
>> with =sum(${features}) desc
>> 
>> That ought to do the trick.   At first I thought the #foreach 

Re: Using parameter values in a sort

[Erik Hatcher]

> On Feb 27, 2017, at 9:42 PM, Walter Underwood  wrote:
> Pretty ready to give up. The documentation around function queries and params 
> is not working for me, though I’ve been using Solr for ten years. I have 
> figured out a lot of systems. This is impenetrable.

Here’s how I (try to) explain it in Solr training:

There’s plain uncurly bracketed parameter substitution.  This is where a 
feature (say local params, or function queries) is designed to indirect an 
exact parameter and pull it in:

/select?q=*:*={!terms f=id v=$id_list}_list=1,2,3

And then there’s macro substitution, with curly bracketed syntax, and this 
is an in place string substitution allowing gluing of things together:

  /select?q=*:*=${sort_field_name} desc_field_name=price

When in doubt, the curly bracketed syntax actually should do the trick, but 
there’s always the fun aspect of whitespace and escaping and quoting and such, 
so it is tricky business.   A browser, some trial-and-error, and hopefully some 
tips and tricks like these that emerge online will be helpful in demystifying 
this and making it more accessible and useful/usable.

Erik

Re: Using parameter values in a sort

[Walter Underwood]

I added that line because I was getting an error about it being undefined.

   

At this point, I’m just doing random shit hoping it will work. There is not 
enough documentation to use this.

wunder
Walter Underwood
wun...@wunderwood.org
http://observer.wunderwood.org/  (my blog)


> On Feb 27, 2017, at 6:44 PM, Erik Hatcher  wrote:
> 
> `scores` (plural), you’ve got this below:   
> 
> Remove that, and like my previous e-mail, and use `scores` (plural) from the 
> request and _should_ work?
> 
>   Erik
> 
>> On Feb 27, 2017, at 9:42 PM, Walter Underwood  wrote:
>> 
>> I’ve passed in a score parameter, but the solrconfig.xml is rejected before 
>> any requests.
>> 
>> Pretty ready to give up. The documentation around function queries and 
>> params is not working for me, though I’ve been using Solr for ten years. I 
>> have figured out a lot of systems. This is impenetrable.
>> 
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/  (my blog)
>> 
>> 
>>> On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
>>> 
>>> You have an empty “scores” parameter in there.  You’re not showing your 
>>> full search request, but did you provide that in the request?   Have you 
>>> perhaps turned off parameter substitutions?
>>> 
>>> Erik
>>> 
 On Feb 27, 2017, at 9:26 PM, Walter Underwood  
 wrote:
 
 With this in the config…
 
 
   
  
edismax
0
false
id,
image_thumb_large, image_thumb_medium, image_thumb_small,
image_thumb_xlarge, uri, user_id, last_name, first_name,
name, school, major, graduation_year, tutor_profile_id,
positive_reviews, negative_reviews, gender, about_experience,
about_extracurricular, time_approved
*:*
about_experience  about_extracurricular School  
 Major

>>> name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
  desc
log(sum(1,max(positive_reviews,0)))
0.1
  
 
 
 I see this… [Solr 6.3.0]
 
 org.apache.solr.common.SolrException: Unable to reload core 
 [tutors_shard1_replica11]
at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
at 
 org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
at 
 org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
at java.lang.Thread.run(Thread.java:745)
 Caused by: org.apache.solr.common.SolrException: Could not load conf for 
 core tutors_shard1_replica11: Error loading solr config from solrconfig.xml
at 
 org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
... 3 more
 Caused by: org.apache.solr.common.SolrException: Error loading solr config 
 from solrconfig.xml
at 
 org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
at 
 org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
at 
 org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
... 4 more
 Caused by: org.apache.solr.common.SolrException: No system property or 
 default value specified for scores 
 value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
  desc
at 
 org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
 
 wunder
 Walter Underwood
 wun...@wunderwood.org
 http://observer.wunderwood.org/  (my blog)
 
 
> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
> 
> Walter -
> 
> How about this, for the latter part of your request:
> 
> /handler?features=a,b,c
> 
> with =sum(${features}) desc
> 
> That ought to do the trick.   At first I thought the #foreach nature of 
> the list of features was prohibitive, but since you’re literally plugging 
> in the exact string value and it’s used as a comma-separated list then 
> this should work.
> 
> But with the just a list of subject ID’s I think you’re in custom 
> development now (or a JavaScript stage in a Fusion query pipeline ;) in 
> building a SearchComponent that takes a `features` parameter and builds 
> the sort param as needed from that.
> 
>   Erik
> 
> 
> 
>> On Feb 27, 2017, at 7:17 PM, Walter Underwood  
>> wrote:
>> 
>> We have documents with parameterized features. For a school subject 
>> (calculus, 

Re: Using parameter values in a sort

[Erik Hatcher]

`scores` (plural), you’ve got this below:   

Remove that, and like my previous e-mail, and use `scores` (plural) from the 
request and _should_ work?

Erik

> On Feb 27, 2017, at 9:42 PM, Walter Underwood  wrote:
> 
> I’ve passed in a score parameter, but the solrconfig.xml is rejected before 
> any requests.
> 
> Pretty ready to give up. The documentation around function queries and params 
> is not working for me, though I’ve been using Solr for ten years. I have 
> figured out a lot of systems. This is impenetrable.
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 
>> On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
>> 
>> You have an empty “scores” parameter in there.  You’re not showing your full 
>> search request, but did you provide that in the request?   Have you perhaps 
>> turned off parameter substitutions?
>> 
>>  Erik
>> 
>>> On Feb 27, 2017, at 9:26 PM, Walter Underwood  wrote:
>>> 
>>> With this in the config…
>>> 
>>> 
>>>
>>>   
>>> edismax
>>> 0
>>> false
>>> id,
>>> image_thumb_large, image_thumb_medium, image_thumb_small,
>>> image_thumb_xlarge, uri, user_id, last_name, first_name,
>>> name, school, major, graduation_year, tutor_profile_id,
>>> positive_reviews, negative_reviews, gender, about_experience,
>>> about_extracurricular, time_approved
>>> *:*
>>> about_experience  about_extracurricular School  
>>> Major
>>> 
>>> >> name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>>  desc
>>> log(sum(1,max(positive_reviews,0)))
>>> 0.1
>>>   
>>> 
>>> 
>>> I see this… [Solr 6.3.0]
>>> 
>>> org.apache.solr.common.SolrException: Unable to reload core 
>>> [tutors_shard1_replica11]
>>> at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>>> at 
>>> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>>> at 
>>> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>>> at java.lang.Thread.run(Thread.java:745)
>>> Caused by: org.apache.solr.common.SolrException: Could not load conf for 
>>> core tutors_shard1_replica11: Error loading solr config from solrconfig.xml
>>> at 
>>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>>> at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>>> ... 3 more
>>> Caused by: org.apache.solr.common.SolrException: Error loading solr config 
>>> from solrconfig.xml
>>> at 
>>> org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
>>> at 
>>> org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
>>> at 
>>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
>>> ... 4 more
>>> Caused by: org.apache.solr.common.SolrException: No system property or 
>>> default value specified for scores 
>>> value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>>  desc
>>> at 
>>> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>>> at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
>>> 
>>> wunder
>>> Walter Underwood
>>> wun...@wunderwood.org
>>> http://observer.wunderwood.org/  (my blog)
>>> 
>>> 
 On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
 
 Walter -
 
 How about this, for the latter part of your request:
 
 /handler?features=a,b,c
 
  with =sum(${features}) desc
 
 That ought to do the trick.   At first I thought the #foreach nature of 
 the list of features was prohibitive, but since you’re literally plugging 
 in the exact string value and it’s used as a comma-separated list then 
 this should work.
 
 But with the just a list of subject ID’s I think you’re in custom 
 development now (or a JavaScript stage in a Fusion query pipeline ;) in 
 building a SearchComponent that takes a `features` parameter and builds 
 the sort param as needed from that.
 
Erik
 
 
 
> On Feb 27, 2017, at 7:17 PM, Walter Underwood  
> wrote:
> 
> We have documents with parameterized features. For a school subject 
> (calculus, accounting), we have three sets of features. So for subject=4 
> and subject=186, we have:
> 
> feature_a_4: 0.9
> feature_b_4: 1.6
> feature_c_4: 8.2
> feature_a_186: 3.0
> feature_b_186: 2.1
> feature_c_186: 99.2
> 
> I’d like to pass in the subject IDs and make a function query (for 
> sorting) from those, ending up with
> 
> sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
> feature_a_186, 

Re: Using parameter values in a sort

[Erik Hatcher]

And by turning off parameter substitutions I meant disable `expandMacros` - 
https://cwiki.apache.org/confluence/display/solr/Parameter+Substitution 


Likely you haven’t and this feature should work.   I’d remove `scores` from 
your config (unless you’re going to provide a valid default, by maybe moving 
where  you put “desc” in the parameters) and provide that as a mandatory (or 
optional depending on how you arrange the params, possibly) `scores` param.


   /select?q=*:*=feature_a_1,feature_b_2
 =sum(${scores}) desc




> On Feb 27, 2017, at 9:35 PM, Erik Hatcher  wrote:
> 
> You have an empty “scores” parameter in there.  You’re not showing your full 
> search request, but did you provide that in the request?   Have you perhaps 
> turned off parameter substitutions?
> 
>   Erik
> 
> 
> 
> 
>> On Feb 27, 2017, at 9:26 PM, Walter Underwood  wrote:
>> 
>> With this in the config…
>> 
>> 
>> 
>>
>>  edismax
>>  0
>>  false
>>  id,
>>  image_thumb_large, image_thumb_medium, image_thumb_small,
>>  image_thumb_xlarge, uri, user_id, last_name, first_name,
>>  name, school, major, graduation_year, tutor_profile_id,
>>  positive_reviews, negative_reviews, gender, about_experience,
>>  about_extracurricular, time_approved
>>  *:*
>>  about_experience  about_extracurricular School  
>> Major
>>  
>>  > name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>  desc
>>  log(sum(1,max(positive_reviews,0)))
>>  0.1
>>
>> 
>> 
>> I see this… [Solr 6.3.0]
>> 
>> org.apache.solr.common.SolrException: Unable to reload core 
>> [tutors_shard1_replica11]
>>  at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>>  at 
>> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>>  at 
>> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>>  at java.lang.Thread.run(Thread.java:745)
>> Caused by: org.apache.solr.common.SolrException: Could not load conf for 
>> core tutors_shard1_replica11: Error loading solr config from solrconfig.xml
>>  at 
>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>>  at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>>  ... 3 more
>> Caused by: org.apache.solr.common.SolrException: Error loading solr config 
>> from solrconfig.xml
>>  at 
>> org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
>>  at 
>> org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
>>  at 
>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
>>  ... 4 more
>> Caused by: org.apache.solr.common.SolrException: No system property or 
>> default value specified for scores 
>> value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>  desc
>>  at 
>> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>>  at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
>> 
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/  (my blog)
>> 
>> 
>>> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
>>> 
>>> Walter -
>>> 
>>> How about this, for the latter part of your request:
>>> 
>>> /handler?features=a,b,c
>>> 
>>>   with =sum(${features}) desc
>>> 
>>> That ought to do the trick.   At first I thought the #foreach nature of the 
>>> list of features was prohibitive, but since you’re literally plugging in 
>>> the exact string value and it’s used as a comma-separated list then this 
>>> should work.
>>> 
>>> But with the just a list of subject ID’s I think you’re in custom 
>>> development now (or a JavaScript stage in a Fusion query pipeline ;) in 
>>> building a SearchComponent that takes a `features` parameter and builds the 
>>> sort param as needed from that.
>>> 
>>> Erik
>>> 
>>> 
>>> 
 On Feb 27, 2017, at 7:17 PM, Walter Underwood  
 wrote:
 
 We have documents with parameterized features. For a school subject 
 (calculus, accounting), we have three sets of features. So for subject=4 
 and subject=186, we have:
 
 feature_a_4: 0.9
 feature_b_4: 1.6
 feature_c_4: 8.2
 feature_a_186: 3.0
 feature_b_186: 2.1
 feature_c_186: 99.2
 
 I’d like to pass in the subject IDs and make a function query (for 
 sorting) from those, ending up with
 
 sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
 feature_a_186, feature_b_186, feature c_186) desc
 
 That would be used for the sort parameter.
 
 Failing that, it would be nice 

Re: Using parameter values in a sort

[Walter Underwood]

I’ve passed in a score parameter, but the solrconfig.xml is rejected before any 
requests.

Pretty ready to give up. The documentation around function queries and params 
is not working for me, though I’ve been using Solr for ten years. I have 
figured out a lot of systems. This is impenetrable.

wunder
Walter Underwood
wun...@wunderwood.org
http://observer.wunderwood.org/  (my blog)


> On Feb 27, 2017, at 6:35 PM, Erik Hatcher  wrote:
> 
> You have an empty “scores” parameter in there.  You’re not showing your full 
> search request, but did you provide that in the request?   Have you perhaps 
> turned off parameter substitutions?
> 
>   Erik
> 
>> On Feb 27, 2017, at 9:26 PM, Walter Underwood  wrote:
>> 
>> With this in the config…
>> 
>> 
>> 
>>
>>  edismax
>>  0
>>  false
>>  id,
>>  image_thumb_large, image_thumb_medium, image_thumb_small,
>>  image_thumb_xlarge, uri, user_id, last_name, first_name,
>>  name, school, major, graduation_year, tutor_profile_id,
>>  positive_reviews, negative_reviews, gender, about_experience,
>>  about_extracurricular, time_approved
>>  *:*
>>  about_experience  about_extracurricular School  
>> Major
>>  
>>  > name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>  desc
>>  log(sum(1,max(positive_reviews,0)))
>>  0.1
>>
>> 
>> 
>> I see this… [Solr 6.3.0]
>> 
>> org.apache.solr.common.SolrException: Unable to reload core 
>> [tutors_shard1_replica11]
>>  at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>>  at 
>> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>>  at 
>> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>>  at java.lang.Thread.run(Thread.java:745)
>> Caused by: org.apache.solr.common.SolrException: Could not load conf for 
>> core tutors_shard1_replica11: Error loading solr config from solrconfig.xml
>>  at 
>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>>  at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>>  ... 3 more
>> Caused by: org.apache.solr.common.SolrException: Error loading solr config 
>> from solrconfig.xml
>>  at 
>> org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
>>  at 
>> org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
>>  at 
>> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
>>  ... 4 more
>> Caused by: org.apache.solr.common.SolrException: No system property or 
>> default value specified for scores 
>> value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>>  desc
>>  at 
>> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>>  at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
>> 
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/  (my blog)
>> 
>> 
>>> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
>>> 
>>> Walter -
>>> 
>>> How about this, for the latter part of your request:
>>> 
>>> /handler?features=a,b,c
>>> 
>>>   with =sum(${features}) desc
>>> 
>>> That ought to do the trick.   At first I thought the #foreach nature of the 
>>> list of features was prohibitive, but since you’re literally plugging in 
>>> the exact string value and it’s used as a comma-separated list then this 
>>> should work.
>>> 
>>> But with the just a list of subject ID’s I think you’re in custom 
>>> development now (or a JavaScript stage in a Fusion query pipeline ;) in 
>>> building a SearchComponent that takes a `features` parameter and builds the 
>>> sort param as needed from that.
>>> 
>>> Erik
>>> 
>>> 
>>> 
 On Feb 27, 2017, at 7:17 PM, Walter Underwood  
 wrote:
 
 We have documents with parameterized features. For a school subject 
 (calculus, accounting), we have three sets of features. So for subject=4 
 and subject=186, we have:
 
 feature_a_4: 0.9
 feature_b_4: 1.6
 feature_c_4: 8.2
 feature_a_186: 3.0
 feature_b_186: 2.1
 feature_c_186: 99.2
 
 I’d like to pass in the subject IDs and make a function query (for 
 sorting) from those, ending up with
 
 sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
 feature_a_186, feature_b_186, feature c_186) desc
 
 That would be used for the sort parameter.
 
 Failing that, it would be nice so just pass in the parameterized portion, 
 like this:
 
 /handler?features=feature_a_4,feature_b_4,feature_c_4,feature_a_186,feature_b_186,feature
  c_186
 
 Right now, I can’t even make a 

Re: Using parameter values in a sort

[Erik Hatcher]

You have an empty “scores” parameter in there.  You’re not showing your full 
search request, but did you provide that in the request?   Have you perhaps 
turned off parameter substitutions?

Erik




> On Feb 27, 2017, at 9:26 PM, Walter Underwood  wrote:
> 
> With this in the config…
> 
> 
>  
> 
>   edismax
>   0
>   false
>   id,
>   image_thumb_large, image_thumb_medium, image_thumb_small,
>   image_thumb_xlarge, uri, user_id, last_name, first_name,
>   name, school, major, graduation_year, tutor_profile_id,
>   positive_reviews, negative_reviews, gender, about_experience,
>   about_extracurricular, time_approved
>   *:*
>   about_experience  about_extracurricular School  
> Major
>   
>name="sort">sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>  desc
>   log(sum(1,max(positive_reviews,0)))
>   0.1
> 
>  
> 
> I see this… [Solr 6.3.0]
> 
> org.apache.solr.common.SolrException: Unable to reload core 
> [tutors_shard1_replica11]
>   at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
>   at 
> org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
>   at 
> org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
>   at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.solr.common.SolrException: Could not load conf for core 
> tutors_shard1_replica11: Error loading solr config from solrconfig.xml
>   at 
> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
>   at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
>   ... 3 more
> Caused by: org.apache.solr.common.SolrException: Error loading solr config 
> from solrconfig.xml
>   at 
> org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
>   at 
> org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
>   at 
> org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
>   ... 4 more
> Caused by: org.apache.solr.common.SolrException: No system property or 
> default value specified for scores 
> value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
>  desc
>   at 
> org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
>   at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 
>> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
>> 
>> Walter -
>> 
>> How about this, for the latter part of your request:
>> 
>>  /handler?features=a,b,c
>> 
>>with =sum(${features}) desc
>> 
>> That ought to do the trick.   At first I thought the #foreach nature of the 
>> list of features was prohibitive, but since you’re literally plugging in the 
>> exact string value and it’s used as a comma-separated list then this should 
>> work.
>> 
>> But with the just a list of subject ID’s I think you’re in custom 
>> development now (or a JavaScript stage in a Fusion query pipeline ;) in 
>> building a SearchComponent that takes a `features` parameter and builds the 
>> sort param as needed from that.
>> 
>>  Erik
>> 
>> 
>> 
>>> On Feb 27, 2017, at 7:17 PM, Walter Underwood  wrote:
>>> 
>>> We have documents with parameterized features. For a school subject 
>>> (calculus, accounting), we have three sets of features. So for subject=4 
>>> and subject=186, we have:
>>> 
>>> feature_a_4: 0.9
>>> feature_b_4: 1.6
>>> feature_c_4: 8.2
>>> feature_a_186: 3.0
>>> feature_b_186: 2.1
>>> feature_c_186: 99.2
>>> 
>>> I’d like to pass in the subject IDs and make a function query (for sorting) 
>>> from those, ending up with
>>> 
>>> sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
>>> feature_a_186, feature_b_186, feature c_186) desc
>>> 
>>> That would be used for the sort parameter.
>>> 
>>> Failing that, it would be nice so just pass in the parameterized portion, 
>>> like this:
>>> 
>>> /handler?features=feature_a_4,feature_b_4,feature_c_4,feature_a_186,feature_b_186,feature
>>>  c_186
>>> 
>>> Right now, I can’t even make a solrconfig.xml that will load. I’ve read 
>>> everything I can find on params and function queries.
>>> 
>>> wunder
>>> Walter Underwood
>>> wun...@wunderwood.org
>>> http://observer.wunderwood.org/  (my blog)
>>> 
>>> 
>> 
> 

Re: Using parameter values in a sort

[Walter Underwood]

With this in the config…

 
  
 
   edismax
   0
   false
   id,
   image_thumb_large, image_thumb_medium, image_thumb_small,
   image_thumb_xlarge, uri, user_id, last_name, first_name,
   name, school, major, graduation_year, tutor_profile_id,
   positive_reviews, negative_reviews, gender, about_experience,
   about_extracurricular, time_approved
   *:*
   about_experience  about_extracurricular School  
Major
   
   sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
 desc
   log(sum(1,max(positive_reviews,0)))
   0.1
 
  

I see this… [Solr 6.3.0]

org.apache.solr.common.SolrException: Unable to reload core 
[tutors_shard1_replica11]
at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:950)
at 
org.apache.solr.core.SolrCore.lambda$getConfListener$6(SolrCore.java:2708)
at 
org.apache.solr.cloud.ZkController.lambda$fireEventListeners$4(ZkController.java:2448)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.solr.common.SolrException: Could not load conf for core 
tutors_shard1_replica11: Error loading solr config from solrconfig.xml
at 
org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:85)
at org.apache.solr.core.CoreContainer.reload(CoreContainer.java:942)
... 3 more
Caused by: org.apache.solr.common.SolrException: Error loading solr config from 
solrconfig.xml
at 
org.apache.solr.core.SolrConfig.readFromResourceLoader(SolrConfig.java:187)
at 
org.apache.solr.core.ConfigSetService.createSolrConfig(ConfigSetService.java:97)
at 
org.apache.solr.core.ConfigSetService.getConfig(ConfigSetService.java:77)
... 4 more
Caused by: org.apache.solr.common.SolrException: No system property or default 
value specified for scores 
value:sum(interaction_responsiveness_score,profile_completeness_score,school_score,us_tax_id_score,highlight_score,${scores})
 desc
at 
org.apache.solr.util.PropertiesUtil.substituteProperty(PropertiesUtil.java:65)
at org.apache.solr.util.DOMUtil.substituteProperties(DOMUtil.java:298)

wunder
Walter Underwood
wun...@wunderwood.org
http://observer.wunderwood.org/  (my blog)


> On Feb 27, 2017, at 6:17 PM, Erik Hatcher  wrote:
> 
> Walter -
> 
> How about this, for the latter part of your request:
> 
>   /handler?features=a,b,c
> 
> with =sum(${features}) desc
> 
> That ought to do the trick.   At first I thought the #foreach nature of the 
> list of features was prohibitive, but since you’re literally plugging in the 
> exact string value and it’s used as a comma-separated list then this should 
> work.
> 
> But with the just a list of subject ID’s I think you’re in custom development 
> now (or a JavaScript stage in a Fusion query pipeline ;) in building a 
> SearchComponent that takes a `features` parameter and builds the sort param 
> as needed from that.
> 
>   Erik
> 
> 
> 
>> On Feb 27, 2017, at 7:17 PM, Walter Underwood  wrote:
>> 
>> We have documents with parameterized features. For a school subject 
>> (calculus, accounting), we have three sets of features. So for subject=4 and 
>> subject=186, we have:
>> 
>> feature_a_4: 0.9
>> feature_b_4: 1.6
>> feature_c_4: 8.2
>> feature_a_186: 3.0
>> feature_b_186: 2.1
>> feature_c_186: 99.2
>> 
>> I’d like to pass in the subject IDs and make a function query (for sorting) 
>> from those, ending up with
>> 
>> sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
>> feature_a_186, feature_b_186, feature c_186) desc
>> 
>> That would be used for the sort parameter.
>> 
>> Failing that, it would be nice so just pass in the parameterized portion, 
>> like this:
>> 
>> /handler?features=feature_a_4,feature_b_4,feature_c_4,feature_a_186,feature_b_186,feature
>>  c_186
>> 
>> Right now, I can’t even make a solrconfig.xml that will load. I’ve read 
>> everything I can find on params and function queries.
>> 
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/  (my blog)
>> 
>> 
> 

Re: Using parameter values in a sort

[Erik Hatcher]

Walter -

How about this, for the latter part of your request:

   /handler?features=a,b,c

 with =sum(${features}) desc

That ought to do the trick.   At first I thought the #foreach nature of the 
list of features was prohibitive, but since you’re literally plugging in the 
exact string value and it’s used as a comma-separated list then this should 
work.

But with the just a list of subject ID’s I think you’re in custom development 
now (or a JavaScript stage in a Fusion query pipeline ;) in building a 
SearchComponent that takes a `features` parameter and builds the sort param as 
needed from that.

Erik



> On Feb 27, 2017, at 7:17 PM, Walter Underwood  wrote:
> 
> We have documents with parameterized features. For a school subject 
> (calculus, accounting), we have three sets of features. So for subject=4 and 
> subject=186, we have:
> 
> feature_a_4: 0.9
> feature_b_4: 1.6
> feature_c_4: 8.2
> feature_a_186: 3.0
> feature_b_186: 2.1
> feature_c_186: 99.2
> 
> I’d like to pass in the subject IDs and make a function query (for sorting) 
> from those, ending up with
> 
> sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
> feature_a_186, feature_b_186, feature c_186) desc
> 
> That would be used for the sort parameter.
> 
> Failing that, it would be nice so just pass in the parameterized portion, 
> like this:
> 
> /handler?features=feature_a_4,feature_b_4,feature_c_4,feature_a_186,feature_b_186,feature
>  c_186
> 
> Right now, I can’t even make a solrconfig.xml that will load. I’ve read 
> everything I can find on params and function queries.
> 
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
> 
> 

Re: Using parameter values in a sort

[Erick Erickson]

Hmm, the syntax can be tricky. I'd start with a vanilla solrconfig.xml and
get the syntax right just with curl or the browser, _then_ go to
trying to embed it in solrconfig.xml.

What error are you getting anyway?

Erick

On Mon, Feb 27, 2017 at 4:17 PM, Walter Underwood  wrote:
> We have documents with parameterized features. For a school subject 
> (calculus, accounting), we have three sets of features. So for subject=4 and 
> subject=186, we have:
>
> feature_a_4: 0.9
> feature_b_4: 1.6
> feature_c_4: 8.2
> feature_a_186: 3.0
> feature_b_186: 2.1
> feature_c_186: 99.2
>
> I’d like to pass in the subject IDs and make a function query (for sorting) 
> from those, ending up with
>
> sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, 
> feature_a_186, feature_b_186, feature c_186) desc
>
> That would be used for the sort parameter.
>
> Failing that, it would be nice so just pass in the parameterized portion, 
> like this:
>
> /handler?features=feature_a_4,feature_b_4,feature_c_4,feature_a_186,feature_b_186,feature
>  c_186
>
> Right now, I can’t even make a solrconfig.xml that will load. I’ve read 
> everything I can find on params and function queries.
>
> wunder
> Walter Underwood
> wun...@wunderwood.org
> http://observer.wunderwood.org/  (my blog)
>
>

Using parameter values in a sort

[Walter Underwood]

We have documents with parameterized features. For a school subject (calculus, 
accounting), we have three sets of features. So for subject=4 and subject=186, 
we have:

feature_a_4: 0.9
feature_b_4: 1.6
feature_c_4: 8.2
feature_a_186: 3.0
feature_b_186: 2.1
feature_c_186: 99.2

I’d like to pass in the subject IDs and make a function query (for sorting) 
from those, ending up with

sum(feature_x, feature_y, feature_a_4, feature_b_4, feature_c_4, feature_a_186, 
feature_b_186, feature c_186) desc

That would be used for the sort parameter.

Failing that, it would be nice so just pass in the parameterized portion, like 
this:

/handler?features=feature_a_4,feature_b_4,feature_c_4,feature_a_186,feature_b_186,feature
 c_186

Right now, I can’t even make a solrconfig.xml that will load. I’ve read 
everything I can find on params and function queries.

wunder
Walter Underwood
wun...@wunderwood.org
http://observer.wunderwood.org/  (my blog)