: Because the value of the function will be treated as a relevance value
: and relevance value of 0 (and less?) will cause the record to be
: filtered out.
I don't believe that's true? ... IIRC 'fq' doesn't care what the scores
are as long as the query is a "match" and a 'func' query will match as
long as the function says it matches ... something like sub() should be a
match as long sa both fields exist in the document.
Pretty sure the simplest version of what you want is
'fq={!func}gt(value,cost)' .. of if you need more complex functions/rules
you can use the 'frange' QParser to only match documents where the result
of an equation is in a specific range of values...
https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-FunctionRangeQueryParser
: On 1 June 2017 at 13:46, Mikhail Ibraheem
: <[email protected]> wrote:
: > Hi,I have 2 fields "cost" and "value" at my records. I want to get all
documents that have "value" greater than "cost". Something likeq=value:[cost TO
*]
: > Please advise.
: > Thanks
:
-Hoss
http://www.lucidworks.com/