diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2023-09-11 18:37:05 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2023-09-11 18:37:05 +0700 |
| commit | 495141890f516244d7d0b756f3b37b2f2d999105 (patch) | |
| tree | b5c8e39db6fd638da056a9bfeac7e633be3567fa | |
| parent | 1ef99735feb84dbe33047fd54857cc4ae686f9cf (diff) | |
recovery 3
| -rw-r--r-- | import_brand.ktr | 2 | ||||
| -rw-r--r-- | import_pricelist.ktr | 2 | ||||
| -rw-r--r-- | import_product_product.ktr | 2 | ||||
| -rw-r--r-- | import_purchase_order.ktr | 2 |
4 files changed, 4 insertions, 4 deletions
diff --git a/import_brand.ktr b/import_brand.ktr index e24b1a4..cc956af 100644 --- a/import_brand.ktr +++ b/import_brand.ktr @@ -622,7 +622,7 @@ <sql>select id, x_name, x_manufacture_level, (select x_name from x_manufactures xm2 where xm2.id = xm.parent_id) as parent, pricing_group from x_manufactures xm ---where xm.write_date >= (now() - '15 days'::interval)</sql> +where xm.write_date >= (now() - '15 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_pricelist.ktr b/import_pricelist.ktr index 16fa89f..a40884a 100644 --- a/import_pricelist.ktr +++ b/import_pricelist.ktr @@ -616,7 +616,7 @@ <connection>erp indoteknik production</connection> <sql>select ppi.id, ppi.product_id, ppi.write_date, ppi.fixed_price as price from product_pricelist_item ppi where ppi.pricelist_id = 1 ---and ppi.write_date >= (now() - '5 days'::interval)</sql> +and ppi.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_product_product.ktr b/import_product_product.ktr index d133eb3..640a1a5 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -697,7 +697,7 @@ pt.website_description as description, pt.weight from product_product pp join product_template pt on pt.id = pp.product_tmpl_id ---where pp.write_date >= (now() - '5 days'::interval)</sql> +where pp.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> diff --git a/import_purchase_order.ktr b/import_purchase_order.ktr index 03bdb75..ee85cad 100644 --- a/import_purchase_order.ktr +++ b/import_purchase_order.ktr @@ -680,7 +680,7 @@ get_quarter(to_char(pol.write_date::timestamp with time zone, 'MM'::text)) from purchase_order po join res_partner rp on rp.id = po.partner_id join purchase_order_line pol on pol.order_id = po.id ---where pol.write_date >= (now() - '5 days'::interval)</sql> +where pol.write_date >= (now() - '5 days'::interval)</sql> <limit>0</limit> <lookup/> <execute_each_row>N</execute_each_row> |