"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.

6

@fjodorsch Now, that SeaTable 4.0 is out, could you confirm that the issue has been solved?

7

Yes everything now works as excpected after Upgrading to
SeaTable Enterprise 4.0

1 Like
8

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.