Scriptcase V8 Changelog. To see the last changes of previous version, click here.

ScriptCase v9.0.012 2017-07-21 00:27

Nuevas funcionalidades

  • Added support for chart application in helpcase.

Corrección específica

  • Fixed problem in setting horizontal alignment for summary dimensions.
  • Fixed problem when using field automatic lookup with SQL using schema (PostgreSQL).
  • Fixed problem using uppercase letters in dataset of sc_select macro.

Bug

  • Fixed problem using label field as primary key.
  • Fixed problem when clicking image of the Image Manager.
  • Fixed problem in displaying the menu icons in the advanced themes editor.
  • Fixed problem in chart application interface and dimensions.
  • Fixed problem in form creation interface.
  • Fixed problem in generating subtotal charts when displaying on the same summary page.
  • Fixed problem in content of HTML editor in form on insert mode.
  • Fixed problem in the path of images on the same server when using HTML Editor.
  • Fixed problem on date/time field interface in grid filter.
  • Fixed image layout of the connections when accessing the Database Builder.
  • Fixed problem in scrolling tabs when opening multiple applications.
  • Fixed problem in the button layout of the Save Grid option.
  • Fixed problem in the layout of the Database Builder interface.
  • Fixed problem in the grid configuration interface.

ScriptCase v9.0.011 2017-07-12 19:52

Nuevas funcionalidades

  • Added InsertCode in Form php methods
  • Added a new template system for creation of virtual learning environments (EAD). Designed to assist in content management and administration of courses online.

Bug

  • Fixed issue when dragging events from calendar application.
  • Fixed problem in charts PDF export in HTTPS environments.
  • Fixed error in devel\lib\ php\ database.inc.php line: 838 in font generation with PostgreSQL connections.
  • Fixed problem when starting chart with semi-circular gauge.
  • Fixed problem in generating internal libraries when using classes and objects.
  • Fixed issue in charset of fields label in dynamic group by.
  • Fixed SQL error when executing field in filter containing IF in SQL.
  • Fixed issue when using the sc_make_link macro when using variable in the application name parameter.
  • Fixed problem in the inclusion and automatic change of date fields. If the validation of required fields was performed, the date fields were losing the value.
  • Fixed fields creation and retrieval in the calendar application interface under PostgreSQL connections.
  • Fixed issue when importing RTL images into CSS buttons.
  • Fixed problem when saving the definition in manual lookup. It's necessary to clear the browser's cache.

ScriptCase v9.0.010 2017-06-29 18:50

Corrección específica

  • Fixed issue when using ODBC name with Access connections.
  • Fixed issue when changing quantity of records in horizontal forms.

Bug

  • Fixed charset problem in the groups button type link.
  • Fixed issue in the field update table link using fields in uppercase.
  • Fixed PHP 7.0 protection in numeric fields starting with zero.
  • Fixed fatal error: Redefinition of parameter $tabela in the field lookup.
  • Fixed Fatal error: Cannot use [] for reading the summary group by when using the percent field.
  • Fixed error with charset in the field help description of the filter.
  • Fixed error with Undefined variable: obj_attr1 in converted applications.

ScriptCase v9.0.009 2017-06-23 18:58

Corrección específica

  • Fixed Parse error: syntax error, unexpected ' public ' (T_PUBLIC) in the fields of relationship N x N.
  • Fixed error on viewing the calendar fields in the configuration "Calendar".
  • Fixed problem within form multiple records navigation after registry update.

ScriptCase v9.0.008 2017-06-22 17:05

Nuevas funcionalidades

  • Added the Helpcase button on the summary toolbar.

Corrección específica

  • Fixed issue in implementing the macro "sc_select_where(add)" after processing the php button using the macro sc_exit(sel).
  • Fixed issue in the submit page to change the option to view the mobile version.
  • Fixed issue in dashboard by using zero-dimensional index filter.

Bug

  • Fixed issue when using duplicate fields in the lookup.
  • Fixed error in return the lookup by using the checkbox field in the Grid filter.
  • Fixed problem when updating the image on the interface of the project properties.
  • Fixed problem in viewing the print button in the calendar application.

ScriptCase v9.0.007 2017-06-12 08:49

Bug

  • Fixed problem when using the sc_field_style macro in linked fields, in grid application using slide orientation.
  • Fixed problem with maps generation (Google Maps) on mobile devices.
  • Fixed problem sorting values displayed in the chart of summary.
  • Fixed problem displaying background images in Report PDF.
  • Fixed problem in chart loading when changing between static group by.

ScriptCase v9.0.006 2017-06-02 01:27

Nuevas funcionalidades

  • Added option "Save as" to external libraries available to Scriptcase level.

Corrección específica

  • Fixed SQL error in the log application generation with DB2 connections.
  • Fixed SQL error in dashboard indices with DB2 connections.
  • Fixed issue when creating the log table with DB2 connections.
  • Fixed error when creating the security module tables using the DB2 connection.
  • Fixed issue when creating the table in the calendar application with DB2 connections.

Mejora de rendimiento

  • Improved "active" field display in the application "grid_sec_users_groups" of the security module

Bug

  • ​Fixed issue in connections when entering the database name.
  • Fixed issue in the placement of fields in the pdf report headers images.
  • Fixed Undefined variable error "NM_tmp_del" when using the macro sc_menu_delete in the menu events
  • Fixed issue in "lines" button display when the Summary, Charts and Details modules were disabled within the Grid.
  • Fixed javascript error when using "Save Grid" option.

ScriptCase v9.0.005 2017-05-25 20:13

Corrección específica

  • Fixed problem when using buttons group in the Grid detail.
  • Fixed problem with capture links in the Control applications.
  • Fixed problem in the Charts PDF generation.
  • Fixed problem with fields display in the Grid detail. The fields were exicciding the Grid bottom toolbar.
  • Fixed problem in link naming in exporting applications.
  • Correction of the sending of langs feedback in the application language interface.

Bug

  • Fixed problem using log module with different connections in the application.
  • Fixed sorting problem in the Grid Group by.
  • Fixed bug in the insertion of html "doctype, html, head, body" in the html editor field.
  • Fixed SQL error in including files and images in the multiupload field.
  • Fixed problem in Grid sql when using ORDER BY clause with Postgres connections.
  • Fixed problem when clicking to edit project theme.

ScriptCase v9.0.004 2017-05-19 01:03

Corrección específica

  • Fixed duplicate label problem when using "Title on the same line" in the Nested Grids
  • Fixed error when running the Grids without items on the toolbar.
  • Fixed duplicate label problem when using other selected fields on the Group by line.
  • Fixed issue when using global variable in the Grid label.

Bug

  • Fixed error supplied for foreach () when generating application created by the Log Module.
  • Fixed problem in totals list in numeric fields of the dashboard indexes using Access ODBC connection.
  • Fixed accessing problem when using option "Use database session" on the values of ScriptCase system.
  • Fixed issue in decimal values in virtual fields in the summary totals.
  • Fixed display problem on the background image in the Layout of the PDF Report.
  • Fixed problem of disabled button after import project.
  • Fixed issue in view of the amount of records on the toolbar using dynamic breaking
  • Fixed issue in fields types recovery using SQL with JOIN in SQL Server (Native Server)
  • Fixed problem in the displayed values in the summary search using WHERE in the SQL query.
  • Fixed problem in sorting date fields in dimensions with drilldown in chart application.
  • Fixed CHARSET problem in PDF export the grid application using the Arabic language with WINDOWS-1256.
  • Fixed issue in value display using the macro sc_date_dif_2
  • Fixed problem in check of the record criticized by the validation of field required in the multiple records forms.

ScriptCase v9.0.003 2017-05-11 16:56

Nuevas funcionalidades

  • Improvements in the security module. From this version, when a new user is added using the "new user" application available within the login, the new user will be added to the group "default" available in the security module group type settings. The user will also become active automatically. However, if the option to "require activation by email" is selected during the security module creation, the user will not be active automatically.
  • Added the syntax N '' for the conversion of the string types Nchar, Nvarchar and Ntext in the Mssql Server databases.
  • Added option to display or not the amount of records in the select object in the summary filter.
  • Changed the "clear" button placement within the summary's search.
  • Improvement in the summary layout.

Corrección específica

  • Added validation on the backup/restore of files from version 8.
  • Fixed error of "Invalid argument supplied for foreach" devel/lib/php/database.inc.php 827 in the Grid lookups on Postgres connections.
  • ​Fixed issue when using SQL syntax index with MS Access connections.
  • FreeTDS path protection on shared servers.
  • Fixed problem in listing the total values of calculated field "percentage" on the Group by metrics.​
  • Fixed problem in totals list for numeric fields of the indexes in the dashboard using Access ODBC connection.
  • Fixed error in ordering the field "Number of records".
  • Fixed error in the sorting selection in the dimension when the group by was changed.
  • Fixed display error in the field "Number of records" in the summary sorting settings for inicial sorting.
  • Fixed alignment of the field "Number of records" in the summary.

Bug

  • Fixed error in deleting the master detail in connections with Firebird. (Bug from PHP 7.0).
  • Fixed SQL error in the summary, after converting queries using DISTINCT and quantity of records.

ScriptCase v9.0.002 2017-05-04 17:58

Corrección específica

  • Fixed problem of SQL syntax when using more than one index with different connections inside the dashboard application.
  • Fixed issue in app_container.js file path in the application dashboard.
  • Fixed problem the dashboard widgets toolbar option within the chart application.
  • Fixed problem of encrypted files in the production environment.
  • Fixed problem in the CAPTCHA display on Linux 64-bit Installer environment.
    (You will need to reinstall)

Mejora de rendimiento

  • Performance improvement in the Mac installer.
    (just available for new installations)

ScriptCase v9.0.001 2017-05-03 09:12

Corrección específica

  • Fixed problem in importing the sample Business Intelligence project using the database Mysql.
    Before update, clear your browser cache.

ScriptCase v9.0.000 2017-04-28 13:44

Nuevas funcionalidades

  • New SQL 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;
  • 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, and it can be customized also by the end user at run time;
  • 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 the subtitles for the charts;
  • New customization options specifically to bar, column, pie and Gauge;
  • Possibility to export the charts to PNG, JPG, PDF, SVG and XLS.
  • 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;
  • 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;
  • 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 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.
  • New option of drawing with drag n drop and dynamic configuration of the fields within the same interface in Report Pdf applications.
  • 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 for the generated applications (sc_rinno);
  • New CSS options for advanced themes customization (Application Layout).
  • 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.
  • Social login option with Google, Facebook and Twitter generate 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).
  • 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 Layout for Scriptcase documentation, more clean and intuitive for you to access the features of the development environment faster and easy.