Skip to Content
This question has been flagged
domainrelated
3 Replies
22697 Views
Avatar
MARTINEZ ESTELLES, S.L.

Hi again,

I need do a filter in a selection field, this is the code:

'wpartner_id': fields.related('incidencia_id', 'partner_id', type="many2one", relation="res.partner", string="Cliente", store=False),
'presupuesto': fields.many2one('sale.order', 'Presupuesto', ondelete='cascade', domain=[('partner_id', '=', wpartner_id)]),

This return this error:

'presupuesto': fields.many2one('sale.order', 'Presupuesto', ondelete='cascade', domain=[('partner_id', '=', wpartner_id)]),
NameError: name 'wpartner_id' is not defined

I need some help to solve it, please

Thanks

Avatar
Discard
Avatar
Ghanshyam Prajapati
Best Answer

Hi Francisco Martínez,

Replace 

domain=[('partner_id', '=', wpartner_id)]

with 

domain="[('partner_id', '=', wpartner_id)]"

Try Following,

'presupuesto': fields.many2one('sale.order', 'Presupuesto', ondelete='cascade', domain="[('partner_id', '=', wpartner_id)]"),

or put this domain in 'presupuesto' field of xml file

<field name="presupuesto"  domain="[('partner_id', '=', wpartner_id)]"/>

Hope it work for you.

Avatar
Discard
MARTINEZ ESTELLES, S.L.
Author

With quotes returns no errors, but neither returns any data. Quotation marks are used only on the view.

MARTINEZ ESTELLES, S.L.
Author

now, i apply the domain at the view, and it works fine! so only in existents records when wpartner_id is filled. how can i get wpartner_id default value? for new records.

MARTINEZ ESTELLES, S.L.
Author

<field name="wpartner_id" readonly="1" invisible="true"/> <field name="presupuesto" domain="[('partner_id','=',wpartner_id)]" on_change="onchange_presupuesto(presupuesto)"/>

Ghanshyam Prajapati

Hi Francisco, If your problem is solved, then please mark this answer as solved. thanks

dirtyHandsPHP

Solution for view worked for me but at class field level it didn't work....Thanks for solution

Avatar
Lucio
Best Answer

You can not filter a domain with respect to a non-stored field.

Change the definition of wpartner_id to:

'wpartner_id': fields.related('incidencia_id', 'partner_id', type="many2one", relation="res.partner", string="Cliente", store=True),
Avatar
Discard
Avatar
MARTINEZ ESTELLES, S.L.
Author Best Answer

thanks for your reply,

Doesn't works with this change.

returned the same error:

'presupuesto': fields.many2one('sale.order', 'Presupuesto', ondelete='cascade', domain=[('partner_id', '=', wpartner_id)]),
NameError: name 'wpartner_id' is not defined

Thx.

Avatar
Discard
Lucio

I recommend making this a comment to my answer, not a new answer. Anyway, are you having this error when starting the server or when opening a view?

MARTINEZ ESTELLES, S.L.
Author

Thx, I get this error when starting the server. (Web Client OpenERP 7)

MARTINEZ ESTELLES, S.L.
Author

now, i apply the domain at the view, and it works fine! so only in existents records when wpartner_id is filled. how can i get wpartner_id default value? for new records.

MARTINEZ ESTELLES, S.L.
Author

<field name="wpartner_id" readonly="1" invisible="true"/> <field name="presupuesto" domain="[('partner_id','=',wpartner_id)]" on_change="onchange_presupuesto(presupuesto)"/>

Related Posts Replies Views Activity
Related fields, or domain, or anything else? Solved
domain related odoo
Avatar
Avatar
Avatar
Avatar
3
Dec 19
9333
naked domain set up Solved
domain
Avatar
Avatar
Avatar
Avatar
3
Jul 25
6060
Domain name Request
domain
Avatar
0
May 25
1667
Domain is not working
domain
Avatar
Avatar
2
Mar 24
2957
Domain depending on a field in odoo v8
domain
Avatar
0
Jan 23
2478