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:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
   <soapenv:Header/>
   <soapenv:Body>
      <Request xmlns="http://www.endeca.com/MDEX/conversation/2/0">
        <Language>de</Language>
        <State>
          <DataSourceFilterString>FISCAL_YEAR = 2002</DataSourceFilterString>
          <SelectionFilterString>AMOUNT_SOLD > 500</SelectionFilterString>
        </State>
        <ContentElementConfig xsi:type="RecordListConfig"
          HandlerFunction="RecordListHandler"
          HandlerNamespace="http://www.endeca.com/MDEX/conversation/handlers/2010"
          Id="RecordList" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
        </ContentElementConfig>
       </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.