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

Cannot access field in product.pricelist

By
Simon Lee
on 5/7/16, 6:23 AM 373 views

I am trying to learn how to write code to access field content in models of odoo.

I wrote a simple model with a test method:

class hago_product_template(models.Model):     

    _name='product.template'
    _inherit='product.template'

    @api.one   
    def _set_my_list_price(self):      
        pricelists = self.env['product.pricelist.item'].search([('product_tmpl_id', '=', self.id)])       
        for pricelist in pricelists:           
            pricelist_id = pricelist.pricelist_id           
            base_pricelist = self.env['product.pricelist'].browse(pricelist_id)       
            temp_name = base_pricelist.name  # stuck here

        self.my_list_price = pricelist_id

    my_list_price=fields.Float('Sale Price', compute="_set_my_list_price")

The code ran until the line "temp_name=...". I traced it line-by-line thru the eclipse debugger. When I execute the line temp_name = base_pricelist.name, the debugger console showed the following:

2016-05-07 09:50:51,249 26808 INFO hago openerp.sql_db: Programming error: can't adapt type 'product.pricelist', in query SELECT "product_pricelist"."name" as "name","product_pricelist"."create_date" as "create_date","product_pricelist"."currency_id" as "currency_id","product_pricelist"."write_uid" as "write_uid","product_pricelist"."id" as "id","product_pricelist"."write_date" as "write_date","product_pricelist"."company_id" as "company_id","product_pricelist"."create_uid" as "create_uid","product_pricelist"."active" as "active" FROM "product_pricelist" WHERE "product_pricelist".id IN %s ORDER BY "product_pricelist"."name"

2016-05-07 09:50:51,264 26808 WARNING hago openerp.models: Comparing apples and oranges: product.pricelist(2,) == 2 (/home/simonlee/workspace/odoo9/openerp/models.py:5621)

2016-05-07 09:50:51,277 26808 WARNING hago openerp.models: Comparing apples and oranges: product.pricelist(2,) == 3 (/home/simonlee/workspace/odoo9/openerp/models.py:5621)

2016-05-07 09:50:51,292 26808 INFO hago openerp.sql_db: Programming error: can't adapt type 'product.pricelist', in query SELECT "product_pricelist"."name" as "name","product_pricelist"."create_date" as "create_date","product_pricelist"."currency_id" as "currency_id","product_pricelist"."write_uid" as "write_uid","product_pricelist"."id" as "id","product_pricelist"."write_date" as "write_date","product_pricelist"."company_id" as "company_id","product_pricelist"."create_uid" as "create_uid","product_pricelist"."active" as "active" FROM "product_pricelist" WHERE "product_pricelist".id IN %s ORDER BY "product_pricelist"."name"

Can someone tell me what I did wrong? How I can access the content of the product.pricelist record??? Thanks

0

Baiju

--Baiju--
3154
| 5 4 8
Kochi, India
--Baiju--
ODOO technical and functional

        I like learning new thing, especially technical thing. I am a quick learner, I can learn technical things very fast. I have good logical skill,  I have immense interest in programming.

e-mail id : baijuks@hotmail.com

Baiju
On 5/7/16, 10:56 AM

HI Simon,

The reason for this error is you are passing incompatible type for browse method, instead of passing id you are passing record-set to browse method.  It visible form error description [Programming error: can't adapt type].

Make this changes :

for pricelist in pricelists:           

            pricelist_id = pricelist.pricelist_id.id           

            base_pricelist = self.env['product.pricelist'].browse(pricelist_id)       

 

now in pricelist_id there is id instead of record.

And one more thing you already got record in pricelist, so you don't have to use browse() there. You can directly get name by using pricelist.name . In new API  model fields can be read and written directly from the record, but only on singletons (single-record recordsets).

 Please refer ORM API


Hope this helps.

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: 5/7/16, 6:23 AM
Seen: 373 times
Last updated: 5/7/16, 10:56 AM