diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-10-20 10:49:21 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-10-20 10:49:21 +0700 |
| commit | fad2417041aa3d05be91e8240cc140ba585ec925 (patch) | |
| tree | 2f6e0f076b8b976b9326c0d0678ba37c927af73e | |
| parent | 76b9336048c4b5dc913e86c82f97cde07bbf04e8 (diff) | |
add where condition
| -rw-r--r-- | import_stock_location.ktr | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/import_stock_location.ktr b/import_stock_location.ktr index 0136248..84bfc09 100644 --- a/import_stock_location.ktr +++ b/import_stock_location.ktr @@ -556,7 +556,7 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from stock_location --where write_date >= (now() - '5 days'::interval)</sql> + <sql>select * from stock_location where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |