Skip to Content
This question has been flagged
pythondataexpression
2 Replies
12365 Rodiniai
Portretas
saad

I have created a specific salary rule which the amount computation is based on a complex python expression
My python expression is similar to: 

result = (-200 if contract.wage >= 12000 
else -150 if ((contract.wage >= 9000) and (contract.wage <= 11999))
else -80 if ((contract.wage >= 6000) and (contract.wage <= 8999)) 
else -20 if  ((contract.wage >= 3000) and (contract.wage <= 5999))
else -0)

How can I put this salary rule in a xml data file knowing that '&gt;' and '&lt;' didn't work?

Portretas
Atmesti
Portretas
Turkesh Patel (tpa)
Best Answer 
<record id="hr_rule_xyz" model="hr.salary.rule">
    <field name="name">xyz</field>
    <field name="sequence" eval="1"/>
    <field name="code">xyz</field>
    <field name="category_id" ref="hr_payroll.xyz"/>
    <field name="condition_select">none</field>
    <field name="amount_select">code</field>
    <field name="amount_python_compute">result = (-200 if contract.wage &gt;= 12000 else -150 if ((contract.wage &gt;= 9000) and (contract.wage &lt;= 11999)) else -80 if ((contract.wage &gt;= 6000) and (contract.wage &lt;= 8999)) else -20 if  ((contract.wage &gt;= 3000) and (contract.wage &lt;= 5999)) else -0)</field>
</record>
Portretas
Atmesti
Turkesh Patel (tpa)

use >= for >=

saad
Autorius

Thank you friends. I used the '<' sign and it get a syntax error as it' interpreted as a tag start. I didn't think to reverse conditional expressions to use '>'.

Turkesh Patel (tpa)

oh yes lt and gt u can use it works..i have been used lt and gt in my answe but it shows < and >

Portretas
Turkesh Patel (tpa)
Best Answer 
    <record id="hr_rule_xyz" model="hr.salary.rule">
        <field name="name">xyz</field>
        <field name="sequence" eval="1"/>
        <field name="code">xyz</field>
        <field name="category_id" ref="hr_payroll.xyz"/>
        <field name="condition_select">none</field>
        <field name="amount_select">code</field>
        <field name="amount_python_compute">result = (-200 if contract.wage >= 12000 else -150 if ((contract.wage >= 9000) and (contract.wage <= 11999)) else -80 if ((contract.wage >= 6000) and (contract.wage <= 8999)) else -20 if  ((contract.wage >= 3000) and (contract.wage <= 5999)) else -0)</field>
    </record>
Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
Python expression doesnt work
python expression automatic-action
Portretas
0
lapkr. 22
3249
How to import complex excel data (Contact and Subcontact in one line) into Odoo?
python import data odoo19
Portretas
0
rugs. 25
1062
Syntax to inout/write text in a field
python expression studio v14
Portretas
Portretas
2
vas. 23
3629
server action many2one insert self?
action python expression serveraction
Portretas
0
kov. 24
2064
Multi line Python expression in xml data file? Solved
python multiple lines expression
Portretas
Portretas
Portretas
3
gruod. 19
7555