I cannot build a Query — at times when I add a new Custom Query and save when I select the Button to BUILD the Query it will not activate the popup Build Custom Query Wizard.
I do all the normal SAVES between all steps.
I also refresh the schema.
Then I may come back and find the Build button works & I get the Popup Wizard as shown in my uploaded image –
but the + button doesn’t build the query when I select the needed column names. Instead I get the image shown
:P1
:P2 etc.
On the Upper Right Database type Selector it starts in default SQL
I have to change it to MySQL but I still no longer can build queries unless I write them manually.
Hello @NewMedia
I am not really sure i fully understand what your issue is, but i the + button which is located in the Parameters tab adds a new parameter - it does not add a column to the query dialog:
Double clicking on a table column on the left adds it in the SQL dialog.
Can you please show a screenshot of which button do you click exactly?
Also - are you sure you need to use the custom query builder at all (where you are expected to enter your custom sql code), and not the regular query builder, which allows you to visually select everything?
took a short-cut to only show the right side of Wappler.
It has been confusing because I can see “similar” views if I open up APP Structure.
The Tutorial Binding data to a specific page instructions don’t SHOW having switched from
SERVER CONNECTION to FILE MANAGER Before all the Binding Data Steps.
Nothing I have found in the various Tutorials instructs to now Leave the Server Connection Menu & Open up the FILE MANAGER view for starting to Bind Data for Display in a Page.
Being that VISUAL APPROACH is the chief claim I expected to see & read every single step between creating database connections & queries & then working with the chosen php page.
Only today did I do a second-by-second start-then-stop examination of this following from video and see where the Tutorial showed the File Manager dashboard after all the Connections & Query creations.
Hello,
I don’t understand what are you referring to. You were talking about the custom query builder now you mention the files panel?
What has files panel to do with custom query builder or binding data on your page?
Can you please explain the problem you are having a little more clear?
The Tutorials breaking Creating a Database Connection into one module
and then another module about Displaying dynamic data on a page
for me, missed the Visual Cue to the Wappler Newbie that to step from making Connections & Custom Queries while in the same development session
the Setup for module 2 (binding & displaying from those connections & queries)
Required me to switch to File Manager first from my Server Connections work.
A seemingly unnecessary thing to show if you created Wappler or have used it over & over but Necessary.
IN FACT – as far as Tutorials – If DYNAMIC Data is a Huge Feature
why isn’t the most natural tutorial – “Let’s Start from scratch building a page that will display table data”
Step One: Let’s see how we make the database connection
Step Two: Now take that connection (working, right?) & use it to make a Custom Query of the table view we want to see Displayed on your page
Step Three: Now lets get that Custom query displayed on your page
“First, let’s get out of the Server Connect dashboard we just used for connections & queries.
Select just above on the left FILE MANAGER.
We’ll stay here to perform all of the following steps to Bind your Connection & custom query to your intended page. If you haven’t made that page yet, here in the File Manager you can go ahead and create it, too.”
What IS really AMAZING about Wappler is that the Chief Developer is IN THE FORUMS
actually Responding & Ansering & trying to Solve individual problems!
NOBODY ELSE offers that kind of Live Developer Technician Problem Solving!
Is your query really that complicated that you need to use a ‘Custom Query’? Writing custom queries requires some pretty extensive SQL knowledge. In most cases the regular query, paged query or single query do the job nicely and are much more user friendly.
Custom Queries don’t work in the same way as the other query wizards. In Custom Queries you actually have to type your full query. It’s not a ‘wizard’ like the other options.
