Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Extracting Customer price lists cross reference

By
Hugh
on 6/8/16, 10:18 AM 175 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

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/8/16, 10:18 AM
Seen: 175 times
Last updated: 6/8/16, 10:25 AM