Re: Sum and aggregation on nested documents field

2018-07-11 Thread jeebix
My apologize Mikhail, I try to explain it better : This is actually what I get from SOLR with the query you helped me to build : "responseHeader":{ "status":0, "QTime":15, "params":{ "q":"{!parent which=object_type_s:contact score=max v=$chq}", "indent":"on", "fl":"*

Re: Sum and aggregation on nested documents field

2018-07-11 Thread Mikhail Khludnev
"to facet the results or to be able to filter on the score returned" This is not clear, you need to clarify it to be replied. On Wed, Jul 11, 2018 at 2:48 AM jeebix wrote: > Hello Mikhail, > > First thanks a lot for your answers which are very useful for me... Then, I > tried the query with t

Re: Sum and aggregation on nested documents field

2018-07-10 Thread jeebix
Hello Mikhail, First thanks a lot for your answers which are very useful for me... Then, I tried the query with the '$' parameter, and I get some great result like this : "id":"693897", "asso_i":693897, "etat_technique_s":"avec_documents", "etat_marketing_s":"actif",

Sum and aggregation on nested documents field

2018-07-10 Thread jeebix
Hello everybody, I have a question about how to retrieve results from SOLR with some aggregation (like sum in my case...) on the nested documents. First, the data SOLR returned with a standard query : { "id":"3911.3912.1278", "parent_i":3191, "asso_i":3112, "pers

Re: Sum and aggregation on nested documents field

2018-07-10 Thread Mikhail Khludnev
Hello, JB. The rule of thumb if that you post what's you have whether it exception or unexpected result with explain. Here I guess you need something like: q={!parent which=object_type_s:contact score=total v=$chq}&chq=+ object_type:order {!func}TTC_i Make sure that + isn't mangled by url ecoding i

Re: Sum and aggregation on nested documents field

2018-07-10 Thread jeebix
Thanks for your reply Mikhail, I tried like this : "{!parent which=object_type_s:contact score=total v={!func}TTC_i}" in a filter query, the same in the sort parameter, I also tried to put this query "{!parent which=object_type_s:contact score=total}TTC_i" into the q parameter, but no results... I

Re: Sum and aggregation on nested documents field

2018-07-10 Thread jeebix
Thanks for your reply Mikhail, I tried like this : "{!parent which=object_type_s:contact score=total v={!func}TTC_i}" in a filter query, the same in the sort parameter, I also tried to put this query "{!parent which=object_type_s:contact score=total}TTC_i" into the q parameter, but no results... I

Re: Sum and aggregation on nested documents field

2018-07-09 Thread Mikhail Khludnev
If you have TTC_i as a function query on child level, and apply score=total on the parent query. On Mon, Jul 9, 2018 at 10:11 AM jeebix wrote: > Hello everybody, > > First, an example of a parent document with 2 nested documents : > > { > "id":"10891.10893.142693", > "parent_i":

Sum and aggregation on nested documents field

2018-07-09 Thread jeebix
Hello everybody, First, an example of a parent document with 2 nested documents : { "id":"10891.10893.142693", "parent_i":10891, "asso_i":10893, "personne_i":142693, "etat_technique_s":"avec_documents", "zone_scolaire_s":"B", "territoire_s":