ScriptCase 9

Chart Application

• New SQL aggregate functions for chart metrics: Count, Distinct Count, Variance and Standard Deviation.
• New dimension options for date fields, such as: Semester, Quarter, Trimester, Semester and others.
• Individualization of metric and dimension fields so that they can be configured independently.
• Reorganization of the chart creation interface with the option to drag the same field to chart dimension area (same field with different date period) or metric area (with different SQL aggregate functions).
• Analytic (multiple series) and synthetic (single series) combination of different dimensions on the same chart.
• New type of Search (User search) so that the end user can dynamically filter dimension and metric fields within the chart. Different display options for the values according to the data type.
• New LIMIT function that can be used to rank the values within the charts. For example: chart with the 10 best customers, 10 cities that have sold less in 2016, etc.
• New interface for chart themes full customization. Chart themes can now can be configured to project level or individually within the application.
• New chart themes already included within Scriptcase: pastel (based on google charts), flat (based on bootstrap charts), modern and dark.
• New chart types available: Scatter, bubble, Semicircular and Linear Gauge, 2D Funnel and 2D Pyramid.
• Option to add and customize subtitles for the charts.
• New customization options specifically to bar, column, pie and Gauge.
• Export the charts to PNG, JPG, PDF, SVG and XLS.

Dashboard Application

• New interface with drag and drop for setting up widgets dynamically. The widgets can now have different sizes and positions within the desktop.
• Responsive widgets.
• New index widget with field-specific settings and aggregate functions for presentation of KPIs (key performance indicators) within the dashboard.
• New widgets configuration and customization options. For example: hide toolbar items from linked application within the widget, layout formatting, filter, values abbreviation, etc.
• Integration of applications within the same Dashboard, e.g. Master detail between different queries.
• Dashboard update without recharging the page.

Grid Application: Reports and Pivot Tables

• New interface for the Grid creation with the option of selecting multiple tables and fields directly in the creation interface.
• New interface using drag and drop for defining the grid and summary group by, with new configuration options for the summary with individual field settings.
• New aggregate functions to chart metrics: count, distinct count, variance and standard deviation.
• New dimension options for date fields, such as: Semester, Quarter, Trimester, Semester and others.
• Possibility of dragging the same dimension (for different date period fields) or metric (with different SQL aggregate functions) more than once into the group by and summaries.
• New type of Search (User search) so that the end user can dynamically filter dimension and metric fields within the summary. Different display options for the values according to the data type.
• New LIMIT function that can be used to rank the values within the grid or summary. For example: summary with the 10 best customers, 10 cities that have sold less in 2016, etc.
• New configuration options within the summary aggregation: display the count of rows in the summary, hover showing column values and display the value in the subtotal line.
• New sorting settings for the summary fields.
• New option to abbreviate the values to display in the summary.

New Control application with layout free

• New option within the Control application that will allow the integration of Scriptcase forms with customized HTML and CSS or importer from external libraries. This option gives total freedom for forms layout customization.
• Body handling variables from HTML, visual can now be changed completely and adapted to the form with the proper Scriptcase markups.
• Support to events, libraries, macros, images, and Scriptcase field types.
• New templates provided by Scriptcase for login screens and contact forms.
• Possibility of integration between the layouts created by the control application with the security module login screen.

PDF Report with Drag & Drop design

• New option of drawing with drag n drop and dynamic configuration of the fields within the same interface.

Menu Application

• New option "menu structure" for layout customization with the option to use external libraries, methods and dynamic variables.
• Option to expand/collapse the menu to hide the items and expand the desktop within the application generated.

New themes

• New themes for the generated applications (sc_rinno).
• New CSS options for advanced themes customization (Application Layout).

Scriptcase Interface

• New interface to manage the projects with search option.
• New interface for project creation.
• New interface for Application creation.
• New interface for building grid applications (grid, search, chart and PDF Report) with a multiple-table query, multiple fields and validation of dependencies while creating the application with automatic identification of JOINS. New graphical interface to change the relationship between the tables.
• Option to expand/collapse the top and side menus to hide items and expand the desktop inside Scriptcase interface.

Scriptcase Environment & Security

• PHP 7.0 Support.
• PDO drivers update (SQL Server, MySQL).
• Addition of the PDO Dlib drive for SQL Server.
• Addition of the new MySQLi drive for MySQL connections.
• SSL for secure connections with MySQL.
• New Apache version 2.4.25.
• 32 and 64-bit architecture for windows installers.
• WKHTMLtoPDF library update.
• Fusion Chart library update.
• Automatic converters to projects developed in versions 7 and 8/8.1, i.e. projects of these version will be compatible with version 9.
• Production environment for generated applications approved for PHP 5.6 and 7.

Security module

• Social login option with Google, Facebook and Twitter generated automatically by Scriptcase security module.
• New encryption options for login application password field (MD5, SHA1, SHA256, SHA512).
• Security module integration with the new option of free-form control with templates responsive to login screen.
• Component update for automatic generation of captcha function to the login screen generated by Scriptcase security module.
• Option to assign more than one group for users created by Scriptcase security module.
• Creation of a new "default group" in the security module group table (in that group will be added new users that enter through the new user form generated by the module or by social login option).
• New option of integration with LDAP and groups creating on the Scriptcase users administration environment (development environment).

New Diagrams

• ER Diagram - New feature to improve the database management options, in addition to the SQL Builder and DATABASE Manager, was implemented support for creating ER Diagram for databases connected to Scriptcase.
• Project Diagram - New tool for generation of the Project Diagram. With advanced viewing and printing options.
• New native library for diagrams creation GoJS