This question has been flagged
2338 Views

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

where

res_partner.id = right(ir_property.res_id,length(res_id)-12)::integer

and

right(ir_property.value_reference,length(value_reference)-21)::integer = product_pricelist.id

and

left(ir_property.value_reference,20) = 'product_pricelist'

and

res_partner.is_company = TRUE

and

res_partner.customer = TRUE

Avatar
Discard