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 437 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.


Are You want to choose the minimum 'test.line' record for the relational field "start_time"

yousif Mobark
on 8/29/16, 2:42 AM

Akhil P Sivan

--Akhil P Sivan--
Akhil P Sivan
| 5 3 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.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 437 times
Last updated: 1/29/17, 11:06 PM