How to use self._cr.execute get my data?

Question

temp_list=[]
temp_list.append( self._cr.execute('select * from std_table_print'))      print(temp_list)  here is my code but i am getting a none value as a result

Mitul Shingala · Accepted Answer

Hello,
for getting the data from the query, after your query you need to write one more line in code.
self._cr.execute("your query")  # your query line
from below two line you can use anyone based on your needs.
result = self._cr.fetchall()  # return the data into list of tuple format
result = self._cr.dictfetchall() # return the data into the list of dictionary format into the result variable you can get the data of query

subbarao · Answer

Hello Sourav,
self._cr.execute('select * from std_table_print')   this means only the query executed
after that you have to fetch from cursor
self._cr.fetch()
or
self._cr.fetchall()
or
self._cr.fetchone()

Kamrul Islam Shahin · Answer

To fetch data from the employee module you can use this function: It will execute a SQL command and fetch all the data into a list of tuple formats and then convert it into dictionary format.
@api.model
def get_department_employee(self):
cr = self._cr
cr.execute("""select department_id, hr_department.name,count(*)
from hr_employee join hr_department on hr_department.id=hr_employee.department_id
group by hr_employee.department_id,hr_department.name""")
fetch_data = cr.fetchall()
data = []
for i i

İlgili Gönderiler	Cevaplar	Görünümler
How to live rtsp camera in Odoo python odoo11	2 Tem 24	15221
How to migrate Database from Odoo11 to Odoo14 odoo11 v14	2 Nis 23	8740
How to round sum of if code Çözüldü python v14	1 May 22	5416
self.env.search_count returns different result from self._cr.execute Çözüldü python sql	2 Şub 22	6182
I am getting this error when i try to start the odoo service in the server.can anyone help me with this? python v14	0 Kas 21	21

Bu soru işaretlendi

To fetch data from the employee module you can use this function:

Enjoying the discussion? Don't just read, join in!