curl -g "http://localhost:8983/solr/techproducts/query?q=*:*&json.facet={cats:{terms:{field:cat,sort:'count+asc'}}}"
Using curl with everything in the URL is definitely trickier. Everything needs to be URL escaped. If it's not, curl will often silently do nothing. For example, when I had sort:'count asc' , the command above would do nothing. When I remembered to URL encode the space as a "+", it started working. It's definitely easier to use "-d" with curl... curl "http://localhost:8983/solr/techproducts/query"; -d 'q=*:*&json.facet={cats:{terms:{field:cat,sort:"count asc"}}}' That also allows you to format it nicer for reading as well: curl "http://localhost:8983/solr/techproducts/query"; -d 'q=*:*&json.facet= {cats:{terms:{ field:cat, sort:"count asc" }}}' -Yonik On Thu, May 7, 2015 at 5:32 PM, Frank li <fudon...@gmail.com> wrote: > This one does not have problem, but how do I include "sort" in this facet > query. Basically, I want to write a solr query which can sort the facet > count ascending. Something like "http://localhost:8983/solr > /demo/query?q=apple&json.facet={field=price sort='count asc'} > <http://localhost:8983/solr/demo/query?q=apple&json.facet=%7Bx:%27avg%28price%29%27%7D> > > I really appreciate your help. > > Frank > > <http://localhost:8983/solr/demo/query?q=apple&json.facet=%7Bx:%27avg%28price%29%27%7D> > > On Thu, May 7, 2015 at 2:24 PM, Yonik Seeley <ysee...@gmail.com> wrote: > >> On Thu, May 7, 2015 at 4:47 PM, Frank li <fudon...@gmail.com> wrote: >> > Hi Yonik, >> > >> > I am reading your blog. It is helpful. One question for you, for >> following >> > example, >> > >> > curl http://localhost:8983/solr/query -d 'q=*:*&rows=0& >> > json.facet={ >> > categories:{ >> > type : terms, >> > field : cat, >> > sort : { x : desc}, >> > facet:{ >> > x : "avg(price)", >> > y : "sum(price)" >> > } >> > } >> > } >> > ' >> > >> > >> > If I want to write it in the format of this: >> > >> http://localhost:8983/solr/query?q=apple&json.facet={x:'avg(campaign_ult_defendant_cnt_is)'} >> , >> > how do I do? >> >> What problems do you encounter when you try that? >> >> If you try that URL with curl, be aware that curly braces {} are >> special globbing characters in curl. Turn them off with the "-g" >> option: >> >> curl -g " >> http://localhost:8983/solr/demo/query?q=apple&json.facet={x:'avg(price)'}" >> >> -Yonik >>
