Suppose we have the following Table:
ID | A | B |
---|---|---|
1 | true | false |
2 | false | true |
3 | true | true |
Where ID: 3 is an archived row.
If the filter or corresponding SQL Query is:
“SELECT * FROM Table WHERE A”
both rows 1 and 3 get returned.
However when:
“SELECT * FROM Table WHERE A OR B”
only rows 1 and 2 get returned.
But when using “or()” (Seatable Formula style):
“SELECT * FROM Table WHERE or(A, B)”
rows 1, 2 and 3 get returned.
INFO:
Self-Hosted Enterprise
latest version “3.5.10”
I hope you can reproduce the issue if not please let me know.
Best regards