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":"*,score,[child parentFilter=object_type_s:contact]",
"fq":["_query_:\"{!parent which=object_type_s:contact} (enseigne_s:SAV
AND (type_cde_s:CDE OR type_cde_s:REASSORT) AND campagne_s:G)\"",
"-_query_:\"{!parent which=object_type_s:contact} (enseigne_s:SAV
AND type_cde_s:KIT AND campagne_s:I)\"",
"{!frange l=30000}{!parent which=object_type_s:contact score=total
v=$chq}"],
"chq":"+object_type:order +campagne_s:G +enseigne_s:SAV
+type_cde_s:(CDE OR REASSORT) {!func}TTC_i",
"wt":"json",
"debugQuery":"on",
"_":"1531145722719"}},
"response":{"numFound":2,"start":0,"maxScore":31640.16,"docs":[
{
"id":"94000.94001.1117636",
"parent_i":94000,
"asso_i":94001,
"personne_i":1117636,
"object_type_s":"contact",
"date_derni_re_commande_dt":"2017-11-13T00:00:00Z",
"_version_":1605583100313600002,
*"score":31640.16*,
"_childDocuments_":[
{
"object_type":["order"],
"TTC_i":0,
"type_cde_s":"KIT",
"campagne_s":"G",
"enseigne_s":"SAV"
},
{
"object_type":["order"],
"TTC_i":31636,
"type_cde_s":"CDE",
"campagne_s":"G",
"enseigne_s":"SAV"
}
I already get the TTC_i sum, by parent document with the "score" parameter.
If I correctly understand, the {!frange} allows me to filter on that
"score", so I can get the result of that question : "get the parent which
sum of TTC_i, with campagne_s:G and enseigne_s:SAV and type_cde_s:CDE or
type_cde_s:REASSORT, is higher than 30000".
If you think it's OK, I get the results I wanted. Then my goal is to build a
facet to get the number of parent docs which answer to the query, with
others constraints (like only one campagne_s, etc).
I think I have to use the json facet API, with facet.pivot for example.
Do you think I'm on the right way ?
Best
JB
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
