diff options
Diffstat (limited to 'import_match_payment_invoice.ktr')
| -rw-r--r-- | import_match_payment_invoice.ktr | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/import_match_payment_invoice.ktr b/import_match_payment_invoice.ktr index 11e4155..7074623 100644 --- a/import_match_payment_invoice.ktr +++ b/import_match_payment_invoice.ktr @@ -556,7 +556,9 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from v_match_payment_invoice</sql> + <sql>select * from v_match_payment_invoice v +join account_payment ap on ap.id = v.payment_id +where ap.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |