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" {values[index].get('key_name')} ")