Valence 5.2+ (All Builds)

[richard.milone]

Valence Framework 5.2.20201209 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Corrected issue with initial value on a checkbox filter not being applied
• NAB: Adjusted parser to preserve quotes surrounding aliased column names / reserve words
• NAB (mobile): Corrected issue where form fields in error would not disable primary button
• RPG Toolkit: vvUtility_parseIntoCharArray - corrected issue that would cause final element to be omitted if only one character long
• VVSYSMON: Adjusted to accommodate subsystems ending or starting while analysis is being performed (CPF187A)
• Portal exit programs: Corrected the "app initialization" exit program to pass an vvExitMode value of 'VVCALL_INIT' instead of 'VVCALL0'
• General: Corrected issue where fieldset titles were no longer showing properly due to a recent Chrome update

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200819 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Timeline widget - added grouping field option
• NAB: Grid widget - corrected issue where action buttons could sometimes not be disabled on infinite scroll grids when no row selected
• NAB: Excel download - ensure decimal values in spreadsheet follow grid renderer config
• NAB: General - added a cache buster to all CSS files
• VVRMTDB - Adjusted batch job to use library list of Valence environment rather then core Valence library

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200720 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Excel/PDF download - Blank values in grid widget custom renderers are now honored in Excel and PDF downloads
• NAB: Excel download - Corrected issue that could cause date column values to be off by one day under certain circumstances
• NAB: Excel download - Corrected issue that could cause Excel download on grouped grids to not generate
• NAB: Grid widget - Adjusted to ensure numeric cell values are not mistakenly treated as phone numbers on mobile devices
• NAB: Grid widget - Corrected issue where filters could disappear upon maintenance in NAB Designer
• NAB: Grid widget - Corrected issue that could cause group subtotals to not appear under certain circumstances
• NAB: Grid widget - Corrected issue affecting older TR levels on 7.1 and 7.2 where paging would not work correctly (in VVOUT)
• (.1 build) NAB: Grid widget - Adjusted to accommodate CSS bug introduced by latest Windows/Chrome update that was causing grids to show no data
• (.1 build) NAB: Edit Grid widget - Corrected issue where grids using infinite scroll feature could have buttons not disable after updating a record
• Fusion5250: Adjusted VVFUSIONP job to reflect the IBM i user ID associated with the interactive 5250 job
• Fusion5250: Improved cursor positioning logic in PDM, etc.
• Examples: Paging grid - adjusted back-end search logic to properly escape single quotes

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200630 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Excel download - Corrected issue with improper time zone adjustment being applied to timestamp columns
• NAB: SQL parser - added support for OPTIMIZE FOR clauses
• NAB: App import - Adjusted to preserve category of imported apps when a match by name can be made, otherwise app goes into default category ("Uncategorized")
• NAB: Widget filters - corrected issue where original widget filter could be lost after another user filter is subsequently applied
• NAB: Grid widget - corrected issue where overriding the grouping column would result in an incorrect column heading and have the pdf/excel document reflect the overridden grouping column
• NAB: Grid widget - fixed bug where column sequence could be incorrect when it has 50 or more columns
• NAB: Grid widget - corrected issue where a column containing a summary function could be included in the WHERE clause of a global search, resulting in an SQL error
• Fusion5250 - improved edit-checking and handling of double byte character fields
• RPG Toolkit: vvJSON - adjusted to properly escape double quotes inside segments containing a mix of single byte and double byte characters
• RPG Toolkit: vvOut_execSQLtoJSON - auto append OPTIMIZE FOR clause to improve performance on paging grids w/ asensitive cursor; Can be superseded by new vvOut.optimizeClause field
• RPG Toolkit: vvOut_initialize - for systems below IBM i OS 7.3, check for SQL OFFSET clause support is now done once per job, rather than once per activation group. This will reduce "Y in *LIBL type *FILE not found" clutter in the job log.

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200608 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: RPG programs can now enable/disable widget components
• NAB: Widget filters - for "between" filters over dates, blank filter values are now treated as '0001-01-01' or '9999-12-31'
• NAB: Form widget - now uses the Valence date format on all date fields
• NAB: SQL parser - added support for table joins based on a subquery
• NAB: Pivot Grid widget - corrected issue that could cause cell color rules to not be followed
• RPG Toolkit: vvOut_execSQLtoJSON - corrected issue where count statements could be thrown off by a LEFT JOIN or an unexpected GROUP BY clause in the SQL statement

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[robert.swanson]

Valence Framework 5.2.20200526 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Added form helper modes (startup/change/blur)
• NAB: Added ability to refresh a widget via an App Variable
• NAB: Popup windows - Can now keep state, versus being destroyed on close
• NAB: Grid widget - Added time format column rendering options (HH:MM:SS && HH:MM)
• NAB: Edit Grid widget - Adjusted logic so edit grids cannot be created over SQL-based data sources containing summary functions
• NAB: Pivot Grid widget - Now fires row click if grid has a filter event and can satisfy the requirements of the filter event, or doesn't have a filter event
• NAB: Pivot Grid widget - Corrected export bug where column headings were not aligning properly
• NAB: SQL parser - Added support for "dec" function (short for "decimal")
• NAB: Excel download - Fixed numeric formatting
• NAB: Form widget - Corrected issue where combo boxes may not be loaded properly
• NAB: Import/export - Corrected issue where combo boxes could be dropped on the export
• NAB: Adjusted filter rules so blanks are treated same as "0" for numeric columns or "0001-01-01" for date columns
• NAB: Corrected issue where the save of an app containing tabs could result in an error
• Portal Admin > Settings > NAB: Added two optional paths (URLs) for specifying .css or .js files to be loaded into all NAB apps at runtime
• Portal Admin > Environments: Prohibit creation of new environments with name that matches an already existing environment
• RPG Toolkit: vvMail - Corrected issue where port number passed with TLS encryption could be ignored
• Portal Login: Resolved issue where "Forgot Password" link would fail when logging in with a non-IBM i user ID with password linked to IBM i profile.

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200415 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Form helper can now refresh a dropdown data source
• NAB: Autofocus now places cursor into first focusable field in popup widget
• NAB: No longer show a value of zero in a telephone-formatted field
• NAB: Allow pasting of numbers with commas into number fields
• NAB: The initial load mask text can now be changed by passing a URL parameter of "nabLoadMask"
• NAB: Excel & PDF now accommodate number calculations inside a column's "custom formatting" value
• NAB: Encrypt summary SQL if encrypt is turned on in Portal Admin/Settings
• NAB: Form widgets now accommodate text areas (via formatting option)
• NAB: Corrected minor issues with app import/export
• NAB: [BETA] Added new "script" feature for adding/running custom JavaScript on a user behavior
• Desktop Portal: [BETA] Added two factor authentication (2FA) option
• Fusion5250: Added ability to copy/paste blocks of text
• Fusion5250: Added ability to override frontend SSL setting
• Fusion5250: Improved Japanese compatibility
• RPG Toolkit: vvIn_Sorters - corrected bug affecting sorting over grouped grids
• Portal Admin > Settings: Corrected bug that would cause Settings to not list at all when "Show hidden settings" not checked (.1 build)

Note: [BETA] features are not yet documented and can only be used if "Enable Beta Features" is activated in Portal Admin > Settings. These will become permanent, documented features in the forthcoming Valence 6.0 release.

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200323 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• Fusion5250: Licensing cost for the Valence Core with Fusion5250 is now free during the coronavirus pandemic. Read our March 20, 2020 blog post for more information
• NAB: Added better fault checking on App/Widget/Data Source import
• NAB: Added localization support for Valence-supported languages to the Timeline widget
• NAB: Added fixed width option on widgets
• NAB: Adjusted to derive proper display size for integer columns in SQL-based data sources
• NAB: Added "Auto Refresh Interval" to Form, Map & Tile widget.
• NAB: Fixed call RPG Program/URL "Prompt User For More Information" when it has more than one dropdown
• NAB: Fixed Hide/Show Widgets "Refresh Data"
• NAB: Added Unchecked/Checked/Both configuration to checkbox filters on grid widgets
• Portal: Allow change password functionality on Valence profiles linked to different IBM i profiles when "Use IBM i Password" option is checked, provided IBM i user ID is not linked to any other Valence profiles
• Portal: Chrome - fixed end session on close of the browser/browser tab
• Installer: Ensure QTMHHTTP has proper access to certs required for running Fusion5250 under SSL

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20200212 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Improved editor for Tile widget configuration
• NAB: Adjusted Behaviors so that button text is no longer automatically upper-cased
• NAB: Added support for summary functions over data sources containing WITH clauses
• NAB: Adjusted document upload logic to not give an "invalid extension" exception when valid extension(s) had been entered with a leading period
• NAB: EXNABBTN > GetFilterValue procedure adjusted to check for both "F1." and "F1_" file prefix syntax
• NAB: Corrected issue where data source caching was not always working correctly
• NAB: Corrected issue where ability to add an icon button to a grid was not available if grid already contained a menu button
• NAB: Corrected issue where app import could go into an endless loop condition
• Portal Admin>Settings: Added new search mechanism so specific settings can be found more quickly
• Portal: Added logic to trap and log record locks over VVSESSDATA when killing expired sessions in vvSecure_killSessions
• RPG Toolkit > VVOUT: Corrected total row count calculation in vvOut_execSQLtoJSON for SQL statements containing GROUP BY clause (would also affect record counts showing on NAB grids)
• RPG Toolkit > VVOUT: Added support for insert/update/delete operations against remote DB connections in vvOut_execSQLtoJSON
• RPG Toolkit > VVUTILITY: corrected overflow issue in parseIntoCharArray that could occur when separator is more than one character

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[robert.swanson]

Valence Framework 5.2.20191218 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Corrected issue where grid checkbox column does not work when the grid has any action attached to its row click
• NAB: Corrected issue in mobile grid where summary fields were causing data not to load
• NAB: Corrected issue in Behaviors where the a widget was erroneously showing under the wrong section
• NAB: Corrected issue where the SQL formatter was inserting a space before '#' in columns that contain the '#' symbol
• NAB: Added icon column functionality to grids
• NAB: No longer expands all behaviors by default
• NAB: Corrected issue with import process where launch app actions were not importing properly
• NAB: Corrected issue where Call RPG Program -> success=true and success=false events are not showing in Behaviors
• NAB: Corrected import issue where in rare circumstance app import would show as successful yet the app was not fully imported
• NAB: Corrected issue where wizard based data source filters clicking on a field while in sql free-format mode was always injecting a file index of one even if it isn't the first file in the data source
• NAB: Corrected issue where KPI widget with empty data source will display incorrectly
• NAB: Adjusted SQL parser to support GROUP BY GROUPING SETS
• Portal Admin > Apps: Added ability to copy NAB apps
• RPG Toolkit > vvOut_execSQLtoJSON: Adjustments made to improve row count performance (also affects NAB data sources)
• RPG Toolkit > VVDSEXIT1: expanded size of VVSESSDS field from 999A to 3200A to accommodate larger library list. Affects functionality of vvUtility_callExitPgm
• Fusion5250: Added macro recording/saving
• Fusion5250: Autofocus last focused position when reactivating the application in the portal

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20190918 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Adjusted Form widget to prevent auto-filling passwords if input is masked on any form field.
• NAB: Added ability to force uppercase on form input fields
• NAB: Added close event to vertical container
• NAB: Added simple theming support: choose color scheme, adjust widget border width and radius
• NAB: Added file upload to button call RPG program
• NAB: added a progress bar option to the KPI widget
• NAB: added app security to behaviors
• NAB: Corrected issue where attempting to apply a filter over a very long calculated column (> 256 chars) would throw an SQL error
• NAB: Corrected issue where grid cell colors were not applying to the "boolean" renderer
• NAB: Corrected issue where grid column sortable:false was not applying when going back into edit mode of the widget
• NAB: Corrected issue where form field colors were not saving properly when inside a field container
• NAB: Corrected issue where URL widget presented as a popup was not translating the URL string properly
• NAB: Corrected issue where close events were not saving properly when attached to a "utility" widget
• NAB: Corrected issue where the timeline would not load if created from the "Create New App" option on the main data source/widget list.
• NAB: Corrected issue where the timeline's height wouldn't adjust correctly on mobile if it gets a title set
• NAB: Corrected issue where pdf download would fail if grid widget is set to infinite scroll
• NAB: Corrected issue where an exported app containing a widget that launches another app could reference an incorrect or nonexistent app ID on the imported instance
• NAB: Adjusted import logic to accommodate differences in app names/descriptions between instances when determining app ID to launch
• NAB: Adjusted default behavior so that when a popup widget shows/filters another popup widget to not automatically close the popup
• Web Services: Added support for wildcard (*) inside URL. Wildcard value can be retrieved via vvIn_char('vvWildcard')
• RPG Toolkit - vvOut_data: added optional HTTP status and response text params

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20190822 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Introduced new "Tiles" widget
• NAB: Added mobile support for the new Timeline widget
• NAB: Fixed issue with Timeline widget's "Auto Load" not being applied
• NAB: Fixed issue with Timeline widget's "End Data" field not being applied
• NAB: Adjusted SQL parser to support UNION ALL
• NAB: Adjusted SQL parser to support LATERAL JOIN
• NAB: Added option to encode all SQL clauses to avoid firewall blocks
• NAB: Adjusted "hide zero values" grid column renderer to apply to prefix/suffix values as well
• NAB: Corrected issue where total row count could be incorrect on complex SQL-based data sources containing WITH clauses
• NAB: Corrected import logic to accommodate changed IDs
• NAB: form widget "helper" program to dynamically hide/show/disable/enable/filter/set values of form fields
• NAB: new response helper procedure to button template program (EXNABBTN) to simplify responses and easily interact with form fields.
• NAB: ability to mask input for form widget input fields.
• NAB: provide built in email, phone, ssn#, or URL validation for form widget input fields.
• NAB: Form widget - rule based text color
• NAB: Added close application as a utility action.
• RPG Toolkit - vvUtility_parseIntoCharArray: Adjusted logic to properly handle separators that are greater than one character

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20190723 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Introduced new Timeline widget
• NAB: Added edit grid support for aliased files
• NAB: Corrected issue where saving of a form widget containing field groups could break under particular circumstances
• NAB: Corrected problem with "Create App" shortcut on widgets not working properly
• Fusion5250: Added support for SSL
• Fusion5250: Added ability to set a workstation naming convention in Portal Admin>Settings. Alternatively you can also use a custom exit program to set the device name.
• Fusion5250: Corrected conflict with RemoteDB that could sometimes cause the VVFUSIOND Daemon job to go into a MSGW condition.
• Spool File Viewer: Corrected issue where error messages encountered when attempting to perform actions on spool files would not display properly
• RPG Toolkit - vvIn_Char(): Added optional third parameter to replace substitution characters (hex 3F) with a blank space. Can also be activated globally via Portal Admin > Settings.
• RPG Toolkit - vvIn_Body(): Adjusted to limit CCSID conversion to size of data in memory at pointer location to avoid including garbage characters
• RPG Toolkit - vvIn_base64toFile(): Adjusted to trap IFS errors (previously assumed IFS open and write API calls always succeeded)
• VVMIGRATE: Corrected issue where portal User records would not migrate from pre 5.2+ instances

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20190630 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Corrected edit grid issue where a left-joined file in a data source with a null record would throw a "cannot derive key" error
• Portal: Corrected issue where an IBM i user logging into the portal for the first time with an expired password could not successfully change password
• Fusion5250: Adjusted logic to accommodate possible authority restrictions on data queue
• RemoteDB: Adjusted count logic to accommodate more complex queries containing WITH clause
• RemoteDB: Added support for Oracle Database connections
• Nitro AutoCode: Ensure source file and object libraries specified in Settings exist prior to program generation

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.

[richard.milone]

Valence Framework 5.2.20190619 (Valence 5.2+) is now available. Changes in this build since the previous release are:

• NAB: Adjusted SQL parser to support NOT EXISTS
• NAB: Adjusted SQL parser to support subqueries in lieu of file names in FROM clause
• NAB: Added ability to set Portal security on URL Widgets
• NAB: Added inner padding to line chart widget
• NAB: Adjusted export/import to include tags
• Portal: Corrected bug that could cause MSGW condition when changing an expired password at login
• RPG Toolkit - vvSecure: Adjusted SendInvalidSidError routine to accommodate non-CGI calls (i.e., from PHP, Fusion, etc)
• RPG Toolkit - vvUtility: Corrected problem where using _getSessVar with deprecated VVSESSVAR method would cause some session fields to return as blank
• Fusion5250: Added many new code pages (total of 22 now supported)
• Fusion5250: Portal Admin > Languages now has a default setting for each language code page (CCSID). Code pages overrides for individual users can also be set in file VVUSERS via field VVCODEPAGE. Ability to edit vial Portal Admin > Users is coming on the next build.
• Fusion5250: Significantly improved performance in screen rendering (up to 300% faster)
• Fusion5250: Ensure Daemon and Proxy jobs are submitted with user associated with the Fusion JOBD, not the user sparking its launch
• Fusion5250: Improved overall reliability with various bug fixes
• Fusion5250: Note that Fusion5250 is still considered BETA--general release is expected next month (July 2019)

Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2+.

Go to http://forums.cnxcorp.com/node/12708 for full release notes.