查询出错

[liuling73]

not done
is not recurring
heading does not include 习惯打卡
((due on or after 2025-09-03 AND due on or before 2025-09-09) OR (scheduled on or after 2025-09-03 AND scheduled on or before 2025-09-09) OR (scheduled before 2025-09-03))

为什么将如下任务列出来了：

- [ ] 需要去车辆检测机构进行检查，领取车辆合格证；⏳  2028-01-01 📅 2028-01-10 

[claremacrae]

Translation:

Why are the following tasks listed?

- [ ] You need to go to a vehicle inspection agency for inspection and obtain a vehicle certificate. ⏳ 2028-01-01 📅 2028-01-10

[liuling73]

Yes, but the constraints are as follows. According to the constraints, this task should not be listed.

• You need to go to a vehicle inspection agency for inspection and obtain a vehicle certificate. ⏳ 2028-01-01 📅 2028-01-10

((due on or after 2025-09-03 AND due on or before 2025-09-09) OR (scheduled on or after 2025-09-03 AND scheduled on or before 2025-09-09) OR (scheduled before 2025-09-03))

[claremacrae]

I added the explain instruction to your query, and see this output:

  ((due on or after 2025-09-03 AND due on or before 2025-09-09) OR (scheduled on or after 2025-09-03 AND scheduled on or before 2025-09-09) OR (scheduled before 2025-09-03)) =>
    OR (At least one of):
      due on or after 2025-09-03 AND due on or before 2025-09-09 =>
        due date is on or after 2025-09-03 (Wednesday 3rd September 2025)
      scheduled on or after 2025-09-03 AND scheduled on or before 2025-09-09 =>
        scheduled date is on or after 2025-09-03 (Wednesday 3rd September 2025)
      scheduled before 2025-09-03 =>
        scheduled date is before 2025-09-03 (Wednesday 3rd September 2025)

This shows that there are missing () around some of your filters.

It shows that it is not seeing the AND clauses, because of the missing ) and (.

Try this:

((due on or after 2025-09-03) AND (due on or before 2025-09-09) OR (scheduled on or after 2025-09-03) AND (scheduled on or before 2025-09-09) OR (scheduled before 2025-09-03))
explain

Which gives this:

  ((due on or after 2025-09-03) AND (due on or before 2025-09-09) OR (scheduled on or after 2025-09-03) AND (scheduled on or before 2025-09-09) OR (scheduled before 2025-09-03)) =>
    OR (At least one of):
      AND (All of):
        due on or after 2025-09-03 =>
          due date is on or after 2025-09-03 (Wednesday 3rd September 2025)
        due on or before 2025-09-09 =>
          due date is on or before 2025-09-09 (Tuesday 9th September 2025)
      AND (All of):
        scheduled on or after 2025-09-03 =>
          scheduled date is on or after 2025-09-03 (Wednesday 3rd September 2025)
        scheduled on or before 2025-09-09 =>
          scheduled date is on or before 2025-09-09 (Tuesday 9th September 2025)
      scheduled before 2025-09-03 =>
        scheduled date is before 2025-09-03 (Wednesday 3rd September 2025)

[liuling73]

According to the filtering conditions you provided, it's really done. Thank you, thank you!