diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-06-06 14:04:31 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-06-06 14:04:31 +0700 |
| commit | 2ba3784ab11ab3e4d81d60c05c393c1401bcf16a (patch) | |
| tree | cb94494b61bafa0b780c169edc01fc4530078baa /import_account_payment.ktr | |
| parent | ec942a50e39efe3570b83d534f6c0ae86f0a5c26 (diff) | |
add to job for account payment ktr
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> |