"OR" in SQL or Big Data view seems to not work for "Archived"/"Big Data" entries

Developer Talk API
1

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

2

Thanks for the information. We will check the issue.

3

If this was a Bug, would you release a Hotfix soon?

And have you been able to reproduce this Issue?

4

We haven’t checked it yet. We will check the issue in this Friday.

1 Like
5

We can reproduce the issue. A fix will be added in version 4.0.