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)) | |
| Days Relative To Today | RELDAYS | Accounts/DateTimeLastUpdated RELDAYS -2 and 2 |
Some considerations to bear in mind:
- There are no space characters on either side of the operator characters.
- Each selection in an
OR, orAND, must be specified within brackets. - For expressions that have more than one
AND, orOR, the whole filter must be surrounded by brackets. - All operators can be preceded by
NOTto invert the logic.
Note: RELDAYS only applies to DATE filter data type and the default value for RELDAYS is 0.