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.