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:
Last updated: