odoo框架中的ORM

Question

如何将下面的sql查询更改为ODOORM

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

Answer 1

是这样的

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

了解模型。了解组（）

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