ScriptCase

What's new in this version:

ScriptCase 9.11.007
Fixed:
- "Undefined array key 'nm_sc_retorno_console'" error in PHP 8.1 environments
- problem with reloading the chart above the summary when the summary's own search was applied
- "2 = Undefined variable $php_fim_cmp" error when generating a grid application with "slide" orientation
- problem in column display on the grid interface
- problem with the signature field type when performing an update using an MSSQL Server database
- problem with record count display in the refined search when the field in question was generated from a subselect in the SQL of the grid


ScriptCase 9.11.006
Added:
- Added option to enable/disable horizontal subtotal in summary

Improved:
- Adjusted behavior when deleting saved filters in the filter builder's filter save window and the tag filter

Fixed:
- Fixed "Fatal error: Uncaught Error: Undefined constant PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT" when trying to connect to MySQL using SSL
- Fixed Undefined array key "tipo_nivel_ldap" error when accessing the security module interface in environments with PHP 8.1
- Fixed problem when copying and editing theme for Soft Cloud SM buttons
- Fixed problem with chart summary not displaying on mobile devices
- Fixed problem with signature field not working on mobile devices
- Fixed problem with "side by side" display mode not working in the button group in the grid, with buttons created by the user
- Fixed problem with displaying applications after opening multiple modals in the Edge browser. You will need to clear your browser cache
- Fixed problem viewing the calendar component in the form on mobile devices
- Fixed problem with checkbox type field when using manual lookup with multiple values option (binary)
- Fixed problem with security module login when using IPV6


ScriptCase 9.11.005
Added:
- Added "SameSite" option in the application security interface
- Added button to clear metadata cache for project connections
- SSL support has been added to DB2 connections

Fixed:
- problem when exporting a form containing an IOS radio type field, where all options were selected
- problem when using the HTML Editor field in the form to insert records containing accents and cedillas. Records in the table were saved in ASCII.
- problem with css of the Run button checkbox column in the grid
- misalignment problem in the grid field labels on mobile devices when the option to pin the top toolbar was enabled
- problem with the sc_changed macro not working correctly in file name type fields (image and document)
- problem with fields not being listed in the "Search settings in the All fields option" block in the quicksearch interface
- problem with the "Settings" button in the summary when it was assembled from a dynamic group by
- issue in the DB2 connection filter
- issue with table visualization in the Db2 ODBC connection


ScriptCase 9.11.004
Fixed:
- Fatal error: Uncaught TypeError: array_merge(): Argument #1 must be of type array when generating grids. The problem occurred when there was no button selected in the mobile toolbar in the summary.
- problem when using the sc_redir macro through an internal library, and calling the function in the onApplicationInit event in the grid application
- problem with reserved words in Sybase
- crash problem when creating the form using Postgres version 10.23
- problem creating the notification module with Mysql 5.6 version
- problem when executing the log module using the MariaDB connection. It is necessary to recreate the log module
- problem with generating the notification module. It will be necessary to recreate the module
- problem with displaying the "Log" item in the application interface menu
- problem in notification module when using password option in menu security


ScriptCase 9.11.003
Fixed:
- problem with the "Synchronize table" option in the form application
- problem when creating the notification module with the Oracle 11 version


ScriptCase 9.11.002
Improved:
- Improvement in the disconnect user screen that is displayed at login, adding insertion and update date columns for users logged in to the development environment
- Improvement in the online users screen, adding a button that allows active users to be disconnected from the development environment
- Added user disconnection events to the development environment log, both for voluntary and forced disconnections by other users

Fixed:
- Fixed error "2 = Undefined variable $seq_x" when generating grid source code in environments with PHP 8.1
- Fixed Undefined array key "tippy_js_fontawesome" error when generating the samples project in a version without an active upgrade
- Fixed Parse error: syntax error, unexpected token "<", when running a form with button group in side-by-side view
- Fixed problem with parameter passing in sc_ajax_message macro
- Fixed problem with connection parameter of sc_lookup_field macro not working
- Fixed problem with PDF generation in Debian 11 and 12 environments
- Fixed problem in the "modal" target of the HTML Image field link
- Fixed problem with menu notification when running with 'Allow call via URL' option unchecked
- Fixed problem retrieving the "TIMESTAMP WITH TIME ZONE" data type in the Oracle connection
- Fixed problem with persistence of old idle connections in the development environment
- Fixed problem that prevented users from disconnecting from the development environment when reaching the limit of simultaneous connections
- Fixed problem when creating applications using Firebird 2.5 version


ScriptCase 9.11.001
Added:
- Added validation to limit password recovery code submission attempts in the production environment. Starting from this version, after 5 failed attempts, the IP address will be blocked for 1 hour.
- Production environment update required

Fixed:
- Fixed Fatal error: Uncaught TypeError: PDOStatement::execute() when saving an image to an image-type field in an Oracle PDO connection
- Fixed problem with alignment of items with sub-items in the old menu
- Fixed problem where the form was not updating when the dynamic search was enabled in the application
- Fixed problem with an empty space above the grid header title when there was a link between the grid and the form
- Fixed problem with grid freezing with total pagination when applying the refined search
- Fixed problem in the deployment templates where they were being duplicated with each deploy
- Fixed problem with the incorrect display of the filter builder line/dynamic applied in the form application


ScriptCase 9.11.000
Added:
- Notifications Module that enables real-time notifications integrated with Security Module
- SC_SEND_NOTIFICATION Macro with dynamic parameters for personalized notifications integrated with the Notification Module
- Filter Builder for dynamic, nested filter creation
- Notifications in the Responsive Menu to show notifications directly in the responsive menu
- Responsive Menu Theme Editor for customization of responsive menu appearance
- option to customize Menu font-family
- Tippy.js in Field Help to include interactive tooltips in form fields
- Tippy.js Theme Editor for custom tooltip design with Tippy.js
- "Minimum time" and "Maximum time" options in the time type field
- regular expression options in text fields for data validation
- option that allows you to disable browser autocomplete for fields with data entry
- tooltip with TippyJS for grid field labels


ScriptCase 9.10.023
Fixed:
- calling the "sc_reset_menu_disable" macro in the menu application event macro list
- "Invalid data" error when trying to create a new record from the Grid, when the Form had a "-" (hyphen) in the application name
- error "Duplicate entry 'samples-conn_example' for key 'PRIMARY'" when importing example projects with MySQL connection
- Undefined array key "extension" error when generating the Helpcase
- errors in generating the source code of some applications from the "Training" example project
- problem when accessing the creation/editing of the log module in environments with PHP 7.3
- problem when clicking on the block inclusion label unchecking other checkboxes
- problem when using virtual field in Gantt chart configuration
- problem with the option to close form after insertion, in link properties, which did not close the responsive menu tab
- problem with loss of value in a disabled field when trying to delete records in applications that have dependencies
- problem in Excel export file line with outdated PHP code
- problem in file line using outdated PHP code when sending email
- problem when passing parameters in "Open the application in a tab within the menu"
- problem in viewing the export buttons in the grid, when the application name had the hyphen (-) symbol
- problem with the "Change all theme fonts" button in Layout->Application Themes
- problem with double clicking on the double select field, after updating browsers
- problem using the "sc_mail_send" macro in Linux and MacOS installer environments


ScriptCase 9.10.022
Fixed:
- problem with retrieving the primary key field in the form application events, using the MySQL connection
- problem with the "Return after Inclusion" option in the form application, using the MySQL connection
- problem with searching for the generated helpcase
- problem with sorting the applications report in the project interface
- problem with including the link on the helpcase page
- problem with the data dictionary which continued to be displayed when creating an application after being deleted
- the display of the manual lookup profile after creation
- problem when using the bold option on even and odd rows of the filter label when editing the application theme
- problem with the header of the editable grid view form when there are more than two blocks opening in a tab
- problem with the "modal" and "_blank" targets in the "HTML Image" field link in the form application
- JavaScript errors in the CSS interface of the menu and helpcase
- problem when copying the scriptcase9_SoftCloud and scriptcase9_SoftCloud_Sm buttons. The error "Trying to access array offset on value of type null" was generated
- problem when applying breaks in the Grid with fields whose names were reserved SQL words
- problem when generating an application whose name starts with number


ScriptCase 9.10.021
Added:
- Added new connection to MariaDB

Improved:
- Visual improvement in the log module interface

Fixed:
- Fixed Fatal error: Uncaught Error: Attempt to assign property "Sc_groupby_data" when generating the Excel export in the summary
- Fixed problem when defining field text alignment in a grid application, with vertical or slide orientation, and configured for "Defined by field" alignment
- Fixed problem when inserting images into HelpCase using Scriptcase's native image manager
- Fixed problem when correctly returning records when searching in advanced, dynamic and quicksearch filters using the "_" character (underscore)
- Fixed problem with visualizing languages when selected in the project properties


ScriptCase 9.10.020
Improved:
- Project diagram layout improvements

Fixed:
- problem with redirect options after inserting and updating form binding properties
- problem with datetime2 type field using DBLIB driver
- problem with duplicate scrolling in PDF report PDF layout settings
- problem with modal not closing after inserting and updating records in a grid link with the form
- problem with custom messages not working after inserting, updating and deleting, in the form application
- problem with the option to exit the application in the form after insertion
- problem with the option to close the form after inserting/updating opened in modal
- problem with messages after inserting in the form
- problem with the interface when creating a new API
- problem with displaying summary total numbers in dynamic break when using the onGroupByAll event
- Fatal error: Uncaught ArgumentCountError: Too few arguments to function nm_db_fields_uk_access, when importing the Access file
- problem with the configuration of the manual type lookup in the summary filter. The data was not saved in the interface


ScriptCase 9.10.019
Fixed:
- problem when saving records with the date field marked as required.
- problem with disabled fields being changed in Ajax event
- blank screen problem or "Trying to access array offset on value of type null" error when displaying diagram
- problem with graph visualization when using the fixed menu tab
- problem in aligning the totalization of the grid, which is a nested grid
- problem with the layout of form blocks in some themes, when the "sc_field_display" macro was applied to hide fields


ScriptCase 9.10.018
Added:
- Added "Reload" option within the context menu of the Responsive Menu application tabs
- Added reload spin to Responsive Menu application tabs
- Added support for wkhtmltopdf on Debian 11 and 12 based Linux operating systems

Improved:
- Visual improvement in the log screen for the "Version increment" resource
- Updated the versions of the Linux installer
- Libpq(PostgreSQL): 16.2
- CURL: 8.7.1
- OpenSSL: 1.1.1w
- ZLib: 1.3.1 LibSSH2: 1.11.0
- Improvement in the layout and usability of the ER Diagram

Fixed:
- Fixed problem when accessing production applications with the ODBC driver from the MS SQL Server connection. The "Port" field for connecting to this driver has been removed from this version.
- Need to update the production environment
- Fixed problem with attribute values not being recognized at lookup a field
- Fixed problem when editing the user in the security module. Due to the browsers' password saving feature, when editing the user, the password was stored in decrypted form.
- Fixed problem in viewing uniqueidentifier data in Scriptcases installed in Linux environments


ScriptCase 9.10.017
Added:
- Added support for sc_label macro in ajax events of the editable grid form (view), configured for editing or inclusion in a modal

Improved:
- Updated the versions of the Linux installer
- PHP: 8.1.28
- Apache: 2.4.59
- Ldap: 20517
- OpenSSL: 1.1.1k
- Layout adjustments in the database selection on the connection interface.

Fixed:
- problem when using the sc_redir macro through a library and calling it through a method in the onApplicationInit or onLoad events of the menu application
- problem of sc_vl_extenso macro not working with numbers and values in the billion range.(Production environment update required)
- error displayed when converting Excel database to a new database whose connection was created during the conversion process
- problem using Western - CP1252 charset when using the sc_appmenu_add_item macro passing a string through a variable and adding it to the label parameter
- problem of events not being displayed when printing by day in the calendar application
- problem of button style loss in some themes when applying the sc_btn_display macro to enable the button
- problem in editing record in the editable grid form (view), using modal, after canceling a new record
- problem in editing user to enable the administrator privilege option in the user security module
- problem of not interpreting template string in JavaScript
- problem of "Access initial application" button not working on mobile devices. It is necessary to republish the initial application
- problem with the value of the "Port" field in production environment connections, when the MySQL connection was selected first


ScriptCase 9.10.016
Fixed:
- problem with loss of form layout style after performing actions on the form itself
- problem with option to disable field (insert/update) in date and decimal type fields


ScriptCase 9.10.015
Improved:
- Improvement in the color-picker of Scriptcase applications

Fixed:
- Fixed error "incorrect user/password" when attempting to login to the "Album" example project with Postgres connection
- Fixed error Undefined array key "prop" when synchronizing applications in the data dictionary in environments with PHP 8.1
- Fixed problem in the lookup of auto-complete fields (text and number) in multiple record forms, containing two or more fields of the same types
- Fixed problem with the "Exit application" option in the Form navigation configuration
- Fixed problem with loss of button style in some themes, when applying the sc_btn_display macro to enable the button
- Fixed problem with custom theme display in the grid when performing v6~v9 Conversion
- Fixed problem in assembling the Query SQL when using the "SQL_NO_CACHE" function
- Fixed problem with the grid header not being displayed on mobile devices, when the grid is a detail of a multi step form
- Fixed problem with disabled fields on the form during insertion and update events. By inspecting the element and removing the "disabled" attribute, it was possible to add a new value.
- Fixed error when converting Excel database to MySQL connection


ScriptCase 9.10.014
Fixed:
- Undefined array key "display_position" error when generating form
- invalid data problem when having more than one connection in the nested grid, configured to display in the iframe
- problem in viewing details in the grid, configured to display below
- problem in viewing the chart filter in the interface
- problem with parameters not being deleted in application methods in the Italian language interface
- problem when using group labels in grid applications with action buttons


ScriptCase 9.10.013
Added:
- Added support for local variables in the macro sc_field_style. Support is valid only for style parameters.
- Added feature to export images separately, in a Zip file, in Word document export in the grid

Fixed:
- Fixed problem with correct recognition of field type in the interface of applications, for IMAGE type columns in Sybase connections
- Fixed problem when inserting images in Sybase connections (in IMAGE type column), in image fields (database) in the form application
- Fixed problem with updating the editable grid view form opened in modal


ScriptCase 9.10.012
Fixed:
- error 2 = Undefined array key "display" when generating source code for Control type applications in environments with PHP 8.1
- error Column 'usa_seguranca' specified twice when creating the blank application
- error in the time display format in calendar events, when the time was between 12:00PM and 12:59PM
- error Undefined array key "subst_campo", when accessing SQL in the grid in environments with PHP 8.1
- problem with data display with double select field being reloaded via ajax processing
- problem with displaying removed fields on the "Edit Fields" screen in the form application
- problem with the date not being displayed in the standard format in the Filter application footer, when no format was entered
- problem with the Form not working when defining a lang with double quotes in the label of a field
- problem with Sybase PDO ODBC connection
- problem viewing the "select2" field in the steps form
- problem viewing the open form in modal on mobile devices
- problem with viewing the fixed label in the summary, when switching between static and dynamic group by, and when navigating
- problem with the alignment of the lower toolbar, when enabling option "Pin lower toolbar" in the grid
- problem with the behavior of the summary "Reload" button


ScriptCase 9.10.011
Added:
- SSL support for secure connections in PostgreSQL connection
- option "Apply date limits to calendar" in the "date" type field in the form application
- new feature "Remove background color/image" in master detail link properties in form application

Improved:
- Visual improvement in the image manager interface

Fixed:
- "Parse error: syntax error, unexpected token < " in the Form application, when adding the backslash () as an allowed character
- "Fatal error: Uncaught ArgumentCountError: Too few arguments to function." when clicking the advance to the end button in a grid dynamic group by displayed after the records
- error "2 = Undefined array key 1" when generating the grid source code in environments with PHP 8.1
- problem with displaying the name of the month in the calendar on mobile
- Parse error: syntax error, unexpected token ";" in XLS export
- problem with data visualization in XLS export in the summary
- problem with improper display of the "Exit" button in forms linked to the grid, after conversion to version 9 of Scriptcase
- Undefined array key "charset" error that was displayed after losing a session
- TCPDF ERROR: [Image] Unable to get the size of the image when generating images in the ReportPDF application
- "Records not found" problem when reloading the summary, when dynamic group by fields were only selected at run time
- problem with the link type action button not working when set to open in an Iframe
- problem with summary header not displaying in PDF export
- problem with display of graph application buttons in the grid summary toolbar
- PHP Fatal error: Uncaught ValueError: mb_convert_encoding(): Argument #3 ($from_encoding) contains invalid encoding “undefined”, in the application creation interface
- problem in displaying the grid's dynamic group by layout when not using the "Support for multiple items" feature
- error when recovering password via email in the security module, when informing a user that does not exist
- problem with the SYBASE PDO connection in the Windows environment
- problem when using secondary connection in the lookup fields, in connections with SSL support
- the production environment interface for connections with SSL support


ScriptCase 9.10.010
Added:
- feature to select and drag multiple items on grid application toolbar buttons
- new themes: Softcloud and Softcloud Small
- options to define header and footer templates in advanced theme mode
- option to configure input hover in advanced theme mode
- feature for customizing the message displayed for required fields in the form and filter
- new directory with project images in the image manager
- support for unique key recognition when creating the form application automatically, in the Db2 connection
- support for recognizing the DATA data type as NOT NULL when creating the form application automatically, in the Db2 connection. The interface will mark the required field

Improved:
- Adjustments to the list of Db2 connection drivers
- Changed the Firebird extension to version 4.0 in the Linux installer

Fixed:
- problem when performing a search in quicksearch when a field that had a lookup did not have ORDER BY in its SQL statement
- problem with displaying a required field message when canceling an action on the form
- problem when executing the sc_exec_sql macro after performing a search in quicksearch with the option to highlight results activated
- problem with including values in the image and database document fields in the Db2 connection
- problem when manually installing Scriptcase using the MySQLi driver
- problem downloading files from the database document field in the Mssql Server connection
- problem with incorrect display of vertical scroll bar in connection widgets in Dashboard application
- problem using the slide field in the summary filter
- problem downloading files from the Multi-Upload field in the Native SRV PDO Mssql Server driver
- problem with key fields marked as required in the Form application not being critical
- problem in displaying group by values when using totalization variables in events
- problem when using the sc_redir macro in the onload event in the menu application
- problem when displaying summary data using dynamic wrapping
- problem when saving label position definition in filter application blocks and grid advanced filter
- error of Undefined array key "tot_res_criar_grafico" in the grid, in the PHP 8.1 environment
- Fatal error: Uncaught Error: Cannot use a scalar value as an array in the chart application, when using group by in the SQL command


ScriptCase 9.10.009
Fixed:
- problem in record insertion when using automatic auto-increment with sequence in MariaDB connections
- problem with case-sensitive sorting in break fields
- problem with sorting for display in break fields with lookup
- problem when selecting records in refined search after performing an advanced search in a query application with Firebird connection
- problem with sorting special conditions in date-type field filters in grid applications


ScriptCase 9.10.008
Fixed:
- problem in the configuration of the columns option when using grouped fields
- field auto-completion problem when associating tables when creating a security module with Oracle, SQL Server and Postgres connections
- problem with the "Close form after updating or adding" options and editing link. The form was not being closed
- problem with the date field being changed to varchar, when a grid has a special SELECT (INNER JOIN, SUBSELECT, etc.) in Firebird
- problem in displaying sorting rules, when in advanced sorting we chose the "Define fields manually" option
- error "Invalid default value for 'mfa_last_updated'" when creating a security module


ScriptCase 9.10.006
Added:
- a feature to set the validity period in days for a session, performed via Two-Factor Authentication (2FA), in the new security module
- a counter for the expiration time of the two-factor authentication code in the security module

Fixed:
- problem when disabling the "Code expiration time" feature in Two-Factor Authentication (2FA), in the security module, by setting its value to zero
- problem when using the Clickatell API and the sc_send_sms macro in Linux environments
- problem with the page scrolling in the user editing modal of the group/users application in the new security module
- problem of not displaying the options for the "Relative Period" component of the "Date" field in the summary filter
- "Parse error: Unmatched '}' in" when running a Form application
- error "The file was not generated with Scriptcase version 9" when importing an application. It was necessary to import the application again for proper functioning
- errors "2 = Undefined array key 180" and "2 = Trying to access array offset on value of type null" when generating a Query application in environments with PHP 8.1
- error when searching in the quick search of the group/users application in the security module
- error when importing a project from the "Project -> Export Project" option
- problem in the interface of the Query blocks after converting a project from version 8 to 9
- problem when generating PDF directly without respecting Query export modules
- problem with the operation of the sc_redir macro in the onAplicationInit event of the new menu
- problem in the Query when the option to generate Excel directly is activated. Clicking the back button was regenerating the xls
- problem with the sc_format_num macro in the onRecord event, along with the sc_format_num_region macro
- error "[object Object]" displayed in the interface after editing fields in "Edit Fields" of the form application
- problem with the responsive menu with vertical orientation in Arabic language on mobile devices
- problem with locking when trying to edit the theme for the "Flat Blue" button


ScriptCase 9.10.005
- Change log not available for this version


ScriptCase 9.10.004
Added:
- Added behavior option when navigating in the steps form. Option available in Layout > Pages > Steps Configuration
- Added support for the "sc_btn_disabled" macro in created buttons

Fixed:
- Fixed problem when opening items with subitems in the Tree Menu application (Production environment update required)
- Fixed problem in the menu toolbar when redirecting to an application with the hide menu option enabled
- Fixed problem of non-persistence of state when changing the charset in the project's connection interface
- Fixed problem of application not reloading in the tree menu from the second click on items with the "Open items in tabs" option disabled
- Fixed problem in the configuration of the Google Drive API in the production environment
- Fixed problem in the listing of auto-increment values in key fields in the Oracle connection
- Fixed problem in editing iframe properties in the link between applications
- Fixed "Fatal error: Uncaught Error: Cannot use a scalar value as an array" when running a query in environments with PHP 8.1


ScriptCase 9.10.003
- Added option to start expanded menu, in menu settings, when menu layout is vertical
- Added special condition "Existing years in the database" in the "Date comparison" field in the grid search

Fixed:
- Fixed "Fatal error: Uncaught Error: Call to undefined method application_name_grafico::load_chart_theme()" when accessing chart in Summary, when the chart module was disabled in "Grid modules"
- Fixed error 2 = Undefined array key "other" when generating grid application in environments with PHP 8.1
- Fixed error Undefined array key "extension", when editing a Control application in environments with PHP 8.1
- Fixed Fatal error: Uncaught TypeError: Cannot access offset of type string on string when starting from the summary module
- Fixed Fatal error: Uncaught TypeError: count(): Argument #1 ($value) in grid menu interface
- Fixed Fatal error: Uncaught TypeError: in_array(): Argument #2 ($haystack) must be of type array, null given in the dynamic group by of the grid
- Fixed problem when renaming responsive menu application
- Fixed problem with the average value in tables with few records
- Fixed problem with ordering icons not being displayed in Summary totalization fields when the grid had a JOIN
- Fixed problem when searching for items in the dynamic responsive menu
- Fixed problem with viewing the calendar icon in the date field with the "new calendar" option activated
- Fixed problem in the calendar view when using the sc_field_disabled macro in ajax events
- Fixed problem with menu display when using a large number of sub-items
- Fixed problem with downloading multi-upload files over the Postgres connection
- Fixed problem with linking dynamic responsive menu items when the sc_redir macro is called in an event


ScriptCase 9.10.002
Added:
- horizontal scrollbar in language interface
- support for creating a lang index containing numbers
- support for Sonoma (14.2) version of MacOs

Fixed:
- "Fatal error: Uncaught Error: Object of class application_name_ini could not be converted to string", when defining a lang in the label of a button with "Link" display mode
- error "Attention Undefined index: iframe", when the target "_self" was passed in the sc_appmenu_add_item macro in the new menu in environments with PHP 7.3
- undefined array key "arquivo3" error when generating the dashboard application
- undefined array key "filial" error in the grid application with the PHP 8.1 environment
- undefined array key 0 error in a grid application with the PHP 8.1 environment
- problem when using the security module configuration application in Spanish
- field label display problem when capturing a field of the "Field grouping" type
- problem with the "Display percentage" option in the Summary fields interface in old applications
- problem visualizing the exit button in the summary


ScriptCase 9.10.000
Added:
Added new 100% responsive and fluid menu application with:
- New toolbar
- Item search
- Shortcuts
- Dynamic language and theme switch
- User menu integrated into the security module
- Added a new date range comparison field in the search with a new calendar component for selection
- Added a comparative chart between dates on the summary page
- Added the option for percentage in relation to the total in the Summary
- Added pagination in the summary
- Added an option for the positioning of the overall total in the summary

Added a new security module 100% configurable by the end system user, generated with:
- New interface in the development environment
- Access mode through login, email, or both
- New option to define user creation rules
- New option for optional use of authentication (2FA)
- Last password change

Improved:
- Improved performance in the summary


ScriptCase 9.9.024
Fixed:
- problem when creating special conditions for the date field in the search
- "Undefined array key image_path" error in application layout after project conversion from Scriptcase version 8 to 9
- problem with the "Break" and "Configurable graph" buttons not being displayed in the query summary toolbar
- problem with creating an extra directory when generating the publication ZIP in a Windows environment
- problem when using JavaScript method passing parameters
- "Undefined array key backgroundColor" error when creating a new item in the "My toolbar" resource


ScriptCase 9.9.023
Fixed:
- "Warning: Undefined property: stdClass::$orgtable" error when executing a SQL command in the Database Builder within the SQLite connection
- problem displaying inputs and confirming log module creation
- problem displaying the results of commands executed in SQLbuilder
- problem importing projects and applications into Scriptcase


ScriptCase 9.9.022
- Fixed "Not Found" error when generating zip file in deploying and exporting applications and projects


ScriptCase 9.9.021
Added:
- Added possibility to change documentation display in the Scriptcase interface: Online and Offline
- Added possibility to change documentation language in the Interface: English and Spanish
- Added new parameters to encrypted connection in SQL Server

Fixed:
- Fixed "Fatal error: Uncaught TypeError: Unsupported operand types: string + int" in the application interface menu
- Fixed trim() error: Passing null to parameter #1 ($string), in the grid application generated by the log module, using the Informix connection
- Fixed problem saving options configured in the connection security tab, after project creation
- Fixed problem with using 0 (zero) in the "Complete left" option in the Form text field


ScriptCase 9.9.020
Improved:
- Adjustments to the interface for editing form application fields. From this release onwards, the insertion and update columns for fields that are not selected in the application will be disabled.

Fixed:
- problem when using application synchronization in the security module with access connection
- problem with displaying date and time fields in the calendar field listing
- problem with deleting the master detail on mobile. A Fatal error was generated: require_once(): Failed opening required.
- problem when creating the form application, using the mandatory field settings in the data dictionary. Required field configuration was not being reflected upon creation or sync.
- problem in generating langs in the data dictionary, when there were quotation marks in the field name
- Fatal error: Uncaught TypeError: Unsupported operand types: string * int in calculations in fields of type "data", in the PHP 8.1 environment
- problem translating the calendar in the date field in the filter into other languages
- problem with button alignment configuration in the HTML editor


ScriptCase 9.9.019
Added:
- Added search feature in the management and positioning of fields in the applications interface
- Added sc_field_no_validate macro for form, control and calendar applications
- Added "Display field error in a modal" option in express editing
- Added support for wkhtmltopdf on Linux operating systems based on RedHat 9

Improved:
- Improved interface and usability in the production environment download via zip and tar.gz generation in advanced publishing
- Visual improvement of management and positioning of fields in the applications interface

Fixed:
- Fixed problem when using "disable field" option or "sc_field_disabled" macro in "select" type field with capture link. The link icon next to the field was not being hidden.
- Fixed problem when creating the grid, when adding a WHERE clause in the SQL with the option to create the form for editing enabled
- Fixed problem when creating a grid, when unchecking some fields in the "edit fields" tab, if the option to create a form to edit the grid was enabled
- Fixed problem in validating the control application, when pressing the "Enter" key on the keyboard
- Fixed "Fatal error: Uncaught TypeError: trim(): Argument #1 ($string) must be of type string" in N:N relationship, after reloading the form from a field of type Select
- Fixed error "Incompatible data type in the criterion expression.", when performing an advanced filter with a field of type DATETIME in Access
- Fixed "Undefined array key grid_break_fixa" error when individually applying the "Fixed breaks" option in express editing
- Fixed Fatal error: Uncaught com_exception when importing Access base
- Fixed Fatal error: Uncaught Error: Call to undefined method Swift_Mailer::disconnect(), when clicking "Forgot your password?" on the Scriptcase login screen
- Fixed error when generating production environment via zip or tar.gz in advanced publishing
- Fixed problem when recovering password through a link in the security module. For those who already have the security module, please check our tutorial to adjust the application.
- Fixed a problem with fields not being displayed in the Form's SQL configuration, after some change was made in the option to define primary keys
- Fixed problem displaying calendar in advanced filter label after grid search
- Fixed a problem in the macro "sc_field_disabled" when using it in the data field with the false parameter. The calendar icon next to the field was displayed twice.
- Fixed problem in master detail view on mobile


ScriptCase 9.9.018
Improved:
- Visual improvement in the application creation interface

Fixed:
- Fixed Fatal error: Uncaught TypeError: trim(): Argument #1 ($string) in subselect field with image in Report Pdf application with PostgreSQL connection
- Fixed problem when configuring an initial application in the menu application
- Fixed problem in validating fields in the creation interface of the calendar application
- Fixed problem when uploading files in the "app_data" directory when deploying. From this version on, it will only send files referring to deployed applications


ScriptCase 9.9.017
Added:
- Added support for global variable in the label of grid buttons
- Added sorting option for SQL in the grid

Fixed:
- error "Undefined array key" vert_campos"
- problem with alignment of title in multi-record form
- problem with linking HTML image field in control application when using the "open in another tab" property in link operation mode
- problem with display of FusionCharts Trial version message in manual calls to the library
- problem with visual with converted project buttons
- problem with the functionality of the sc_apl_default macro
- problem when opening the project with the "Save metadata cache to disk" option enabled, if the MSSQL Server extension module was disabled. Scriptcase redirected to login
- problem with background color in WORD export
- errors "Undefined array key" vert_campos", "sem_tag_php", and array key "sc_field_0" in PHP 8.1 environment
- problem with executing SQL command using sc_exec_sql macro in onValidate event with Oracle connection
- problem with the display of end time in week or day calendar application
- problem with line break in the display of week or day calendar application
- problem with layout with calendar application buttons on mobile
- fatal error count() when using validation {sc_mail_ok} in blank
- errors in the browser console in calendar application
- problem when deploying applications unchecking common files
- error 2 = Undefined array key when generating procedures in SQL Server


ScriptCase 9.9.016
Added:
- Added width option in option use checkbox in dropdown in filter select
- Added criticism when trying to create an application with its name starting with a number

Improved:
Improvements in the first access screen of the production environment:
- added CAPTCHA and removed default password splash screen
- Removed sc_pub_(date_time) directory from ZIP file generation on publication

Fixed:
- Fixed error "2=Undefined array key 0", when generating source code of grid applications in environments with PHP 8.1
- Fixed count() error: Parameter must be an array or an object that implements Countable - nmPageServRestore2.class.php line: 116, on project import
- Fixed display error for the "window.open" method when selecting the "Toolbar buttons" option in express edition
- Fixed error foreach() argument must be of type array|object, null given | nmRestoreGroups.class.php line: 71 on project import
- Fixed error Undefined array key "dbms", when empty was selected in field "Connection" when creating a new application
- Fixed errors Undefined array key "entries" and Trying to access array offset on value of type null", when creating a Procedure application
- Fixed Fatal error: Uncaught TypeError: count(): Argument #1 ($value) on project import
- Fixed Parse error: syntax error, unexpected identifier "_grid_saveFixedColumnsGrid", when defining the initial of the grid name with a number or dash
- Fixed problem when importing saved SQL statements in SQL Builder
- Fixed problem when inserting record with line break in form with multiline text field
- Fixed problem when listing pending connections in advanced publishing
- Fixed problem with calendar events not being displayed after insertion
- Fixed problem with the application's modal not being closed when the source application was a menu
- Fixed problem with the ZIP file not being removed when an SFTP publication was performed with just common files
- Fixed crash problem when generating the Excel file of the Procedure application
- Fixed problem with project creation on the project theme selection screen. No theme was being set as default.
- Fixed problem in the formation of "data" type fields, when using the "definition of fields that will be displayed in the break" option
- Fixed problem when passing a parameter to the chart application's SQL
- Fixed problem in the synchronization of applications in the security module. For those who already have the security module, please check our tutorial to adjust the application.
- Fixed a problem when viewing a newly created table when creating an application with an Oracle connection
- Fixed problem in the look of the calendar buttons


ScriptCase 9.9.015
- Added new macro sc_lookup_field

Added:
- support for Column Selection and Linking between applications in grid with vertical orientation
- support for password recovery, with SMTP configuration, in production environment
- option in deployment to generate page containing a link to the initial application
- support for Column Selection and Linking between applications in grid with vertical orientation
- support for password recovery, with SMTP configuration, in production environment
- option in deployment to generate page containing a link to the initial application

Fixed:
- Improved opening mode for downloading files from the "Document (File Name)" data type
- Removed the info and diagnosis files from the site's deployment file
- Improvement in the production environment interface
- Improvement in the Scriptcase libraries

Improved:
- Improved Scriptcase libraries

Fixed:
- problems displaying charts in applications from the Documents Library sample project
- problem with date field format during ajax processing
- problem when viewing blocks in a tab in the modal window of the editable grid form
- problem in viewing the description in the lookup of numeric and zip code fields in the form
- problem with calculator visualization on mobile devices when in form fields with horizontal orientation (multiple records and editable grids)
- problem using confirmation message on action buttons
- problem when saving API edition in deployment environment
- a problem when reloading the grid page when configuring the details below
- problem when generating the diagnosis in the development environment
- problem displaying font color on selected tab in form application
- problem with Ajax-type action buttons in environments with PHP 8.1, when created after the first execution of the grid application
- problem with the upload modal crashing in the image manager, after uploading the image
- problem with returning to the login screen after accessing a project that contains an Oracle and SQL Server connection in Linux and macOS environments
- problem with the sc_btn_disabled macro not working in the Form application
- a problem with the connection to the database not being displayed in the interface, when opening and saving it
- problem with the label not being aligned in the summation of the summary
- problem with display when clicking on the calendar icon in a date and time type field in form applications
- problem when using the calendar of the "date" field in modal in the search application. This type of view is available when the "New Calendar" option in the "date" field settings is unchecked
- problem when using the SQL_NO_CACHE function in the grid's SQL
- problem when using sc_change_css() macro in field with "." (point)
- error Undefined array key "t_text" when accessing the "Field Positioning" option of the Form in environments with PHP 8.1
- error Undefined array key "lang_subject_mail", when accessing project messages interface in environments with PHP 8.1
- error Connection attempt failed: SQLSTATE[42704]: Undefined object: 7 ERROR: unrecognized configuration parameter "bytea_output", when trying to connect to PostgreSQL on Amazon RDS
- error when using the "Grand total" option in the chart application
- error Undefined array key "lang_subject_mail", when accessing project messages interface in environments with PHP 8.1
- error Connection attempt failed: SQLSTATE[42704]: Undefined object: 7 ERROR: unrecognized configuration parameter "bytea_output", when trying to connect to PostgreSQL on Amazon RDS
- error when using the "Grand total" option in the chart application


ScriptCase 9.9.014
- Added option to view the diagnosis in the production environment. We recommend deleting the info and diagnosis files in the production environment.
- Fixed tab bar and refresh button when scrolling, in project default values interface

Fixed:
- error when using the "Grand total" option in the chart application
- error Undefined array key "b_bor_collapse", when editing blocks through advanced filter
- issue with SQLITE database access in Database Builder
- problem with not changing the language of the applications, when defining another default language for the project
- problem converting projects from version 8 to version 9
- a problem when creating a calendar, using the option to create a table
- a problem in retrieving "data" type fields using the "sc_lookup" and "sc_select" macros in the Native SRV driver of the SQL SERVER connection
- problem in viewing themes in the viewing interface, in licenses with expired upgrades
- problem in using procedures with rollback in environments with DBLIB driver
- problem with numeric fields in advanced filter when changing regional setting


ScriptCase 9.9.013
Added:
- Added option to reload tables and fields in field lookup
- Added option to reload tables and fields in Dashboard index

Improved:
- Usability improvement in the fields initial values of dynamic group by

Fixed:
- problem displaying errors on the console when performing a restore
- a problem with the display of sorting icons in the Summary PDF
- problem displaying fields in the grid search tag in the mobile version
- problem with data display when configuring group by month and year in the grid
- problem with macro sc_vl_extenso() with application language in english


ScriptCase 9.9.012
Added:
- Added headers security options on unauthorized user pages and use password on generated applications.
- Added headers options in security module applications. The options will be included when creating a new security module from this release.
- Note: For the security module already created, just use the express edition to configure the security headers in the applications. For more information about security headers, please access our documentation.

Fixed:
- Fixed problem with confirmation button on delete file screen in internal library


ScriptCase 9.9.011
- WhatsApp API (ChatApi) removed due to being discontinued

Fixed:
- problem exporting PDF via email: strtolower(): Passing null to parameter
- problem when performing search in dynamic filter and quicksearch
- "Invalid argument supplied for foreach()" error when generating data dictionary in PostgreSQL connection
- problem in viewing the list of projects after displaying the outdated version message
- problem in the action bar color editor when setting a color and not displaying correctly
- Undefined array key "t_name" error when accessing label type field settings
- problem with alignment of ordering icons in vertical grid
- problem when saving the "Hint" option in the properties of a "field" link
- state non-persistence issue when updating "Date display position" and "Display date format" options in the default values interface
- problem with quicksearch and navigation buttons not being displayed in the "form_sec_users_apps" application in the security modules per application and LDAP with full control
- error of Undefined array key "cod_grp" when performing a manual installation using the Mysql database
- problem with mobile resource definition loss in the Scriptcase interface after importing projects
- Undefined array key "css_btn_list_new" error when accessing the "Themes for buttons" option
- problem with the shortcut key for the new button in the edit link, if the option to use shortcut keys is activated


ScriptCase 9.9.010
- Added new option to compress files before sending in SFTP publishing

Fixed:
- problem with button group option in action bar when loading grid quicksearch
- error with array key "nm_lang_locale" in "Subselect" field configuration in ReportPdf application on PHP 8.1 environment
- error 2 = Undefined array key "display_position" in grid application
- problem with displaying the "check" icon in the grid "Run" button. The icon was being shown 2x
- problem with viewing the "check" icon on the action bar button. The icon was being displayed 2x
- problem displaying the "check" icon on buttons being called through the display macros in the menu application. The icon was being displayed 2x
- problem with executing the Ajax button created from the action button when using the macro "sc_link" in the Onrecord event of the grid. The button code was not being executed
- problem of not styling the group label in nested grids
- menu creation problem in PHP 7.0 and 7.3 environments
- problem when viewing new tables in the data dictionary when the "save metadata cache to disk" option is enabled
- problem in express creation when checking the option to generate source code
- error when saving change in group by fields
- "Fatal error: Uncaught Error: Call to a member function getColumnMeta()" when using the macro sc_select() in a PHP method called by a field of type HTML Image with Ajax event
- "access array offset" error when creating security module
- problem when closing grid with filter in a capture link


ScriptCase 9.9.009
Added:
- option to display chart configuration of grid fields as an icon or keep the buttons
- visual customization of grid field titles
- fixed toolbar in grid
- aggregation of rating fields in summary
- display of rating fields in grid group by
- field grouping option in the grid
- confirmation message option in the visual configuration of the button in the action bar
- button grouping option in action bar
- button option in button visual setting in action bar
- label configuration option in action bar column

Improved:
- performance in the creation of applications, using the Oracle connection
- visual when creating a new langs folder
- connection performance
- Note: If the new version is updated manually, it will be necessary to apply the permissions in the Scriptcase directory.
- internal library interface
- visual in the notification of saving changes in the interface

Fixed:
- problem when editing the application when the auto save option was activated
- problem when synchronizing the form with the option to save metadata cache on disk enabled
- Undefined array key "mysql_ssl_cipher" error in MySQL connection when using SSL in PHP 8.1 environments
- SQL errors during source code generation of example CRM project with Firebird database
- SQL errors when generating the Documents Library project source code, with PostgreSQL and SQLite databases
- issue with Excel export crashing in the grid, due to the formatting of "percent" type fields
- an error that failed to compile in applications that had a friendly URL, at the end of the publication generation done through the "Publish" button at the end of the source code generation
- problem in Healthcare Project created with SQLIte database
- a problem when creating applications in the Access type connection, when using a table column with the reserved word "MOD"
- problem when creating the form, using the "Foreign key optimization" option and the MySQLi connection
- problem in the "Value range" option for numeric values in the summary filter. The typing component was not created
- problem when selecting ODBC connection in SQL Server, Oracle, Db2 and Sybase connections. The connection driver was not being listed
- problem when importing example projects using MySQL connection
- Fatal error: Uncaught Error: Undefined constant "SCEOT" in the modal of WORD and RTF exports in the chart applications
- "Undefined array key" and "Trying to access array offset on value of type null" errors when accessing some options for editing application themes
- errors of Undefined array key "summary_export_xml_pwd_pwd" and "label_watermarked" in grid application, when using PHP 8.1 environment
- error "foreach() argument must be of type array|object, null given", which occurred when creating Generic ODBC connections
- "Uncaught Error: Call to undefined function sc_logged()" error, which occurred when trying to login with 2-factor authentication using the email API
- SQL errors when generating the source code of the Onlineshop sample project with a MySQL database
- problem with not displaying the rating field icons (star, smile and thumbs), when printing the Grid and the Summary
- Undefined array key "display" error, which occurred after saving some application themes at the public level
- error of Undefined array key "display", when editing menu application in PHP 8.1 environment
- Fatal error: Uncaught Error: Call to a member function initialize_arrays() on null, when executing the procedure using the SQL SERVER connection
- "Internal Server Error" and missing files when publishing projects via SFTP


ScriptCase 9.9.008
- Change log not available for this version


ScriptCase 9.9.007
- Change log not available for this version


ScriptCase 9.9.006
Added:
- Added support for resizing message inputs in the Application Translation tool
- Added option to open div below or in modal in express editing and default values

Fixed:
- Fixed issue when deleting project message indexes that contain spaces in the name
- Fixed problem with missing libraries in the installer for Linux 64 bits
- Fixed problem using ajax events after reloading a grid with full paging defined


ScriptCase 9.9.005
Improved:
- Improved layout of table and dictionary deletion alerts in project data dictionary

Fixed:
- "Trying to access array offset on value of type null" error when generating security module in environments with license without upgrade
- problem in Position option of SweetAlert using Toast in express edition
- problem in Excel export generation, when using the sc_actionbar_disable macro in events
- problem when configuring a group by by month and year and sorting by day
- "Undefined array key" error when generating the calendar application, in the PHP 8.1 environment
- problem in the visualization of the "Timepicker" component of the hour field, next to the html editor field
- width problem in the columns of the save grid block, when the grid had many fields
- problem displaying the record using the MSSQL Server database uniqueidentifier data type
- problem with not compiling applications that had a friendly URL, at the end of publication generation


ScriptCase 9.9.004
Added:
- quicksearch for searching indexes in the Translate Applications tool
- fixed bar on project list screen with vertical orientation
- show/hide password icon on login and license registration screens
- Error Position option in Express Edit
- Display Field Error option in a modal in Express Edit
- Error Timeout option in Express Edit
- Display Date Format option in Express Edit and Default Values
- Date Display Position option in Express Edit and Default Values
- Show Message option in Express Edit

Improved:
- project message translation interface
- project data dictionary interface

Fixed:
- problem with displaying ordering icons, on the fixed bar of the project's list of applications, on screens with lower resolutions or after window resizing
- problem in maintaining the ordering state of the applications in the interface after closing the application's tab
- problem in buttons interface after project conversion from v8 to v9
- Fatal error: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array when creating buttons in converted applications
- Fatal error: Uncaught Exception: Serialization of 'LDAPConnection' in LDAP security module login screen
- grid sorting problem when using the MEDIUMINT data type in MySQL
- problem when inserting images/documents containing accents in the multi-upload field in the SQLServer database. The error only occurred when the option Conversion from charset to UTF8 by database was disabled in the project.
- problem when renaming folders with numerals in project messages


ScriptCase 9.9.003
Improved:
- Added new "Last Accessed" column in the interface of all projects in List mode
- Added protection to not create buttons using parentheses

Fixed:
- problem with alignment of totals when changing the placement of action buttons
- problem with Grid navigation when using the sc_change_css macro
- problem in connection definition when publishing example projects
- views of Mssql Server connections "Native Srv" and "Native SRV PDO" in Linux and Mac development environments. The connections will only be visualized when the extensions are enabled in the environment
- the visualization of Mssql Server connections in the production environment. You will need to update the production environment.
- a Javascript error when exporting the grid for printing, using a nested grid link
- problem in viewing the code in the Ajax event button, created through the action bar, when making a change to the grid's SQL
- problem when accessing detail module in grid application using sc_change_css macro in PHP 7.3
- connection error with MSSQL Server Native SRV PDO driver in production environment
- problem when using the same nested grid name in the target application
- problem with Undefined array key "t_collapse" when accessing the "Blocks" option in the Form, in environments with PHP 8.1
- problem in exporting Excel in grids that have nested grid, when the Excel option was set to "No" in the nested grid
- problem in log generation in French and Italian languages
- problem when generating project source code by choosing outdated application options
- alignment of the font awesome icon on the application button if it is displayed without a label
- problem with Undefined variable $tbapl_Texto_Size_Header in grid generation
- a problem when searching the filter in the chart, using the Slider type option
- problem when activating dynamic totaling option in configuration of group by in grid application


ScriptCase 9.9.002
Added:
- Click here and see all the news in version 9.9
- payment API (Stripe)
- payment API (Braintree)
- payment API (Mercado pago)
- field type Rating Smile
- field type Rating Thumbs
- Font Awesome support in "Rating" type field setting
- integration with Google Sheets in form applications
- action bar for grid applications
- support for iframe in the nested grid, allowing to execute all the functionality of the grid
- preseeding for foreign key in data dictionary columns
- foreign key improvement option in Scriptcase settings, making it easier to define lookups in grids and forms
- sc_change_css() macro for grid application
- hint option for "Star" Rating fields

Fixed:
- problem displaying the cursor for typing when using "Select2" with the search area
- a problem with displaying the unsaved changes message in forms that contain the Signature field
- problem when using the "select2" option with multiple values


ScriptCase 9.9.001
Added:
- payment API (Stripe)
- payment API (Braintree)
- payment API (Mercado pago)
- field type Rating Smile
- field type Rating Thumbs
- Font Awesome support in "Rating" type field setting
- integration with Google Sheets in form applications
- action bar for grid applications
- support for iframe in the nested grid, allowing to execute all the functionality of the grid
- preseeding for foreign key in data dictionary columns
- foreign key improvement option in Scriptcase settings, making it easier to define lookups in grids and forms
- sc_change_css() macro for grid application
- hint option for "Star" Rating fields
- sc_actionbar_state macro in the grid action bar
- sc_actionbar_disable macro in the grid action bar
- sc_actionbar_show macro in the grid action bar
- sc_actionbar_clicked_state macro in the grid action bar
- sc_actionbar_enable macro in the grid action bar
- sc_actionbar_hide macro in the grid action bar

Improved:
- the layout of the Google Sheets API interface in the production environment

Fixed:
- problem when using uppercase fields in the form inclusion, using the Google Sheets api
- problem using action buttons when there is no link between applications and the detail module enabled in the grid
- Problem in viewing log module events in the application
- error of Undefined array key "name" in button creation interface
- problem when navigating between records when using subquery with iframe in Slide type orientation


ScriptCase 9.9.000
Added:
- payment API (Stripe)
- payment API (Braintree)
- payment API (Mercado pago)
- field type Rating Smile
- field type Rating Thumbs
- Font Awesome support in "Rating" type field setting
- integration with Google Sheets in form applications
- action bar for grid applications
- the macros sc_actionbar_state(), sc_actionbar_clicked_state(), sc_actionbar_enable(), sc_actionbar_disable(), sc_actionbar_show(), sc_actionbar_hide(), in the grid action bar
- support for iframe in the nested grid, allowing to execute all the functionality of the grid
- preseeding for foreign key in data dictionary columns
- foreign key improvement option in Scriptcase settings, making it easier to define loo