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

ScriptCase v9.1.003 2018-05-18 20:16

Bug

  • Fixed 'unauthorized user' error message when deleting the project.
  • Fixed issue when using comment with slash on events.
  • Fixed crash when generating applications that contains parentheses in the application's SQL.
  • Fixed issue in creating Grid application when informing SQL with parentheses.

ScriptCase v9.1.002 2018-05-17 22:06

New functionalities

  • Added support for global variables in reCaptcha and Captcha fields.
  • Added capture link in tags filter.
  • Updated new component of the SPIN option of the Form.

Bug

  • Fixed issue in navigating the Grid using the Internet Explorer 11 browser.
  • Fixed horizontal scrolling issue in SQL Builder with results with many columns.
  • Fixed error in SQL, when changing charset in the creation of the application.
  • Fixed issue when using a global variable in sql Grid fields.
  • Fixed issue in aligning numeric fields in GridEditable forms.
  • Fixed issue in the display of the option "Validation Image" in the field of type "data", configured as mandatory.
  • Fixed issue in displaying the mandatory field message in ajax in date field in Forms.
  • Fixed issue in SELECT, RADIO and CHECKBOX fields using manual lookup in HTML controls.
  • Fixed issue when creating Grid applications using SQL functions without aliasing.
  • Fixed issue when creating Grid applications using queries like SELECT * table.
  • Fixed issue in the menu when using the toolbar buttons with the "hide menu" option. The buttons were not being displayed correctly.
  • Fixed issue using URL without "maps.google.com" in Google Maps fields.
  • Fixed reCAPTCHA validation on Form update.
  • Fixed error in running a Grid using JOIN on Access type connections.
  • Fixed problem in Search of QuickSearch containing apostrophe.
  • Fixed CSRF Token error in applications opened within the menu tabs.
  • Corrected problem using the "Use Password" option in the security of applications that used connections. The applications that received the connection were loaded by requesting the password again.

ScriptCase v9.1.001 2018-05-09 23:52

New functionalitiesUPGRADE REQUIRED

  • Enabled the email export buttons in the Grid's detail.

Bug

  • Fixed issue in Access connections using password.
  • Fixed issue in menu events using strings.
  • Fixed charset issue when entering values in form Editable Grid view.
  • Fixed charset issue in the "Description" field in the calendar application when using ISO-8859-1 charset.
  • Fixed issue in the email API interface in the production environment. (You will need to update your production environment).
  • Fixed problem in typing the numeric fields by using the option complete with zeros.

ScriptCase v9.1.000 2018-05-07 06:59

New functionalitiesUPGRADE REQUIRED

  • A new interface for managing APIs directly from Scriptcase with automatic integration with the email APIs services: Mailchimp, Mandrill and Amazon SES.
  • New Macros sc_call_api and sc_send_email_api for advanced implementations with APIs integration within Scriptcase events, control and blanks.
    Documentation: sc_call_api
    Documentation: sc_send_mail_api
  • New button to send emails from Grids, Pivot Tables and Charts with reports attached in PDF, HTML, XLS, XML, CSV, RTF, WORD or images. Push settings can easily be shown within the interface using SMTP, Amazon SES or Mandrill. Sample
  • For Chart applications where added new settings to export to formats: XLS, XML, CSV, RTF, WORD and image; Sample
  • For HTML and Images exports from Chart applications, it was added a new important option for Chart depth output selection, according to the metrics used. Sample
  • New option for depth output selection to PDF exports within Grid Applications.
  • New dynamic tags for Advance Search module that allow you to select or manipulate the conditions and fields with ajax directly within the application with a simple and modern interface. Sample
  • New configurations options that allows, for example, to add buttons within the Advanced Search form body. Sample
  • In the Summary and Chart Search feature were added new relative period conditions to Filter: "Current week until today", “Current quarter until today” and “year to date”.
  • New options for creating customized periods with related conditions directly within the Summary and Chats Filter interface. It gives you freedom to create special period of date. Sample
  • Added new keyboard shortcuts for performing basic functions of Scriptcase as: Generate the source code, Save application, Run, Closing/Opening tabs, access SQL Builder and others
  • New option to display Nested Grids as XLS export.
  • New setting to configure Chart original sorting values to and return to default state.
  • Scriptcase codes editor, used within the events, control and application blank with new options for viewing with lateral expansion or full screen code area and access to new themes.
  • Integration with shortcut keys from editors Emmet and Sublime Text, that is, the shortcut keys of these editors will be recognized within the Scriptcase.
  • CSS and Javascript language interpretation support within the code editor.
  • New button for project execution.
  • New example template with the HTML diagram library of GoJS for creating Mind maps This template will be inside the "Samples" project (you will need to import samples project to access the applications).
  • Database Builder update with a new Interface facilitating performance for creating and changing your database. New theme, store server-side to avoid excessive requests, accessibility labels (HTML5) and new languages: Danish, Greek, Galician, Bulgarian, Bosnian, Finnish, Hebrew and Malay.
  • Database Builder update for MySQL: Support connecting to MySQL via SSL, support JSON data type, Support MySQL 8.
  • Atualização do Database Builder para o MariaDB: Suporte JSON desde o MariaDB 10.2 e suporte a índices fulltext e espaciais no InnoDB.
  • Database Builder update for PostgreSQL: Support binary files in bytea fields.
  • Database Builder update for PostgreSQL: support JSON and JSONB data types, materialized views.
  • Database Builder update for SQLite: Allow deleting PRIMARY KEY from tables with auto increment.
  • Database Builder update for SQLite: enable FOREIGN KEY CHECKS.
  • Database Builder update for SQL Server: Support freetds.
  • Database Builder update for SQL Server: support pdo_dblib.

Performance improvement

  • Updating the new HTML editor

Bug

  • Fixed issue when using the macro sc_label in multiple record forms and grid editable.
  • Fixed issue in setting the maximum size of the field on the filter settings.
  • Fixed issue in preview of the label of the columns in the XLS export when the application was using language variables.
  • Fixed issue in the duplicity of the characters as they are typed in mobile environments.
  • Fixed issue when pressing the enter key in multi-line text field.
  • Fixed issue in CSS tabs in static and dynamic Groupby in Grid application.
  • Fixed issue in the "Maximum Size" option in the multi-line text field.
  • Fixed issue when importing a spreadsheet where the name contained numbers.
  • Fixed issue when inserting an image with link in the field EditorHTML.
  • Fixed issue in the Google Maps field view in the Editable Grid form (View).
  • Fixed issue in processing the "Exit" button of the Control application, when the application was executed within the menu.
  • Fixed problem in passing parameters in the field link of the Grid, when the Form had composite key.
  • Fixed JavaScript error in the "Save Grid" button of the Grid application.
  • Fixed issue in displaying the Summary on the same page of the Grid, after navigation of records.
  • Fixed issue in Internet Explorer, by keeping focus on text area fields while the values ​​is being filled.

ScriptCase v9.0.043 2018-03-22 23:25

Specific correction

  • Fixed problem with alignment of fields' type "radio" and "checkbox" when using manual lookup.
  • Fixed issue in visualization of indexes on the dashboard applications using the SQL Server connection.
  • Fixed issue in the HealthCare System with Postgres, SQL Server and Oracle connections.

Performance improvement

  • Improvements in the applications sorting in the project applications's list.

Bug

  • Fixed issue in target "_blank" parameter of the macro "sc_redir" by using the macro along with the macro sc_exit.
  • Fixed issue when using the "dynamic filter" button on summary application.

ScriptCase v9.0.042 2018-03-15 23:50

Specific correction

  • Fixed problem using the macro sc_hide_groupby_rule in grid applications.

Performance improvement

  • Improvement in group by of summary group by using Progress connection.

ScriptCase v9.0.041 2018-03-15 08:10

New functionalitiesUPGRADE REQUIRED

  • Added new healthcare sample system. UPGRADE REQUIRED View Example

Specific correction

  • Fixed issue in Quicksearch when using the connections of type "Progress".
  • Fixed issue of accentuation in the help descriptions of the fields in the Filter application.
  • Fixed issue of accentuation in the visualization of the values of the manual lookup in the breakdown of the query.
  • Fixed issue in the search of field type "data" in connection of type "Progress".

Bug

  • Fixed issue in viewing the "rows" button in the Grid, when the Summary module was disabled.

ScriptCase v9.0.040 2018-03-08 00:17

New functionalities

  • Added option to run the onchange event in the field of the master Form when using sc_master_value macro in Form detail.

Specific correction

  • Corrected issue when using the values of the field of type "data" in the Groupby of the Summary, in the connections of type Progress.

Bug

  • Fixed issue using the CONCAT command in the Grid lookup.
  • Fixed bug when using the "Arial" font in the ReportPDF application.
  • Fixed issue in Chart filter view when exporting to pdf.

ScriptCase v9.0.039 2018-02-28 23:03

New functionalities

  • Added new Progress connection module.

Specific correction

  • Fixed issue in updating the values in the lookup type of multiple binary values.
  • Fixed issue in the field tab "date" in the Filter using the range condition.
  • Fixed issue when using SQL UNION in autocomplete fields.
  • Corrected option to Convert Letters of the field in Filter applications.

Performance improvement

  • Improved performance in the "date" field searches on MSSQL Server connections.

Bug

  • Fixed issue with “Filter Saving” using "double select" field type.
  • Corrected issue with "Filter Saving", when the Grid had Group by using data type fields.
  • Fixed issue when saving theme in Charts, in Scriptcase versions that were installed with MySQL.
  • Fixed issue in ajax events of the Grid when using full pagination. Before that, the event was only created in the first 10 records.
  • Fixed issue in Filter search with negative values.
  • Fixed issue in character display in Summary Filter using charset windows-1255 (Hebrew).
  • Fixed issue using the CONCAT command in the Grid lookup.

ScriptCase v9.0.038 2018-02-21 22:46

Specific correction

  • Adjustments in the display of the Chart application and Summary Filter buttons.

Bug

  • Fixed issue in the lookup description of the text fields and autocomplete numbers when returning from the Grid.
  • Fixed height in the checkbox by clicking multiselect on refined filter.
  • Fixed issue when using the sc_log_add macro in the Blank application.
  • Fixed issue when assembling the "Order by" in the SQL of the Grid, when the application has two breaks for the same field of type data.
  • Fixed issue in viewing images from field "image file name" using the subdirectory option.

ScriptCase v9.0.037 2018-02-16 00:13

Specific correction

  • Fixed issue when using parentheses at the "hint" parameter in the sc_link macro.
  • Fixed issue when using the "sc_label" macro in fields that use language variables, generated by the data dictionary in Grid applications.
  • Fixed issue in the display of the "docx" extension icon, when using the "Display the file type icon" option in the document fields of the Grid application.
  • Corrected height in the checkbox by clicking multiselect of the refined filter.

Performance improvement

  • Improved performance in Summary applications.
  • Improved performance in field data searches on Postgres connections.

ScriptCase v9.0.036 2018-02-05 14:25

New functionalities

  • Added support for global variables through the new macro "sc_make_link".
  • Added new options under summary and charts filters.

Specific correction

  • Fixed problem in the table creator interface for calendar applications with an Access connection.
  • Fixed problem with the format of time values in the backup filenames.
  • When using an Editable Grid (View) form, File Upload fields now can only be downloaded on lines that are in editing mode.

Performance improvement

  • Improvement of performance of autocomplete fields on a filter.

Bug

  • Fixed problem with the images and templates copied while migrating from version 7 to 9.
  • Fixed problem with the images and templates copied while migrating from version 6 to 9.
  • Fixed problem that could corrupt GroupBy data while migrating from version 6 to 9.
  • Fixed issue in version 5 to 9 migration.
  • Fixed problem when using sc_redir in a PHP method called from a PHP button.

ScriptCase v9.0.035 2018-01-24 21:12

Specific correction

  • Fixed issue in returning a connection when we use the sc_select (where) macro in the source application.
  • Fixed issue when running the application "Dashboard" in the interface's initial mode.
  • Fixed issue in view of field lookup when condition had dot.
  • Fixed problem of accentuation in the label of the macro button "sc_ajax_message", when using charset other than UTF-8.
  • Corrected spacing of the navigation buttons being displayed below.

Bug

  • Corrected issue in displaying the values of the field "Data" in the interface of the Group By. You will need to clear your browser's cache.
  • Fixed special SQL error in Grid Application.
  • Fixed anchor of the menu link in the documentation.

ScriptCase v9.0.034 2018-01-18 23:27

New functionalities

  • Added lang support in the sc_alert macro. Ex: sc_alert ({lang_btns_ajax})
  • Enabled the image and document database fields in the Grid columns interface.
  • Enabled the examples in the onScriptInit event of the Grid.

Specific correction

  • Fixed validation of values in the interface of version incrementation.
  • Fixed issue in the events help link.
  • Fixed issue in searching for Dynamic Search with data type "TIMESTAMP WITH LOCAL TIMEZONE".
  • Corrected issue in viewing the refined filter values, after returning from Summary Group by links.
  • Fixed issue in hint viewing on field links using Sc7_Black theme.

Bug

  • Fixed issue Tab_lig_apls is not defined in Grid links called through the Menu.
  • Fixed issue in the display of the "delete" button when canceling the edition of record in the Grid view editable Form.
  • Fixed "Array to string conversion" error when using the sc_mail_send macro.
  • Fixed issue when generating a free format Grid without the toolbar buttons.

ScriptCase v9.0.033 2018-01-11 14:33

New functionalities

  • Added RTL language support in the Summary filter.

Specific correction

  • Fixed Grid export issue when using macros "sc_seq_register" and "count_ger" in the OnRecord event.
  • Fixed macro help link in events.

Bug

  • Fixed issue in Chart display in pdf export.
  • Fixed issue in Nested Grid type links.

ScriptCase v9.0.032 2018-01-10 15:30

New functionalities

  • Added option to display the background image of the pdf report when no record is found. This option is available in the SQL interface menu.
  • Added option for the positioning of the registration message that does not exist in the PDF Report. This option is available in the SQL interface menu.
  • Added dropdown support in SELECT filter fields.
  • Added support for complex SQL in Auto-complete fields.

Specific correction

  • Fixed issue in the "Group Label" view in the forms, when there was a hidden field in the application.
  • Fixed issue in sorting's layout configuration of Summary when changing order of fields from Group by.
  • Fixed issue in the menu layout when using the "hide menu" option in the Edge and I.E 11 browsers.
  • Fixed issue generating a Subselect field in pdf report application in php 7.1 environments
  • Fixed issue when cleaning refined filter search in fields named as length.
  • Fixed issue in PDF export support using grids with custom layout from events.
  • Fixed issue in color views of the negative values ​​of the Summary.
  • Fixed issue in viewing the size of the buttons in the bindings of the iframe Grid type.

Bug

  • Adjustments in the fields verification condition in the multiupload option.
  • Fixed issue using empty paragraph tag in HTML editor.
  • Fixed JS issue when clicking on links from image fields in Grid.
  • Fixed issue using function keys in Firefox.
  • Fixed issue when using color html field with color palette on horizontal forms.
  • Fixed issue in exporting Excel from array Summary.
  • Fixed issue in XLS and XML export when referencing some field of type "date" in onGroupByAll events.
  • Fixed line break issue in "multi line" fields in PDF Report application, when using the convert letter option.
  • Fixed bug when using link button in editable Grid form (view).

ScriptCase v9.0.031 2017-12-26 14:48

New functionalities

  • Added new values ​​in the "negative currency format" option in the total fields of the summary.
  • Added grid navigation configuration support from master / detail.
  • Added support for YEAR fields.
  • Added support for Nested Grids in Grid details.
  • Implemented support to macro "sc_format_num" in the onrecord event of the grid, using summary fields.
  • Added "port" option in SFTP publishing settings.
  • Added port data entry for DB2 connection.

Specific correction

  • Fixed issue when converting Access tables that have images.
  • Fixed issue in the initial execution of pyramid and 2D funnel charts.
  • Fixed issue when using subselect command in field lookup.
  • Fixed issue when running operations directly in the application's SQL.
  • Fixed issue using "Use ENTER to Submit" option in dynamic filter settings.
  • Adjustments in the Nested Grid CSS when using the title option on the same row.
  • Fixed issue in view of the buttons size on the iframe type connections.

Bug

  • Fixed issue in viewing the records in the calendar by checking the option "all day". The schedule showed less 1 day.
  • Fixed issue in formatting millisecond fields.
  • Fixed duplicate data insertion problem with dynamic search.
  • Fixed issue when using the database session option in the post.
  • Fixed issue in viewing calendar time on Oracle connections.
  • Fixed issue in the Themes view of the tree menu. The tree menu was not inheriting the Themes CSS.
  • Fixed Fatal error: Uncaught Error: Call a member function Execute () when using the sc_lookup macro in the ReportPdf application onHeader event.
  • Fixed issue in the informed value of the negative field of manual lookup of the multiple selection fields.
  • Fixed issue in viewing calendar records on Access database connections.
  • Fixed issue when using the menu toolbar with image type buttons.
  • Fixed issue when using link button in Editable Grid Form (view).
  • Fixed issue in pdf export when printing mode was configured for economic.

ScriptCase v9.0.030 2017-12-13 23:01

New functionalities

  • Added macro support "sc_format_num" in the onrecord event of the grid.

Specific correction

  • Adjustment in error display when editing multi-upload fields.
  • Fixed issue in gantt chart view with other date formats.
  • CSS settings in the editing of the menu toolbar and editing of menu items.

Bug

  • Fixed issue in macro "sc_field_disabled" in fields select multiple values in single record form.
  • Fixed issue in connection of subquery type in firebird connections.
  • Fixed issue in express creation of applications.
  • Fixed bug with sc_ajax_message macro.

ScriptCase v9.0.029 2017-12-11 20:59

New functionalities

  • Addition of new sources from the Report PDF application.
  • Added option for title break in calendar view.

Specific correction

  • Fixed issue in the display of the "filter conditions" in the "double select" field in the generated filter applications. From this version onwards, the filter will support the conditions: equal, contains, different, does not contain, empty content, non-empty content.
  • Implemented the option to use the "FORCE ORDER" command in grids using the MSSQL Server connection.
  • Fixed issue using the sc_ajax_message macro in the html control application.
  • Fixed issue in assigning the fields in the onLoad event in the html control application.
  • Added macro support "sc_btn_display" in editable grid forms and editable grid view. Note: The code must be used in the onLoadRecord event, where it will be executed with each record in the record. If done on onLoad, it will run only once.
  • Fixed issue when using submit option in onChange and Ajax processing in grid filter.

Bug

  • Fixed issue in displaying the characters when being informed in the quicksearch field. The error occurred in Chrome and Safari browsers.
  • Fixed "Undefined offset" error when using the sc_date_dif_2 macro.
  • Fixed issue when creating a Subselect field in the Reportpdf application on Firebird connections.
  • Fixed issue in displaying the fields of the breaks in the matrix summary selection interface.
  • Fixed issue in viewing recurrence fields in calendar application. The fields were not being hidden in the Firebird and Oracle connections.
  • Fixed issue in the 'Display values' option of the generated application not being inherited from the interface.
  • Fixed issue when using macro "sc_field_disabled_record" in select fields of type multiple values.

ScriptCase v9.0.028 2017-11-30 23:21

Specific correction

  • Fixed issue when running the sc_error_message macro in the onValid event on mobile devices.
  • Fixed issue when using the high box setting of text type fields on mobile devices.
  • Fixed issue in time view in calendar events using SQL Server connection.

Bug

  • Fixed issue in grid export containing hour type fields.
  • Fixed issue when informing the path of the data source in the interface Import of Access.
  • Fixed error of Undefined variable: str_tog_help when clicking on the relationship item N x N.

ScriptCase v9.0.027 2017-11-28 08:28

New functionalities

  • Added new values for the "uncategorized" option in the "category" field in the calendar application.

Specific correction

  • Fixed issue when using the "Database session" option with the MariaDB SGDB.
  • Fixed bug in field view when application was created containing the hyphen character in application name.
  • Fixed issue in creating calendar table in Oracle connections.

Bug

  • Fixed issue in the "where" clause of the grid filter, when the main SQL had a clause "where".
  • Fixed bug in the creation of the field "Subselect" in the connections of type Access.
  • Fixed issue in viewing the records in the calendar when using the category filter option.

ScriptCase v9.0.026 2017-11-22 07:38

New functionalities

  • Added new options for border "color" and "width" in the form blocks' CSS
  • Automatic Recovery of ' auto increment ' value in the DB2 type connections
  • Added support for "tab" key for autocomplete fields for the first record add.
  • Added new options for border "color" and "width" in the form fields' CSS
  • Added support to ajax events creation for the "category" field in the calendar application.

Specific correction

  • Fixed Fatal error: Invalid handle returned, MSSQL SERVER connections.
  • Fixed issue in Grid SQL when using the character * (asterisk) within a case statement.
  • Fixed issue when creating the calendar table using Firebird connection.
  • Fixed issue in the amendment and updating of the indexes in the data dictionary.
  • Fixed issue when synchronizing the field size in the data dictionary.
  • Fixed issue in Grid SQL when using the character "hyphen" within a case statement.
  • Fixed issue when creating a button and choosing that it only appears when edditing a Editable Form (Grid view) format.
  • Fixed issue in aligning radio and checkbox fields.

Bug

  • Fixed formatting problem of the fields "currency" and "decimal precision" in the Advanced Search.
  • Fixed issue with scrollbar when changing menu's tab.
  • Fixed issue when creating Grid application using JOIN in Access connections.
  • Fixed issue when using the macro "sc_date_conv" at the OnHeader event from ReportPDF application.
  • Fixed an issue in the Editable Form (Grid view), when the primary key field was not displayed in the application.

ScriptCase v9.0.025 2017-11-17 00:30

New functionalities

  • Improved responsiveness of the calendar application toolbar.

Specific correction

  • Adjustments made in the "Characters Allowed" field alignment in the field settings of type "Text".
  • Fixed issue using global variables in sc_exec_sql macro.
  • Fixed issue in retrieving data types when importing an excel file.
  • Fixed issue when editing the field that updates the application connection table "app_form_edit_users" generated by the security module.
  • Fixed issue when incrementing the version of a project, when there was a log module configured to the project.
  • Fixed issue when automatically identifying the unique keys of the SQlite connections in the form.
  • Fixed issue using the sc_changed macro in the DATETIME field in the MSSQL SERVER connections.
  • Fixed issue when updating zip code in the onChange event, using autocomplete fields in assignments.

Performance improvement

  • Adjustments in the application creation interface when the table and field names exceed the input preview limits.
  • Removed white space in the html code generated by the form when there was a capture link.

Bug

  • Fixed issue when using refined filter in field with alias in Grid with GROUP BY.
  • Fixed issue when using a field containing a capture link and an ajax event on mobile devices.
  • Fixed issue using the sc_set_language macro in the onScriptInit and onApplicationInit events.
  • Fixed issue using the sc_error_exit () macro in the onValidate event of the filter.
  • Fixed issue in the calendar's exit button display in deployed environments.
  • Fixed issue in visualizing the fields of the dynamic breaks in the totals of the grid.
  • Fixed issue in link of dynamic breaks using SQL with JOIN and fields using capital letters.
  • Fixed bug when adding another display field in summary filter lookup. You will need to clear your browser's cache.
  • Corrected issue in the option "Create link in chart" of Grid chart.
  • Fixed issue in XLS and XML export when referencing some field of type "date" in onGroupByAll events.
  • Corrected issue in aligning the fields of the pdf report using the "record per line" type.
  • Fixed issue with line break in HTML editor fields with fields of type LONGBLOB.

ScriptCase v9.0.024 2017-11-13 08:47

New functionalities

  • Added option to hide caption in chart. Option is now available in the chart settings.
  • Inclusion of the 'BETWEEN TWO VALUES' condition for the 'TEXT', 'VALUE' (currency) and 'DECIMAL' field types under the filter conditions.
  • Added option to select initial values ​​in the dynamic break interface.
  • Added the value of "Dynamic Break" in the "Break Initial" option in the break settings.
  • Added option to display or not the "new record" button of the grid in the Dashboard toolbar.
  • Adjustments in the layout of breaks.

Specific correction

  • Fixed issue of downloading files in the Multi-upload form in mobile mode.
  • Fixed issue in option 'Display values' and 'Short values' in multi-series graphics.
  • Fixed issue in event display while hiding calendar categories filter.
  • Fixed issue when setting the maximum file size. The application allowed to send a file of a larger size than the one that was configured.
  • Fixed issue when copying html files in Helpcase tool. The title of the page was not being replaced.
  • Fixed issue in displaying project name after accessing Scriptcase.
  • Fixed issue in time display in events with no time and / or end date in the calendar.
  • Fixed issue using the sc_changed macro in the date and time field in the MSSQL SERVER connections.
  • Fixed issue in the "Display Mask" option in the settings of the break fields.

Bug

  • Fixed issue in the preview of the default values ​​in the summary filter.
  • Fixed error in the pdf layout by the registry option per line in the interface.
  • Fixed the Grand Total option of chart applications.
  • Fixed issue when changing the grid SQL in grid and graphical applications. The "Number of records" field was being removed from the total.
  • Fixed issue sending file with extension that are not allowed. Invalid file message was not being displayed.
  • Fixed unserialize () error: Error at offset 625 of 774 bytes | Script: nmField.class.php line: 4114, when entering more than one lookup field in the summary filter.
  • Fixed issue in the summary link generated through dynamic breaks using SQL with JOIN.
  • Fixed issue in Gauge chart generation.
  • Fixed error: Invalid argument supplied for foreach () - 2707 nm_gp_consulta_cons.php when using the empty "break" option.

ScriptCase v9.0.023 2017-11-03 20:36

Specific correction

  • Fixed mkdir() error in generating applications.

ScriptCase v9.0.022 2017-11-03 14:09

New functionalities

  • Added option to display events without filter categories within the calendar.
  • Added support to add multiple categories in the calendar filter.
  • Added option to hide the filter categories field within calendar.
  • Added option to export calendar events to Google Calendar.
  • Updating the FusionCharts Chart Library, now supports FusionMaps(Need to upgrade your production environment)
  • Added support for the FusionCharts library in the sc_include_lib macro.
    Video

Performance improvement

  • Improvement of Scriptcase projects converter.

Bug

  • Fixed problem in the PDF report layout display on the interface when using the width and height parameters in the customized format.
  • Fixed problem when using label fields with Javascript code.
  • Fixed problem in the PDF report help ruler when using the customized format.
  • Fixed interface problem with PHP method names.
  • Fixed problem with when selecting an internal library in the project default values, and then creating a blank application. The library wasn't being check in that cases.
  • Fixed problem when using lookup as field description in MS SQL Server connections.
  • Fixed problem with the link between Grids and Forms (throttling starts by the filter). The exit button was not displayed.
  • Fixed problem when using sc_set_language macro in the blank application.
  • Fixed problem when using the macro sc_select_where(add) with the option "any condition" in the Grid filter.
  • Fixed problem accessing the Image Manager from the home page in the Helpcase settings.
  • Fixed problem accessing records in the calendar after the update/insert other.
  • Fixed problem on "Repeat one each" insertion on calendar events.
  • Fixed problem in calendar events display, from printing.
  • Fixed problem when using the "sc_concat" macro from search autocomplete fields.
  • Fixed problem in the lookup display in the dynamic group by from Grids when using a calculated field.
  • Fixed problem when running the menu using the Catalan language (Spanish).
  • Fixed problem in size of the object "Double Select" display from dynamic search.
  • Fixed problem with global variables display when defined within group by lookups.
  • Fixed problem in the search autocomplete when using subselect in the Grid main SQL.
  • Fixed problem with the summary link when using dynamic group by.
  • Fixed problem with pie chart button for various dimensions with drill down using only one metric.
  • Fixed problem on Grid application when creating a link from the Chart to a Grid.

ScriptCase v9.0.021 2017-10-19 22:45

New functionalities

  • Added new example project Personal Finances.
  • Added new events in the calendar application: onCalendarApplicationInit and onCalendarScriptInit.
  • Added DB2 support in sample projects.
  • Added support for .tgz formats in the deploy generation.
  • Added support for the GoJS library in the sc_include_lib macro. Check the documentation

Specific correction

  • Fixed bug in reCAPTCHA SSL certificate in Mac OS. For environments already installed, see the tutorial
  • Fixed problem when dragging multi-day events into calendar.
  • Improvement in the layout of the Calendar Categories field in the form of calendar application.
  • Fixed preview problem on calendars buttons called from dashboards.
  • Fixed problem in multi-day event viewing in calendar.
  • Fixed problem in viewing times at events marked 'full day' in the calendar.

Bug

  • Fixed error "file_get_contents() failed to open stream: No such file or directory" when viewing the layout in the application settings.
  • Fixed problem when saving theme name of the menu using the "/" character.
  • Fixed problem viewing the HTML code of a header template copied in Helpcase.
  • Fixed problem creating header template in Helpcase.
  • Fixed problem in the analysis of comments by blocks and line with global variables.
  • Fixed problem navigating forms, when using option "Use Checkbox in drop down" in select fields.
  • Fixed problem using global variable in lookup field with group by in the grid.
  • Fixed problem using the connection parameter, being created dynamically through the macro sc_connection_new.
  • Fixed problem with displaying language/regional settings in application settings.
  • Fixed problem in the options saved in the security module profile.
  • Fixed problem displaying the date field using other formats in the chart application.
  • Improved text in the interface for uploading external libraries.
  • Fixed problem in link of type application, when the key field had dot.
  • Fixed problem in grid totals when using Group by syntax in main SQL.
  • Fixed problem when entering values ​​with accent in the option "Text between values" in the settings of the date field in the search.
  • Fixed problem when inserting date type fields, disabled in the interface and assigned through events.
  • Fixed problem in "Save Filter" option in generated applications, using select fields with Ajax processing.

ScriptCase v9.0.020 2017-10-06 16:44

Specific correction

  • Fixed problem in automatic updating in Windows environments. (failed to open stream: Invalid argument, md5_file)

ScriptCase v9.0.019 2017-10-06 02:32

New functionalities

  • Inclusion of new configuration options in the calendar application.
    Video
  • Integration with Google Calendar.
    Video
  • Added new field for calendar categories.
  • Added category filter in calendar sidebar
  • Added Google reCAPTCHA v2 integration in creating the security module.
  • Added Google reCAPTCHA v2 integration in form, control, and calendar application security.
  • Added option for color palette in the Color HTML fields.
  • Added option to hide recurrence fields in calendar application.
  • Configuration of the width and size of the calendar.
  • Added option to hide time fields when scoring all day in calendar application.

Bug

  • Fixed problem in "Empty Content" condition of checkbox fields in search.
  • Fixed problem when using the "Select the fields that will be displayed in the Group By line" option when the field was not being used in the Group By.
  • Fixed issue when running menu application without setting up a connection.
  • Fixed problem in analysis of comments by lines and blocks.
  • Fixed issue when using sc_field_style macro on links created by the sc_link macro.
  • Fixed problem when displaying date type values ​​when using the sc_log_split macro.
  • Fixed problem in later records behavior when using sc_field_style macro.
  • Fixed problem in reloading dashboard indexes.
  • Fixed problem in the use of virtual fields in the grid Group By.
  • Fixed issue of footer display in PDF export of Chart.
  • Fixed issue when using special characters fields in grid Group By using MSSQL Server connections.
  • Fixed problem using field variable on Group By label.
  • Fixed problem in totalization display when Group By field has value 0.

ScriptCase v9.0.018 2017-09-05 23:00

New functionalities

  • Added new application theme, "Sc9_Meadow".
  • Added new values ​​to the "Relative Period" option in the summary search.
  • Added support for default values ​​in chart and summary search.
    Video
  • Added option to sort values ​​in chart with drill down navigation.
  • Improved display of filtered field for chart and summary.

Specific correction

  • Fixed problem in PDF export of chart application.
  • Fixed execution problem in checkbox fields configured with manual lookup and Ajax event.
  • Fixed problem when accessing dynamic group by in summary: At least one field should be related to the Y axis.

Bug

  • Fixed problem uploading files to HTML templates.
  • Fixed problem with 'copy' button for Helpcase HTML template.
  • Fixed problem when creating a Helpcase header template.
  • Fixed problem in "Create Select" interface in lookup settings.
  • Fixed problem using "Relative Period" with "Multiple Values" option in summary and chart search.
  • Fixed interface problem when renaming the application.
  • Fixed problem when saving "Negative number format" option in fields and regional settings.
  • Fixed problem when copying images through image manager.
  • Fixed problem in viewing the connection icons in XLS, CSV and Access import.
  • Fixed display problem in dimension numeric field settings.
  • Fixed problem in langs view in the calendar of data type fields.

ScriptCase v9.0.017 2017-08-18 12:59

New functionalities

  • Added button to print in the export of the detail of the print type query.

Specific correction

  • Fixed issue in the visualization of the buttons using the sc_btn_display macro.

ScriptCase v9.0.016 2017-08-18 01:36

New functionalities

  • Added option to start by the filter in chart applications. Option available in settings interface.
  • Improved display of the "Export Chart" option in the chart interface. Option available in chart settings.
  • Improved the look of the "Filter Conditions" item of the filter menu in the interface.
  • Added the control application in the "Connection Widget" of the dashboard.
  • Added sc_text_style macro for Grid application. View documentation
  • Added button to print in the Print Grid export.
  • Added option " between two values " in filter conditions for numeric fields.

Specific correction

  • Fixed issue in displaying the field type Youtube configured as modal.
  • Fixed recording of the "File name (only to store in the database)" option in the multi upload fields.
  • Fixed chart display when using filter in chart applications.
  • Fixed issue in totalization variables in onGroupBy when not using groupby.
  • Fixed negative format display for Decimal fields of groupby totalization in the Grid application.
  • Fixed image upload selector display in HTML Templates.
  • Fixed issue when listing internal libraries in the project default values.
  • Fixed issue using global uppercase variables in the dashboard filter.
  • Fixed issue in the HINT view of the sc_link macro in URL fields.
  • Fixed issue using sc_field_read only macro in Ajax Events.
  • Fixed issue in button display when using sc_btn_display macro.
  • FIxed issue in horizontal scrolling of the side menu of applications.(You will need to clear your browser cache)
  • Fixed issue in displaying " Filter Settings " and " Special Conditions " options in "date" and "datetime" virtual fields of the filter.

Performance improvement

  • Improved performance in advanced search of date fields using PostgreSQL connections.

Bug

  • Fixed issue in the visualization of the field options "Initial ordering" in the graphic interface.
  • Fixed Fatal error: Parameter Redefinition, when using field name Duplicate in autocomplete field edit lookup.
  • Fixed grid pagination problem using Limit option.
  • Fixed issue when setting the NULL value in fields of type nVarchar in SQL SERVER in Forms.
  • Fixed issue in "Master Detail" application view in mobile applications.

ScriptCase v9.0.015 2017-08-11 07:00

New functionalities

  • Added support to third digit in version increment of the projects.

Specific correction

  • Fixed issue in PDF export of query with group by and charts.
  • Fixed issue when using special characters "<" in automatic lookup of form applications.
  • Fixed problem in finding the page generated from the helpcase, using special characters.
  • Fixed issue in Multi upload fields using MSSQL Server Native SRV PDO and PDO_DBLIB driver.
  • Fixed PDF export issue in environments that only accept the https:// protocol.
  • Removed the fields with the data types: Date, Time, Timestamp, Clob, Blob, Bytea, Oid, Lo, Varbinary, Image and Xml of the Quick search interface.
  • Fixed issue in displaying button "OK" in the form of applications when the user dont have access to application. (Non-authorized user interface).
  • Fixed issue in updating disabled fields with N-N relation.
  • Fixed issue when saving Query filter in Double Select fields with Characters.
  • Fixed issue using quicksearch with% character in PostgreSQL connections.
  • Fixed issue in displaying the configuration images in the image manager. (It's necessary to clear the browser's cache.)

Performance improvement

  • Added protection to download links of the generated applications files.
  • Improved visualization of the macros documentation. (It's necessary to clear the browser's cache.)

Bug

  • Fixed issue while accessing the config.php file.
  • Fixed bug - invalid argument supplied foreach()-nm_gp_chart_hystogram.php 458 when configuring column-type chart in Girds.
  • Fixed Fatal Error : Uncaught Error: Call to undefined method proc_teste_cat_grid :: totaliza_php () in the execution of the applications of type procedure.
  • Fixed bug Invalid argument supplied for foreach () | Script: devel \ class \ page \ nmPageMenu.class.php line: 1862 when creating a procedure application.
  • Fixed issue using macro sc_error_message and sc_error_exit.
  • Fixed issue when using totals in virtual fields of a Grid.
  • Fixed issue in the display of the "Quantity of records" option in the graphic interface.

ScriptCase v9.0.014 2017-08-04 20:31

Specific correction

  • Fixed Fatal error: Uncaught Error: Call to undefined function nm_get_text_lang() when create or edit a connection in deployed project. ( Needs to update the production environment )

ScriptCase v9.0.013 2017-08-03 18:18

New functionalities

  • Added option to generate chart for windows in modal of export pdf. It will only be displayed if "Create Charts" is enabled at the .pdf export settings.

Specific correction

  • Fixed issue when running "OnHeader" and "OnFooter" events in the chart application.
  • Fixed issue displaying events, in the Javascript on forms.
  • Fixed issue in digit limit for maximum value of decimal fields.
  • Fixed an issue when using a global variable with name that starts with underscores, eg: [_var]
  • Fixed issue in spin input when typing more than one character in field settings at ReportPDF.
  • Fixed issue causing the interface to rename applications in 1366 x 768 resolution.
  • Fixed issue displaying To-Do list buttons when "Who can change" is empty.
  • Fixed issue when updating the "Image (filename)" field while set as mandatory.
  • Fixed issue displaying the image manager menu in 1366 x 768 resolution.
  • Fixed issue that duplicates fields used in AJAX processing.
  • Fixed issue when running ReportPDF when SQL is modified.
  • Fixed problem when using the sc_ajax_message macro. (Its necessary to clear the browser cache)
  • Fixed issue to update records when select field is disabled.

Performance improvement

  • Improved performance on Mac Installer. (It will be necessary to reinstall the environment)
  • Improved interface performance and scripts generation.

Bug

  • Fixed Parse error: syntax error, unexpected 'public' (T_PUBLIC) at form applications when using lookup in the fields.
  • Fixed issue when describing the fields group by in the summary using lookup settings.
  • Fixed issue in the date field display using the advanced filter when its set in the dimension.
  • Fixed issue in the static group by grouping in the grid.

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

New functionalities

  • Added support for chart application in helpcase.

Specific correction

  • 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

New functionalities

  • 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

Specific correction

  • 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

Specific correction

  • 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

New functionalities

  • Added the Helpcase button on the summary toolbar.

Specific correction

  • 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

New functionalities

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

Specific correction

  • 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.

Performance improvement

  • 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

Specific correction

  • 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 lang 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

Specific correction

  • 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

New functionalities

  • 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.

Specific correction

  • 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

Specific correction

  • 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)

Performance improvement

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

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

Specific correction

  • 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

New functionalities

  • 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.