WHERE "updated > created" does not work in DATA BROWSER

Bug
1

I think this is a bug. I wanted to find all rows that have been updated, so I tried WHERE “updated > created” and didn’t get any rows -

image
image1308×391 25.2 KB

Putting the same WHERE in the REST CONSOLE returns the results I would expect -

image
image1273×710 41.4 KB

I didn’t try this on other tables but I assume the results will be the same.

2

It is not a bug - you don’t have SQL search enabled.

Screenshot_2024-09-17-12-57-59-29_40deb401b9ffe8e1df2f1cc5ba480b12
Screenshot_2024-09-17-12-57-59-29_40deb401b9ffe8e1df2f1cc5ba480b121116×2484 91.4 KB

3

Oh. I am not sure I noticed that checkbox before or realized what it did.

Thanks, @mark-piller. Sorry for the fake bug report.

Tim