How Can I get the Previous Record in a Table?

Question

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_

Dhana Babu · Accepted 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

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
What is the best way to find view record id to inherit that view? Ratkaistu view inheritance id record	2 toukok. 22	11199
How to get the id from a browse_record? id object browse_record browse	1 maalisk. 15	8326
How do I browse all the elements in a list? Ratkaistu browse	6 kesäk. 17	43005
In Report module when we create own Footer giving error record	2 kesäk. 16	4017
(Odoo 8) Access rights to project.task record	3 tammik. 16	5456

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!