Parameter Dereferencing with function queries in solr json facet

[Venu]

I am using solr6.6. I am trying to use parameter Dereferencing for json
facets.

There can be multiple prices for all the documents(assume sp, price1,
price2, price3, price4 are the prices for all the documents).

Based on the query, I have to fetch the minimum value among the combination
of those prices and create facets among them.

It can be done with frange. But is there a way that this can be done with
json facets?

Below sample query works:

localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}
&FIELD=sp

But when I try to use something like this:

localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}&FIELD=min(price1, price2, price3, sp)

My other query can be like as below:

localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}&FIELD=min(price1, price3, sp)

or

localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}&FIELD=min(price1, price2)

I can use any kind combination like (price1, price2) or (price4, sp).. etc

I am getting below error:

<lst name="error">
<lst name="metadata">
<str name="error-class">org.apache.solr.common.SolrException</str>
<str name="root-error-class">org.apache.solr.parser.ParseException</str>
</lst>
<str name="msg">
org.apache.solr.search.SyntaxError: Cannot parse 'min(price1, price2,
price3):[0 TO 20]': Encountered " ":" ": "" at line 1, column 12. Was
expecting one of: <EOF> <AND> ... <OR> ... <NOT> ... "+" ... "-" ...
<BAREOPER> ... "(" ... "*" ... "^" ... <QUOTED> ... <TERM> ... <PREFIXTERM>
... <WILDTERM> ... <REGEXPTERM> ... "[" ... "{" ... <LPARAMS> ... "filter("
... <NUMBER> ...
</str>
<int name="code">400</int>
</lst>
Is it possible to do function query while forming query?



--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

[Mikhail Khludnev]

One can not apply range query syntax over function. {!frange} query parser
can handle that.

Post by Venu
I am using solr6.6. I am trying to use parameter Dereferencing for json
facets.
There can be multiple prices for all the documents(assume sp, price1,
price2, price3, price4 are the prices for all the documents).
Based on the query, I have to fetch the minimum value among the combination
of those prices and create facets among them.
It can be done with frange. But is there a way that this can be done with
json facets?
localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}
&FIELD=sp
localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}&FIELD=min(price1, price2, price3, sp)
localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}&FIELD=min(price1, price3, sp)
or
localhost:8983/solrcloud/myconf/select?q=apple&
json.facet={
'prices':{
'type': 'query',
'q': "${FIELD}:[0 TO 20]"
}
}&FIELD=min(price1, price2)
I can use any kind combination like (price1, price2) or (price4, sp).. etc
<lst name="error">
<lst name="metadata">
<str name="error-class">org.apache.solr.common.SolrException</str>
<str name="root-error-class">org.apache.solr.parser.ParseException</str>
</lst>
<str name="msg">
org.apache.solr.search.SyntaxError: Cannot parse 'min(price1, price2,
price3):[0 TO 20]': Encountered " ":" ": "" at line 1, column 12. Was
expecting one of: <EOF> <AND> ... <OR> ... <NOT> ... "+" ... "-" ...
<BAREOPER> ... "(" ... "*" ... "^" ... <QUOTED> ... <TERM> ... <PREFIXTERM>
... <WILDTERM> ... <REGEXPTERM> ... "[" ... "{" ... <LPARAMS> ... "filter("
... <NUMBER> ...
</str>
<int name="code">400</int>
</lst>
Is it possible to do function query while forming query?
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

[Venu]

Thanks Mikhail



--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html