diff options
Diffstat (limited to 'import_account_payment.ktr')
| -rw-r--r-- | import_account_payment.ktr | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/import_account_payment.ktr b/import_account_payment.ktr index df47412..a8f9adb 100644 --- a/import_account_payment.ktr +++ b/import_account_payment.ktr @@ -556,7 +556,9 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from account_payment</sql> + <sql>select * from account_payment +where 1=1 +and am.write_date >= (now() - '3 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |