python - odoo框架中的ORM

Question

如何将以下 sql 查询更改为 ODOO orm

select max(dnddate) from ink where id = 23 and type= 'h' and kar not in ("5") group by customer;

标签： pythonodoo

Answer 1

它是那样的

inks = self.env['ink'].read_group([
            ('id', '=', 23),
            ('type', '=', 'h'),
            ('kar', 'not in', ("5"))], ['dnddate:max'], ['customer'])

阅读 Model.read_group()

https://www.odoo.com/documentation/13.0/reference/orm.html#search-read