Okay I have such a dumb question but I have spent what seem’s like an eternity trying to figure this out.
I am loving Wappler and still learning the software, as a longtime Dreamweaver user this is an amazing tool.
I read so much about people saying “Create a view in MySQL and use it in Wappler” great, but I cannot get it to display.
I have numerous tables with joins, insert and deletes using Wappler, all working like a charm, however I have a “Count, Group By, Having” View in MySQL that displays and works (in MySQL) however when I add the View to Wappler it returns nothing.
I create an action file, add a connection and query (don’t use any joins just the view), create the Server Connect and add a table, the headers are picked up and displayed however nothing, no data, just blank.
I have looked and looked but I am unable to figure it out, apparently i’m not that bright, I am setting the View up the same way I set up from a Table and all my tables work exactly as needed.
What am I missing? (is there a tutorial available?)
I’m connected to MySQL via a remote connection, however as stated the Table queries work fine.