In the last \u201ccar sale application\u201d related post we have described the result grouping functionality. Today I would like to show you how easily we can determine the groups amount and how to sort documents within every group.<\/p>\n\n\n\n\n\n
I would like to be able to create a grouping query, that will show me the number of generated groups and provide only one result within every group \u2013 the one with the lowest price in its year group.<\/p>\n
What we need is:<\/p>\n
Using the query example from the previous post, let’s add two new parameters:\n<\/p>\n
?q=audi+a4&group=true&group.field=year_group&group.limit=1&fl=id,mileage,make,model,year,price&group.ngroups=true&group.sort=price+asc<\/pre>\nAs you see, we’ve also set the group.limit parameter to 1 (in order to have the only one result within every group) and extended the value of fl parameter by adding the price field. As a result we have the response:\n<\/p>\n
<lst name=\"grouped\">\n <lst name=\"year_group\">\n <int name=\"matches\">5<\/int>\n <int name=\"ngroups\">3<\/int>\n <arr name=\"groups\">\n <lst>\n <str name=\"groupValue\">2002<\/str>\n <result name=\"doclist\" numFound=\"2\" start=\"0\">\n <doc>\n <str name=\"id\">3<\/str>\n <str name=\"make\">Audi<\/str>\n <int name=\"mileage\">125000<\/int>\n <str name=\"model\">A4<\/str>\n <float name=\"price\">21300.0<\/float>\n <int name=\"year\">2002<\/int>\n <\/doc>\n <\/result>\n <\/lst>\n <lst>\n <str name=\"groupValue\">2003<\/str>\n <result name=\"doclist\" numFound=\"2\" start=\"0\">\n <doc>\n <str name=\"id\">2<\/str>\n <str name=\"make\">Audi<\/str>\n <int name=\"mileage\">220000<\/int>\n <str name=\"model\">A4<\/str>\n <float name=\"price\">27800.0<\/float>\n <int name=\"year\">2003<\/int>\n <\/doc>\n <\/result>\n <\/lst>\n <lst>\n <str name=\"groupValue\">2006<\/str>\n <result name=\"doclist\" numFound=\"1\" start=\"0\">\n <doc>\n <str name=\"id\">5<\/str>\n <str name=\"make\">Audi<\/str>\n <int name=\"mileage\">9900<\/int>\n <str name=\"model\">A4<\/str>\n <float name=\"price\">32100.0<\/float>\n <int name=\"year\">2006<\/int>\n <\/doc>\n <\/result>\n <\/lst>\n <\/arr>\n <\/lst>\n<\/lst><\/pre>\nAs we see in the response, we have a new element that shows us how many groups are generated:\n<\/p>\n
<int name=\"ngroups\">3<\/int><\/pre>\nWe also have only one document in each year group \u2013 the car with the lowest price in its year group. You don’t believe me ? Look at the query responses from the previous post and compare the prices \ud83d\ude42<\/p>\n
The end<\/h3>\n
It was a fast review of yet two another grouping parameters. Big thanks to David Martin who gave me the subject by asking some questions in the previous post \ud83d\ude42<\/p>","protected":false},"excerpt":{"rendered":"
In the last \u201ccar sale application\u201d related post we have described the result grouping functionality. Today I would like to show you how easily we can determine the groups amount and how to sort documents within every group.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"categories":[27],"tags":[],"class_list":["post-361","post","type-post","status-publish","format-standard","hentry","category-solr-en"],"_links":{"self":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts\/361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/comments?post=361"}],"version-history":[{"count":1,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts\/361\/revisions"}],"predecessor-version":[{"id":362,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/posts\/361\/revisions\/362"}],"wp:attachment":[{"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/media?parent=361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/categories?post=361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solr.pl\/en\/wp-json\/wp\/v2\/tags?post=361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}