Page 1 of 1

SQL Builder

Posted: Tue Mar 27, 2018 8:37 pm
by Timo
Hi, I'd like to understand where a SQL statement created in the SQL Builder can be used. I created a sql statement ( Home -> SQL Builder ), entered a description and saved the record.
As you know, there is a button "SQL Builder" in the form properties. When I open the SQL Builder through this button, I don't see the sql statement that I saved. I couldn't figure out from the wiki entry how this should work either. Can someone explain that to me?
Thanks in advance.

Re: SQL Builder

Posted: Wed Mar 28, 2018 2:04 am
by admin
Timo,

They can be used when creating reports.

https://wiki.nubuilder.cloud/ ... orts#Table

Steven

Re: SQL Builder

Posted: Wed Mar 28, 2018 5:02 am
by Timo
At the moment I have no idea how use a stored SQL code. Haven't found an example or instructions. I'll have to deal with it later when I get into reporting.

Re: SQL Builder

Posted: Wed Mar 28, 2018 8:24 am
by admin
Timo,

Does this make more sense?
report_data.PNG
Steven

Re: SQL Builder

Posted: Wed Mar 28, 2018 9:38 am
by Timo
Thanks - got it. A picture says more than a thousand words.

Re: SQL Builder

Posted: Thu Mar 29, 2018 2:59 am
by admin
.