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 <j...@initiatives.fr> wrote:
> 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":"France Métropolitaine",
> "region_s":"PROVENCE-ALPES-COTE D'AZUR",
> "departement_s":"13 BOUCHES-DU-RHONE",
> "postal_country_s":"FR",
> "asso_country_s":"FRANCE",
> "object_type_s":"contact",
> "date_derni_re_commande_dt":"2017-11-21T00:00:00Z",
> "_version_":1605492468358316033,
> "_childDocuments_":[
> {
> "kit_sans_suite":["false"],
> "TTC_i":152,
> "type_cde_s":"KIT",
> "object_type":["order"],
> "statut_s":"V",
> "campagne_s":"G",
> "date_dt":"2017-09-28T00:00:00Z",
> "id":"G15608",
> "enseigne_s":"SAV",
> "gamme":["CATALOGUES > Catalogues Saveurs",
> "KITS > Kits Saveurs"]},
> {
> "object_type":["order"],
> "TTC_i":2793,
> "kit_sans_suite":["false"],
> "type_cde_s":"CDE",
> "statut_s":"V",
> "campagne_s":"G",
> "date_dt":"2017-11-21T00:00:00Z",
> "id":"G43625",
> "enseigne_s":"SAV",
> }
> }
>
> And i would like to get a sum of TTC_i field, by parent document... I tried
> with stats, pivot, without any results...
>
> Thanks for your help.
>
> Best
> JB
>
>
>
> --
> Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
>
--
Sincerely yours
Mikhail Khludnev
