Odoo Help


How to get minimum value from a record set of tree view in odoo 9.0?

arindam das
on 8/27/16, 3:10 AM 1,180 views

In this below image you can check i have created two class efficiency and test ,in efficiency class there is one field called start_time so i need this field to display   the minimum value of all record in start field ,which is present in test class.for this i am writing one  function can anyone help,how i should get minimum value of start field and displayed into my start_time field which is present in another model.


Akhil P Sivan

--Akhil P Sivan--

| 5 4 7
Kochi, India
--Akhil P Sivan--

Interested in exploring Odoo both technically & functionality wise.

email-id : akhilpsivan01@gmail.com

Akhil P Sivan
On 1/29/17, 11:06 PM


An alternative solution. You may try like this:

class effeciency(models.Model):
_name= "effeciency.effeciency"

def _get_min_test(self):
recs = self.env['test.line'].search([])
        if recs:
    recs_sorted = recs.sorted(key=lambda r: r.start)
            return recs_sorted[0].id
    start_time = fields.Many2one('test.line',string="Start Time", default=_get_min_test)
On 9/8/16, 4:42 AM

As an option:

get the lowest amount of 'start' - test . search([],order='start asc', limit=1)

define 'start_time' as float and make it equal to the result above or as integer and store 'id' of the record with min 'start' amount.

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/27/16, 3:10 AM
Seen: 1180 times
Last updated: 1/29/17, 11:06 PM