Also you'll probably need to specify the /export handler in the search expressions, so you get the entire result set.
qt="/export" Joel Bernstein http://joelsolr.blogspot.com/ On Sat, Oct 1, 2016 at 6:08 PM, Joel Bernstein <joels...@gmail.com> wrote: > Ok, I took a closer look at the expression. I believe this is not > supported: > > sale_price_d!=c_sale_price_d > > Possibly the complement expression might accomplish what you're trying to > do. > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Sat, Oct 1, 2016 at 5:59 PM, Joel Bernstein <joels...@gmail.com> wrote: > >> Hi can you attach the stack traces in the logs? I'd like to see where >> this exception coming, this appears to be a bug. >> >> I'll also need to dig into your expression and see if there is an issue >> with the syntax. >> >> Joel Bernstein >> http://joelsolr.blogspot.com/ >> >> On Sat, Oct 1, 2016 at 2:29 PM, Markko Legonkov <maxl...@gmail.com> >> wrote: >> >>> Hi >>> >>> What i would like to achieve is that i want to filter out all products >>> which have different prices on two given dates. >>> Here is a sample expression >>> >>> leftOuterJoin( >>> search( >>> products, >>> q="*:*", >>> fq="product_id_i:1 AND product_name_s:test", >>> fl="id, product_id_i, product_name_s,sale_price_d", >>> sort="product_id_i asc" >>> ), >>> select( >>> search( >>> products, >>> q="product_id_i:1 AND product_name_s:Test", >>> fl="id, product_id_i, product_name_s,sale_price_d", >>> sort="product_id_i asc" >>> ), >>> id as c_id, >>> product_id_i as c_product_id_i, >>> product_name_s as c_product_name_s, >>> sale_price_d as c_sale_price_d >>> ), >>> on="product_id_i=c_product_id_i, sale_price_d!=c_sale_price_d" >>> ) >>> >>> I am using solr 6.2.0 >>> And the result i get from solr is: >>> { >>> "result-set": { >>> "docs": [ >>> { >>> "EXCEPTION": "org.apache.solr.client.solrj. >>> io.comp.FieldComparator >>> cannot be cast to >>> org.apache.solr.client.solrj.io.comp.MultipleFieldComparator", >>> "EOF": true >>> } >>> ] >>> } >>> } >>> >>> Do i have to configure something in solr that it knows it has to use >>> MultipleFieldComparator? >>> >>> Regards >>> Max >>> >> >> >
