The JSON Facet API uses the function query parser for something like sum(week_-91) so you'll probably have problems with any function that uses these fields as well. As Erick says, you're better off renaming the fields. There is a workaround for wonky field names via the "field" function: sum(field(week_-91))
-Yonik On Thu, Jan 4, 2018 at 10:02 AM, RAUNAK AGRAWAL <agrawal.rau...@gmail.com> wrote: > Hi Guys, > > I am facing issue where I am trying to follow the JSON facet API. I have > data in my collection and field names are like "week_0", "week_-1" which > means current week and previous week respectively. > > When I am querying for week_0 summation using the following query I am able > to get the result. > > http://localhost:8983/solr/collection1/query?q=*:*&json.facet={week_0_sum:'sum(week_0)'}&rows=0 > > > But when I am trying to do the same for any field "week_-*", it is break. > > For example when I am trying: > http://localhost:8983/solr/collection1/query?q=*:*&json.facet={week_-91_sum:%27sum(week_-91)%27}&rows=0 > > > I am getting the exception as* "msg": "undefined field: \"week_\"''* > > > That means solr is stripping field name after hyphen (-). Is there > workaround to fix this. I tried adding escape character (\) but it is of no > help. > > With escape: > http://localhost:8983/solr/collection1/query?q=*:*&json.facet={week_-91_sum:%27sum(week_\-91)%27}&rows=0 > > > Please help me regarding this. > > Thanks