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

8 votes185 views2 answers
How to break a list unequal size chunks in python
Python
0 vote178 views1 answer
Python sum of array until index
Python
1 vote203 views1 answer
Sqlalchemy if a value in list of values
Python
0 vote203 views1 answer
E: Package 'python-certbot-nginx' has no installation candidate
Python
0 vote207 views1 answer
Spread dictionary python
Python
0 vote437 views1 answer
UserWarning: X does not have valid feature names, but LinearRegression was fitted with feature names
Python
1 vote195 views1 answer
How to loop back to try except python
Python
1 vote201 views1 answer
Fastest way to output text file in python + Cout
Python
0 vote213 views1 answer
Username__icontains in django
Python
92 votes192 views6 answers
Python create virtualenv
Python