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",
"type_parent_s":"Société",
"groupe_type_parent_s":"SOCIETE",
"nombre_commandes_brut_i":121,
"nombre_commandes_i":101,
"nombre_kits_saveur_i":0,
"ca_periode_i":60524,
"ca_periode_fleur_i":0,
"ca_periode_saveur_i":58148,
"zone_scolaire_s":"B",
"territoire_s":"France Métropolitaine",
"region_s":"CENTRE VAL DE LOIRE",
"departement_s":"45 LOIRET",
"postal_country_s":"FR",
"asso_country_s":"FRANCE",
"object_type_s":"contact",
"date_derni_re_commande_dt":"2016-04-21T00:00:00Z",
"_version_":1605523881394177,
*"score":308940.0*,
"_childDocuments_":[
{
"fixe_facturation":["0238756400"],
"object_type":["order"],
"TTC_i":29120,
"kit_sans_suite":["false"],
"fixe_livraison":["0238756400"],
"type_cde_s":"CDE",
"statut_s":"V",
"campagne_s":"A",
"date_dt":"2016-04-19T00:00:00Z",
"id":"A22058",
"enseigne_s":"SAV",
"gamme":["CHOCOLAT > Assortiment",
"CHOCOLAT > Mono-produit",
"EQUIPEMENT MAISON > Contenant pour liquide",
"SAVEURS > Pâtisserie"]},
{
"fixe_facturation":["0238765400"],
"object_type":["order"],
"TTC_i":429,
"kit_sans_suite":["false"],
"fixe_livraison":["0238756400"],
"type_cde_s":"CDE",
"statut_s":"V",
"campagne_s":"A",
"date_dt":"2016-04-21T00:00:00Z",
"id":"A22511",
"enseigne_s":"BRI",
"gamme":["SAVEURS > Pâtisserie"]}
The query looks like that :
/solr/<core>/select?chq=%2Bobject_type:order%20{!func}TTC_i&debugQuery=on&fl=*,score,[child%20parentFilter=object_type_s:contact]&indent=on&q={!parent%20which=object_type_s:contact%20score=total%20v=$chq}&wt=json
I also test the queries on the SOLR admin interface, and when I get what I
expect, I work on the development of the IHM which provides facet counting
and filtering for users.
The total score of TTC is a great advanced for me, but I need now to facet
the results or to be able to filter on the score returned.
I already tried using frange in filter query : {!frange l=0 u=10000
inclusive=true}$chq
I also tried : {!frange l=0 u=10000 inclusive=true}TTC_i
With inclusive = false... Without any result.
I know I'm not so far, could you put me on the right way if you have an idea
?
Thanks for your time,
Best
JB
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
