diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-10-20 10:36:49 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-10-20 10:36:49 +0700 |
| commit | 21220f3bf9b1558273c95567bddca26af2d4bc43 (patch) | |
| tree | 3d78c3aa050fc1502633cdf54407d0e6fee8ba29 /import_stock_move.ktr | |
| parent | 5dbf77be5dded5ac060edd6496c6eb053db98183 (diff) | |
add where condition
Diffstat (limited to 'import_stock_move.ktr')
| -rw-r--r-- | import_stock_move.ktr | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/import_stock_move.ktr b/import_stock_move.ktr index 0d22dc8..b1808f3 100644 --- a/import_stock_move.ktr +++ b/import_stock_move.ktr @@ -556,7 +556,7 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select * from stock_move</sql> + <sql>select * from stock_move where write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |