Creating filters within Connect Portal

Here, you key the filter into the 「filter」 textbox in Connect Portal. The following table shows the filter format that should be used:

Filter Operator Character(s) Example
Equal = 「/Ledger/Ledger Line/Journal Number=1100」
OR OR 「(/Ledger/Ledger Line/Journal Number=1100) OR (/Ledger/Ledger Line/Journal Number=1300)」
AND AND 「(/Ledger/Ledger Line/Journal Number=1100) AND (/Ledger/Ledger Line/Journal Number=1300)」
Not Equal != 「/Ledger/Ledger Line/Journal Number!=1100」
Greater than / Greater than or Equal >>= 「/Ledger/Ledger Line/Journal Number>1100」

「/Ledger/Ledger Line/Journal Number>=1100」
Less than / Less than or Equal <<= 「/Ledger/Ledger Line/Journal Number<1100」

「/Ledger/Ledger Line/Journal Number<=1100」
Between <> 「/Ledger/Ledger Line/Journal Number<>1100,2000」
In >< Not supported
Like ~= 「 /Ledger/Ledger Line/Asset Code~=V% or V_」

See the section Specifying Wild Cards
Is Null ~# 「/Ledger/Ledger Line/Asset Code ~#」
Is Not Null !# 「/Ledger/Ledger Line/Asset Code !#」
Longer Expressions 「((/Purchase Order/EntryDate="02042001") AND (/Purchase Order/SupplierCode=71003)) OR ((/Purchase Order/EntryDate="26032001") AND (/Purchase Order/SupplierCode=71010))」

Some considerations to bear in mind:

  • There are no space characters on either side of the operator characters.
  • Each selection in an OR, or AND, must be specified within brackets.
  • For expressions that have more than one AND, or OR, the whole filter must be surrounded by brackets.
  • All operators can be preceded by NOT to invert the logic.