Skip to Content
Dette spørgsmål er blevet anmeldt
stockconstraintsqlfloatodooV8
1 Svar
7284 Visninger
Avatar
Alberto

Suppose, in a custom module, I have fields for:

product_id, stock_location, stock_move, etc

And on another custom module I have a Float field, which will have a quantity, it will represent a fiscal year.


So, before I do any movement, I should check for this Float field, and somehow compare it's data with the product, or products I will be moving (product have a field called 'sale_price' but it could be even a custom Float also on product)


I don't know if I'm explaining myself, but what I want is to compare these fields, and give a constraint to the action, if custom_fiscal Float field has a lower value than the product_price Float one, then show a ValidationError or something like that.


I'm not sure if this scenario could be achievable by using a _constraint or _sql_constraint


Any ideas?


Avatar
Kassér
Avatar
Avinash Nk
Bedste svar
Hi kristian,
 
What I can understand from your question is, you have to compare the value of a field on your record with a field in another record.
 
for that, you can create any function.
 
for example, you can call the function on the onchange of your field.
 
Ex:
 
from openerp.exceptions import ValidationError
@api.multi
@api.onchange('your_field')
def function_name(self):
       model_of_the_needed_field = self.env['needed.model'].browse(needed_record_id)
       #now you can compare the value of your field and the othor field.
       if self.your_field == model_of_the_needed_field.other_field:
           raise ValidationError(_("*****You can raise any message here.****"))
Thank you.
Avatar
Kassér
Alberto
Forfatter

Thank You very much :)

Related Posts Besvarelser Visninger Aktivitet
can we calculate product_qty moved from location to a location in a specific hour?
stock sql product.product stock.move odooV8
Avatar
0
sep. 15
3431
how to use constraint and sql constraint? Løst
constraint sql
Avatar
Avatar
Avatar
Avatar
Avatar
6
dec. 23
67699
Override SQL constraint
constraint sql
Avatar
Avatar
1
mar. 19
11381
Diagramme de classes relatif au module de stock odoo Løst
stock odooV8 wms
Avatar
Avatar
Avatar
2
feb. 25
7644
Import stock in products
stock import odooV8
Avatar
Avatar
Avatar
Avatar
3
jun. 24
10153