Creating Filters in a Text Editor

If you are creating or maintaining query payloads using a text editor, the filter element takes the general form:

<Filter>
  <Item name="elementname" operator="filteroperator" value="value"/>
</Filter>

The general rules for valid filters are as follows:

  • A filter must have each selection condition specified within an <Item> element.
  • A selection condition within an <Item> element must have:
    • A name that identifies the element to be used.
    • An operator describing the type of selection operation to be applied to the element.
    • One or more parameters (depending on the operator) specifying the value(s) that the database is compared with. You can use wild cards.

Where you are selecting a child element, you must include all the parent elements in the element name portion of the name="elementname" parameter.

<component>
    <Element1></Element1>
    <Child1>
        <Element2></Element2>
        <Child1a>
								    <Element3></Element3>
        </Child1a>
    </Child>
</component>

To select on <Element1>, specify name="elementname" as name="/Component/Element1"

To select on <Element2>, specify name="elementname" as name="/Component/Child1/Element2"

To select on <Element3>, specify name="elementname" as name="/Component/Child1/Child1a/Element3"

The following table shows a sample filter for each filter operator:

Filter Operator Example
Equal <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="EQU" value="V001"/> </Filter>
OR <Filter> <Expr operator="OR"> <Item name="/Ledger/LedgerLine/JournalNumber" operator="EQU" value="1100"/> <Item name="/Ledger/LedgerLine/JournalNumber" operator="EQU" value="1300"/> </Expr> </Filter>
AND <Filter> <Expr operator="AND"> <Item name="/Ledger/LedgerLine/JournalNumber" operator="EQU" value="1100"/> <Item name="/Ledger/LedgerLine/JournalNumber" operator="EQU" value="1300"/> </Expr> </Filter>
Not Equal <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="NEQU" value="V001"/> </Filter>
Greater than <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="GT" value="V001"/> </Filter>
Greater than or Equal <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="GTE" value="V001"/> </Filter>
Less than <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="LT" value="V001"/> </Filter>
Less than or Equal <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="LTE" value="V201"/> </Filter>
Between <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="BETWEEN" minvalue="V001" maxvalue="V9999"/> </Filter>
In <Filter> <Item name="/Supplier/SupplierCode" operator="IN" value="71001,71002,71003"/> </Filter>
Like <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="LIKE" value="_001"/> </Filter> <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="LIKE" value="V%"/> </Filter>
Is Null <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="NULL" /> </Filter>
Is Not Null <Filter> <Item name="/Ledger/LedgerLine/AssetCode" operator="NOTNULL"/> </Filter>