Write custom query odoo

 self.env.cr.execute("your query goes here ")
values = self.env.cr.dictfetchall() // here you will get the values
 for index in range(0, len(values)):
                print(f"\n\n {values[index].get('key_name')}  \n\n")

Similar codes

1 vote162 views2 answers
Urllib.error.HTTPError: HTTP Error 404: Not Found
Python
0 vote152 views1 answer
Python int in list
Python
0 vote164 views1 answer
_getfullpathname: path should be string, bytes or os.PathLike, not list
Python
-1 vote164 views1 answer
Raw query in django
Python
3 votes164 views1 answer
Json not readable python
Python
-2 votes155 views10 answers
Python if string has spaces
Python
21 votes202 views2 answers
Getting pi in python
Python
1 vote153 views1 answer
Django createmany
Python
-1 vote222 views3 answers
ValueError: If using all scalar values, you must pass an index
Python
0 vote160 views1 answer
Numpy symmetrize array
Python