Skip to main content

Odoo/OpenERP : Populate one2many list using on_change method

Following is the method to update/populate simple field value using on_change method:

return {'value' : {'field_name' : <field_value>}}

Most of the OpenERP developers will be aware of it.

What we will do if we have to add one2many list using on_change method? For example : I want to display list of leaves allotted, leaves taken and leaves pending of an employee. So on_change employee_id I want to show related updated leave list. leave_ids is one2many field in my main table.

what we have to do is as follow:

leave_ids = []       
for record in records:
    if record:
        leave_ids.append([0,0, {'holiday_status_id':record,'max_leaves':records[record]['max_leaves'],'leaves_taken':records[record]['leaves_taken'],'remaining_leaves':records[record]['remaining_leaves']}])

return {'value' : {'leave_ids' : leave_ids}}

Hopefully it will help someone.

If you need more detail on this. Please post your valuable comments.


Thanks!!!!!!!!!!!! Enjoy Programming :)

Reference Link :

 http://stackoverflow.com/questions/20954412/create-and-edit-items-of-a-one2many-field-through-on-change-method
Labels:
Location: Chandigarh, Chandigarh, India

Comments

  1. Aman Gautam9 May 2015 at 11:44

    Hi, Thanks for the great post Shiv. What is the meaning of two zeros in
    `leave_ids.append([0,0, {'holiday_status_id':record,'max_leaves...` ?

    ReplyDelete
    Replies
    1. Shiv Modi11 May 2015 at 11:22

      Hi Aman, You can check full explanation about it here: https://doc.odoo.com/v6.0/developer/2_5_Objects_Fields_Methods/methods.html#osv.osv.osv.write

      Delete
  2. Unknown9 September 2015 at 15:38

    can i used that feature on odoo 8

    ReplyDelete
  3. Unknown9 September 2015 at 15:38

    can i use that feature on odoo 8.0

    ReplyDelete
  4. Unknown14 September 2015 at 10:43

    Thank you, your code help me

    ReplyDelete
  5. Shiv Modi14 September 2015 at 11:39

    great!! :)

    ReplyDelete
  6. kabeer26 July 2016 at 17:40

    Thanks Shiv Modi. I tried your code, the one2many field populate only after save the form. i need to display records after on change but before save. is it possible.

    ReplyDelete
  7. Unknown5 July 2017 at 14:17

    hi..how to update only one cell in one2many field?

    ReplyDelete
  8. Unknown31 August 2017 at 11:17

    I tried working on something like this but showing at the backend but not display on the front end, This is my code, kindly check for me please

    @api.multi
    @api.onchange('contract_bool')
    def onchange_populate(self):
    if self.contract_bool==True:
    product_obj=self.env['product.template']
    product_filter_search=product_obj.search([('compulsory_product','=',True)])
    for abc in product_filter_search:
    create_contract_entries=self.clients_boq_id.create(
    {'stud_ids': [(0, 0, {'name':abc.id,'link_client_boq_oppor':product_obj.id})]})
    print create_contract_entries['name'].name
    print create_contract_entries['link_client_boq_oppor']


    ReplyDelete
    Replies
    1. Shiv Modi31 August 2017 at 13:48

      print statements won't work in onchange...you have to assign values to self object or use return statement
      You can check default addons for reference

      Delete
  9. Unknown3 January 2018 at 12:58

    thank you..

    ReplyDelete

Post a Comment

Thanks for your valuable comments.

Popular posts from this blog

Odoo/OpenERP: one2one relational field example

one2one relational field is deprecated in OpenERP version>5 but you can achieve the same using many2one relational field. You can achieve it in following two ways : 1) using many2one field in both the objects ( http://tutorialopenerp.wordpress.com/2014/04/23/one2one/ ) 2)  using inheritance by deligation You can easily find the first solution with little search over internet so let's start with 2nd solution. Scenario :  I want to create a one2one relation between two objects of openerp hr.employee and hr.employee.medical.details What I should do  i. Add _inherits section in hr_employee class ii. Add field medical_detail_id in hr_employee class class hr_employee(osv.osv):     _name = 'hr.employee'     _inherits = {' hr.employee.medical.details ': "medical_detail_id"}     _inherit = 'hr.employee'         _columns = {              'emp_code':fields.char('Employee Code', si
12 comments
Read more

How to draw Dynamic Line or Timeseries Chart in Java using jfreechart library?

Today we are going to write a code to draw a dynamic timeseries-cum-line chart in java.   The only difference between simple and dynamic chart is that a dynamic event is used to create a new series and update the graph. In out example we are using timer which automatically calls a funtion after every 1/4 th second and graph is updated with random data. Let's try with the code : Note : I had tried my best to provide complete documentation along with code. If at any time anyone have any doubt or question please post in comments section. DynamicLineAndTimeSeriesChart.java import java.awt.BorderLayout; import java.awt.Color; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.Timer; import javax.swing.JPanel; import org.jfree.chart.ChartFactory; import org.jfree.chart.ChartPanel; import org.jfree.chart.JFreeChart; import org.jfree.chart.axis.ValueAxis; import org.jfree.chart.plot.XYPlot; import
37 comments
Read more

Flickr and OAuth

What is Flickr? I think you landed on this page because you know what Flickr is, so let’s come to the point and discuss about the API. Why am explaining? Although each and everything, about API, is well documented on Flickr website here , I'm just trying to explain the whole process by dividing it into small parts. Old Authentication API The current Flickr authorization scheme is not the first one it used. In the early days of Flickr, users granted the power to an app to act on their behalf by giving  the apps their Flickr username and password. Doing so meant that in order to revoke  an app’s permission, users would have to change their Flickr password. Of course, doing that would also instantly revoke permissions of other third-­party apps with knowledge of the user’s password. The new authorization scheme is meant to correct obvious problems with the old scheme. Why should you as a user have to use your Flickr password for anything other than your dealings with Flickr?
29 comments
Read more