Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I'm trying to get a list of Customers and the price lists that they are linked to. The field reference is property_product_pricelist. I've tried the SQL below but without success. If anyone can help I'd be very grateful.
select res_partner.id, res_partner.name, product_pricelist.name from res_partner,ir_property,product_pricelist
res_partner.id = right(ir_property.res_id,length(res_id)-12)::integer
right(ir_property.value_reference,length(value_reference)-21)::integer = product_pricelist.id
left(ir_property.value_reference,20) = 'product_pricelist'
res_partner.is_company = TRUE
res_partner.customer = TRUE