Skip to Content
This question has been flagged
idrecordbrowse
1 Respondre
7379 Vistes
Avatar
Yakito

Hello,

Sorry if this is super basic, I am almost new with python.

So, basically I am passing an ID to a function and I need to get the record just before the one with the ID I am passing from a table.

This is my function

def get_prev_period(self,period_id):
        if period_id:
            period_list = self.pool.get('sim.periods').browse(self.cr, self.uid, period_id)
            current_id = period_list.id
            #Now I need to get the ID just above current_id
        return 0

So, basically I need to get the ID just above the current_id. I am not able to do current_id - 1 because that might no be the case.

Any tips will be much appreciated! Thanks!

Avatar
Descartar
Avatar
Dhana Babu
Best Answer

You need to execute your manual query on postgres database table, 

def get_prev_period(self,period_id):
            if period_id:
               result= self.cr("""SELECT id FROM table_name WHERE id < %s ORDER BY id DESC LIMIT 1""", [period_id])
               result = self.cr.dictfetchall()
               print result # holds the one row data
               current_id = result[0]['id']
            return 0
Avatar
Descartar
Yakito
Autor

You are a genius! Thanks!

Related Posts Respostes Vistes Activitat
What is the best way to find view record id to inherit that view? Solved
view inheritance id record
Avatar
Avatar
Avatar
2
de maig 22
10432
How to get the id from a browse_record?
id object browse_record browse
Avatar
Avatar
1
de març 15
7535
How do I browse all the elements in a list? Solved
browse
Avatar
Avatar
Avatar
Avatar
Avatar
6
de juny 17
42079
In Report module when we create own Footer giving error
record
Avatar
2
de juny 16
3153
(Odoo 8) Access rights to project.task
record
Avatar
Avatar
3
de gen. 16
4467