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

Reply via email to