diff options
Diffstat (limited to 'import_purchase_pricelist.ktr')
| -rw-r--r-- | import_purchase_pricelist.ktr | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index bf19d39..13decff 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -557,7 +557,7 @@ </partitioning> <connection>erp indoteknik production (localhost)</connection> <sql>select pp.id, pp.product_id, pp.vendor_id, rp.name as vendor, pp.product_price, pp.write_date, -pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price +pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price, pp.brand_id from purchase_pricelist pp join res_partner rp on rp.id = pp.vendor_id where pp.write_date >= (now() - '10 days'::interval)</sql> @@ -863,6 +863,11 @@ where pp.write_date >= (now() - '10 days'::interval)</sql> <rename>include_price</rename> <update>Y</update> </value> + <value> + <name>brand_id</name> + <rename>brand_id</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> |