Less-than and greater-than range filters

Two EQL operators allow you to make less-than and greater-than range filter queries.

You make these types of queries as follows:

To make a less-than query, use only the < (less-than) operator. Because you are specifying only the upper bound of the range, all returned records will fall below this bound (i.e., be less than the upper bound).
To make a greater-than query, use only the > (greater-than) operator. Because you are specifying only the lower bound of the range, all returned records will be above this bound (i.e., be greater than the lower bound).

Note that both operators are inclusive, so that records that are equal to the specified boundary value will be returned.

Greater-than example

The following is an example of a greater-than query with two single-assign attributes:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Header/>
   <soapenv:Body>
      <Request xmlns="http://www.endeca.com/MDEX/conversation/3/0">
        <Language>de</Language>
        <State>
          <DataSourceFilter Id="DataFlt">
             <filterString>FISCAL_YEAR = 2002</filterString>
          </DataSourceFilter>
          <SelectionFilter Id="GtFlt">
             <filterString>AMOUNT_SOLD > 500</filterString>
          </SelectionFilter>
        </State>
        <RecordListConfig Id="RecList MaxPages="20">
           <RecordsPerPage>5</RecordsPerPage>
        </RecordListConfig>
      </Request>
    </soapenv:Body>
</soapenv:Envelope>

This example first filters out all records except those from fiscal year 2002, and then returns all records that have sold 500 or more items.

An example of a less-than query would be the same except for the use of the < (less-than) operator.

For the multi-assign attribute (named AnnualRevenue in this example), the filter string would look like this:

<SelectionFilter Id="SalesFlt">
   <filterString>SOME i IN AnnualRevenue SATISFIES (i > 150000)</filterString>
</SelectionFilter>

This example returns every record in which an AnnualRevenue assignment is greater than 150000.