A very interesting feature that comes natively within the platform development ScriptCase is a nested query with it is possible to create small areas of inquiry within a record table and data that have crossed regarding that information. Its use can have various purposes from creating complex reports sales by vendors to display drives for cost center into a financial system, for example.

If the nested query had to be programmed from the beginning programmer probably take hours to finish it, issues related to browser compatibility and especially the functions themselves would take too long. With this feature ScriptCase is easy to add more value application reports without representing a significant increase in the number of hours of development. All tests related functions and compatibility have been made by the team that develops the tool and thus the programmer saves time and how time is synonymous with a result you end up having a great programmer option.

To implement the nested query in a form is very simple, as other resources ScriptCase, simply access the application options and mark the corresponding option nested query (TreeView). Quickly and easily you create a connection to the database, choose the table and sets the whole grid without representing manual and repetitive work that would cost time, effort and budget. This feature gives your report a visually differentiated and richer information, often managerial levels of a company need complete data and in some cases this means three or four reports open at the same time for a single data is crossed. Using a nested query can cross any data that has relationship with the bank and bring this information from different tables so that information reaches the end user to quickly and objectively.

In presentations of this type of query result ends up being a difference as it is not necessary to be moving between different screens in the application to get certain information, just simply click the “+” sign and all necessary information inherent in that record will appear, it is not simple?


If you already use ScriptCase and doubts feature nested query (TreeView) to access our knowledge base and sane all your questions. If you do not use, access our page now ONLINE Course ScriptCase with PHP and start to take the first steps.

I hope you enjoyed these tips. Follow our blog and stay on top of all the news.

By ,

June 6, 2013


You might also like…

Business Process Automation with Scriptcase

In the modern business world, operational efficiency is not just a goal. It's a necessity. With inc...

“We developed RISK4ALL, a SaaS platform that allows implementing GRC in an organization with total security and privacy.” (RISK4ALL)

Come and discover the success case of the Risk4all, software, a multilingual and multi-company SaaS...

Security in web applications

In this article, you will learn about web application security and the options within Scriptcase th...

You might also like…

Get new posts, resources, offers and more each week.

We will use the information you provide to update you about our Newsletter and Special Offers. You can unsubscribe any time you want by clinck in a link in the footer of any email you receive from us, or by contacting us at sales@scriptcase.net. Learn more about our Privacy Police.