odoom查询分组

Question

我需要将以下查询转换为odoom：

SELECT *
FROM table
WHERE
    (start_date < 'date' OR start_date IS NULL)
    and (end_date > 'date' OR end_date IS NULL) ;

我尝试过下面的过滤器，但它似乎给出了所有的结果：

^{pr2}$

Answer 1

此筛选器按预期工作：

filter = [
  "&", 
    "|",
      ("start_date", "<", date.today()), 
      ("start_date", "=", None), 
    "|", 
      ("end_date", ">", date.today()), 
      ("end_date", "=", None)]