Sum and aggregation on nested documents field

[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":"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