Examples
These are the examples of language structure and expressions in filtering language:
- Ignore transactions that are more than 1 year old:
- AGE > 365
- Ignore transactions if they are old or insignificant amount
- AGE > 365 OR TOTALCOST < 1000
- Ignore transactions only if they are old and insignificant in the same time
- AGE > 365 AND TOTALCOST < 1000
- Ignore transactions for particular product
- PRODUCTID=30
- Ignore transactions from particular period of time (January 2015)
- DATE IN [2015-01-01: 2015-01-31]