...
Select conditions “Options” field accepted values:
Operator | Description |
EQ | Equal: True, if the content of operand1 matches the content of operand2. |
NE | Not Equal: True, if the content of operand1 does not match the content of operand2. |
LT | Lower Than: True, if the content of operand1 is smaller than the content of operand2. |
GT | Greater Than: True, if the content of operand1 is greater than the content of operand2. |
LE | Lower Equal: True, if the content of operand1 is lower than or equal to the content of operand2. |
GE | Greater Equal: True, if the content of operand1 is greater than or equal to the content of operand2. |
CP | Match a pattern |
NP | Patter not matching |
BT | Between |
NB | Not between |
If the aim is to extract delta data, appropriate where conditions should be added in the query itself. For these purposes following placeholders are foreseen:
Placeholder | Description |
$now | extractor current execution time in system time zone |
$today | extractor current execution date in system time zone |
$yesterday | extractor day before execution date in system time zone |
$timestamp | extractor current timestamp in UTC |
$timestamp_st | extractor current timestamp in system time zone |
$lastrun | extractor last execution timestamp in UTC |
$lastrun_st | extractor last execution timestamp in system time zone |
$lastrundate | extractor last execution date (system time zone) |
$lastruntime | extractor last execution time (system time zone) |
Field values to get sample:
...