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

New functionalities (UPGRADE 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.
  • For Chart applications where added new settings to export to formats: XLS, XML, CSV, RTF, WORD and image; 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.
  • 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.
  • New configurations options that allows, for example, to add buttons within the Advanced Search form body.
  • 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.
  • 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 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.