Compare (Field Expression)

The Compare  field expression compare the values of two stored fields (using EQ, NE, and various inequality tests) resulting in a new field containing a Boolean (true/false) outcome.  For instance, the following examples take Factbook Olympic Medal search results and test to see if the number of gold medals is the same as the number of silver medals for each result. 

Available Functions (See here ):

• EQ – Equal To (==)

• GT – Greater Than (>)

• LE – Less Than or Equal To (<=)

• LT – Less Than (<)

• NE – Not Equal To (<> or !=)

Example:

QueryRequest request = new QueryRequest("*:*)");
request.addField(new Compare(Compare.Operator.EQ, new StoredField("gold_i"), new StoredField("silver_i"),"Gold=Silver?"));
// ... (Perform Search)

REST Syntax:

Example:

&fields=EQ("gold_i","silver_i") as "Gold=Silver?"