Not sure if I’m doing something wrong or if there’s a bug. I’m working on a custom query since Wappler’s Database Query Builder doesn’t support JSON functions (i.e. json_each). I am able to test the query in the Custom Query Builder, but when I add the App Flow to a page and run it, the query data is blank.
SELECT `FromName`, `Subject` FROM `Email`, json_each(`Email`.`GmailLabelIds`) WHERE json_each.value = ? ORDER BY `ReceivedDateTime` ASC;
This video shows the query builder returning records, but when I run the App Flow on a page, no results are returned.