My documents have two prices "retail_price" and "current_price". I want to get products which have a sale of x%, the x is dynamic and can be specified by the user. I was trying to achieve this by using fq.
If I want all sony tv's that are at least 20% off, I want to write something like q="sony tv"&fq=current_price:[0 TO product(retail_price,0.80)] this does not work as the function is not expected in fq. how else can I achieve this? Thanks
