Yes indeed, my bad, I didn’t describe this correctly… at all. Still one question, is there a way to change the sort order for date range facets? Or do I do that on my end? There are some cases where I want to see results in count order, other cases where I want to see results sort on the button range.
> On Apr 4, 2023, at 3:12 PM, Chris Hostetter <hossman_luc...@fucit.org> wrote: > > > : I see no way to change the sort order to index (I want the output in > : date order), I get results sorted on the count. I have tried adding the > : sort field like so: > > This ... doesn't make sense. > > AFAIK "index" order (or more specifically: The "natural order" of the > bucket values) is the only possible sorting returned by JSON Range Facet > > ie: what you are asking for should be what you are getting, what you say > you are getting shouldn't be possible. > (see examples below) > > > What does your solrj code that consumes the QueryResponse look like? > > > $ curl 'http://localhost:8983/solr/techproducts/query?rows=0&omitHeader=true' > -d ' > { > "query": "*:*", > "facet": { > "prices": { > "type": "range", > "field": "price", > "start": 0, > "end": 100, > "gap": 20 > } > } > }' > { > "response":{"numFound":32,"start":0,"numFoundExact":true,"docs":[] > }, > "facets":{ > "count":32, > "prices":{ > "buckets":[{ > "val":0.0, > "count":5}, > { > "val":20.0, > "count":0}, > { > "val":40.0, > "count":0}, > { > "val":60.0, > "count":1}, > { > "val":80.0, > "count":1}]}}} > > > $ curl > 'http://localhost:8983/solr/techproducts/query?rows=0&omitHeader=true' -d' > { > "query": "*:*", > "facet": { > "prices": { > "type": "range", > "field": "manufacturedate_dt", > "start": "1900-01-01T00:00:00Z", > "end": "2200-01-01T00:00:00Z", > "gap": "+100YEARS" > } > } > }' > { > "response":{"numFound":32,"start":0,"numFoundExact":true,"docs":[] > }, > "facets":{ > "count":32, > "prices":{ > "buckets":[{ > "val":"1900-01-01T00:00:00Z", > "count":0}, > { > "val":"2000-01-01T00:00:00Z", > "count":11}, > { > "val":"2100-01-01T00:00:00Z", > "count":0}]}}} > > Here's a test that uses SollrJ to assert that the execpted buckets come > back in the expected order (by bucket value, not by bucket count) ... > > https://github.com/apache/solr/blob/releases/solr/9.0.0/solr/solrj/src/test/org/apache/solr/client/ref_guide_examples/JsonRequestApiTest.java#L573-L596 > > > > > > > -Hoss > http://www.lucidworks.com/
