MySQL Select rows where Timestamp is greater that 24 hours ago

The following works just fine in hand-coded PHP but it does not equate in Wappler.
PHP:
SELECT DB_INDEX FROM measurement where SERIAL_NUMBER = 'ENG0000-00001' AND TIME_STAMP > (NOW() - INTERVAL 24 HOUR)

I can get everything to work up to the > code. I pasted it directly into query builder and it gets saved as:

SELECT DB_INDEX FROM measurement where SERIAL_NUMBER = ‘ENG0000-00001’ AND TIME_STAMP > ‘(NOW() - INTERVAL 24 HOUR)’

I have tried removing the single quotes directly from the API page and had no luck. How would this query get created using Wappler? I can always just hand-code this but I like finding solutions inside the application.

Community Page
Last updated: