diff options
| -rw-r--r-- | import_product_product.ktr | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/import_product_product.ktr b/import_product_product.ktr index 17c48ef..e668a86 100644 --- a/import_product_product.ktr +++ b/import_product_product.ktr @@ -612,7 +612,7 @@ <schema_name/> </partitioning> <connection>erp indoteknik production (localhost)</connection> - <sql>select pp.id as product_id, pt.id as template_id, pt.name, pp.active, pt.x_manufacture as brand_id, + <sql>select pp.id as product_id, pt.id as template_id, pt.name, pp.active::boolean, pt.x_manufacture as brand_id, case when pp.default_code is null then pt.default_code else pp.default_code end as item_code, (select name from product_public_category ppc where id in((select replace(left(parent_path, 2), '/', '')::int from product_public_category where id in(select ppcptr.product_public_category_id from product_public_category_product_template_rel ppcptr @@ -870,7 +870,7 @@ where pp.write_date >= (now() - '5 days'::interval)</sql> </output> </remotesteps> <GUI> - <xloc>304</xloc> + <xloc>288</xloc> <yloc>128</yloc> <draw>Y</draw> </GUI> |