summaryrefslogtreecommitdiff
path: root/import_account_move_line.ktr
diff options
context:
space:
mode:
authorstephanchrst <stephanchrst@gmail.com>2023-10-09 14:45:14 +0700
committerstephanchrst <stephanchrst@gmail.com>2023-10-09 14:45:14 +0700
commit0ceb03c7f561703331477c31d08ff819cdac376d (patch)
tree8979dca2aaec49a772d594f644b1514bb6c644fd /import_account_move_line.ktr
parent80fb1114ef4f21af51e7c245f5ebd34e630d8a15 (diff)
add where clause
Diffstat (limited to 'import_account_move_line.ktr')
-rw-r--r--import_account_move_line.ktr2
1 files changed, 1 insertions, 1 deletions
diff --git a/import_account_move_line.ktr b/import_account_move_line.ktr
index cae2010..383d05f 100644
--- a/import_account_move_line.ktr
+++ b/import_account_move_line.ktr
@@ -889,7 +889,7 @@
<schema_name/>
</partitioning>
<connection>erp indoteknik production (localhost)</connection>
- <sql>select * from account_move_line --where write_date >= (now() - '5 days'::interval)</sql>
+ <sql>select * from account_move_line where write_date >= (now() - '5 days'::interval)</sql>
<limit>0</limit>
<lookup/>
<execute_each_row>N</execute_each_row>