Thank you, Yonik! Looks cool to me. Only problem is it is not working for me. I see you have "cats" and "cat" in your URL. "cat" must be a field name. What is "cats"?
We are doing a POC with facet count ascending. You help is really important to us. On Sat, May 9, 2015 at 8:05 AM, Yonik Seeley <ysee...@gmail.com> wrote: > 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 > >> >