Language structure
This table shows terms that are used to form filtering expressions. They reflect
the existing data structure used by SICRM.
| Term | Description | Usage | Comment |
|---|---|---|---|
| PRODUCTID | Product ID in the system.
Integer. |
PRODUCTID=45 |
Consider transactions with Product ID not equal to 45. |
| CUSTID | Customer ID in the system.
String. |
CUSTID IN
['500':'1000'] |
Filter out transactions for customers in the interval from 500 to 1000. |
| DATE | Transaction date.
YYYY-MM-DD format. |
DATE OUT [ 2016-01-04:
2017-01-04] |
Filter out transactions which date is not in the interval from 04-Jan-2016 to 04-Jan-2017. |
| Transaction cost.
Float. |
TOTALCOST <
1000 |
Filter out transactions with cost less than 1000. | |
| QUANTITY | Transaction quantity.
Float. |
QUANTITY IN
[1.0:5.0] |
Filter out transactions with quantity between 1.0 and 5.0. |
| AGE | Describes when the transaction was received.
Days. |
AGE >
365 |
Consider transactions submitted not longer than 365 days ago, with date between today and 1 year ago. |
Note: All terms and
operators must be capitalized. Otherwise, they are ignored.