在Odoo的SQL查询中使用in列表

from odoo import models, fields

class MyModel(models.Model):
    _name = 'my.model'

    name = fields.Char()
    category = fields.Selection([('A', 'Category A'), ('B', 'Category B'), ('C', 'Category C')])

# 假设我们要查询category字段值为A和B的记录
categories = ['A', 'B']
records = self.env['my.model'].search([('category', 'in', categories)])

# 打印查询结果
for record in records:
    print(record.name)