• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Announcement

Collapse
No announcement yet.

Valence 6.2 (All Builds)

Collapse
This is a sticky topic.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Valence 6.2 (All Builds)

    Versions:

    6.2.20240314, released March 14, 2024
    6.2.20240126, released January 26, 2024
    6.2.20231220, released December 20, 2023
    6.2.20231107, released November 7, 2023
    6.2.20231026, released October 26, 2023
    6.2.20230927, released September 27, 2023
    6.2.20230808, released August 8, 2023
    6.2.20230721, released July 21, 2023
    6.2.20230630, released June 30, 2023
    6.2.20230526, released May 26, 2023
    6.2.20230515, released May 15, 2023
    6.2.20230428, released April 28, 2023 [BETA]


    Note Regarding Instance Manager:

    Once you have installed Valence 6.2 to your "base" VALENCE6 instance, you must only use Instance Manager from the base instance to manage all Valence instances on a particular system/partition. This is important since you must be running the latest Instance Manager code for it to manage the instances properly.


    Licensing:

    If you are updating a Valence 6.0 or 6.1 instance to 6.2, and you already have a valid license key installed, your key should update automatically for Valence 6.2 upon installation. However, in some circumstances you may need to obtain a new 6.2 key from CNX. Be sure to obtain a valid Valence 6.2 key prior to updating any production instances to Valence 6.2. Email support@cnxcorp.com to obtain a new license key if you need one.

    If you are installing Valence 6.X to an IBM i system or partition for the first time, Valence should operate automatically with a 30-day trial key. To have your trial key extended please email support@cnxcorp.com.

    By obtaining and using the Valence Framework, it is your responsibility to ensure that you and your company are following the proper licensing terms of the product. Be sure to review the licensing options on the Valence Pricing page and also review the Licensing and Support FAQs page before downloading and using the Valence Framework.


    Installing This Release:
    • If you already have an earlier version of Valence 6.X installed, the Valence 6.2 installer will automatically upgrade your Valence 6.X base instance to Valence 6.2 in place. There is no need to run the VVMIGRATE utility as in prior major upgrades. Once your base instance is upgraded to Valence 6.2 you can then use the Instance Manager app in the base instance to update other instances as usual.
    • Go to the downloads page to see what releases are available. If this release is superseded by another release it may no longer be available.
    • If this release is available for download, click the link to download the installation app. Be sure to download the correct version of the installer for your PC operating system and for your IBM i OS (Valence 6.2 is compatible with 7.2, 7.3, 7.4 and 7.5). For sites running on earlier operating systems you can see if older Valence versions are still available on the download page. If you need assistance with finding a Valence installer compatible with your operating system contact CNX to discuss alternative installation options.
    • Follow the prompts to install Valence Framework 6.2 onto your IBM i. Note that you may need administrative rights on your PC or Mac to launch the installer.
    • It is highly recommended that you use QSECOFR to perform the installation to avoid permissions issues.
    • If you are installing Valence 6.X for the first time, this release will create library VALENCE6 and ifs path /valence-6. It will also create an Apache server instance named VALENCE6. If you are updating a prior 6.X installation, then these resources will be updated accordingly.
    • If you have Valence Framework versions 5.2+ or prior installed on your system, installing this release will not affect those earlier versions.
    • Once Valence 6.2 is installed you can access the Valence Portal with the link http://xxx.xxx.xxx.xxx:7060 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7060 is the default installation port for all Valence 6.X versions.
    • It is recommended to log in with a security administrator IBM i user profile (like QSECOFR or a profile with similar authority) when first logging into Valence 6.2 to check operation. You can also access most administrative functions in Valence by logging in with user vvadmin, password vvadmin (this should be changed after installation). You may also try to log in with any valid IBM i profile.
    • If using the vvadmin profile, it is highly recommended that you go into the Portal Admin app in the Valence Portal and add an IBM i user cross reference to vvadmin with security officer authority (like QSECOFR) so you will not have permissions issues.

    Features and Fixes pending for the next build:
    • Nitro App Builder (NAB) - Grids: Added a app variable link to support setting or removing tooltips on grid columns
    • NAB - Forms: Corrected issue where a combobox would sometimes erroneously show that max length has been exceeded
    • NAB - Behaviors: When setting an app variable, "treat as expression" icon is now disabled if no value has been set
    • NAB - App Variables: Added new column to App Variables list to optionally omit specific app variables from being passed for which no value has yet been set (i.e., when linked to "Get Filter")
    • NAB - Data Sources: Corrected issue that could cause decimal precision to be lost on filters under certain circumstances (per forum post)
    • Fusion5250: Added ability to connect to IBM i secure telnet on systems where standard telnet is restricted
    • RPG Toolkit - vvOut_execSQLtoJSON (extractRowCount logic): Corrected issue that would throw an SQL exception error when attempting to extract a row count from small statements

    New features and fixes in Valence 6.2.20240314:
    • Nitro App Builder (NAB) - Edit Grids: Added ability to set a field to be edited as a text area
    • NAB - Edit Grids: For cases where a column is transformed to a dropdown, added ability to save the combo display value chosen by the user to a separate column on the grid's data source
    • NAB - Edit Grids: Corrected issue where a column transformed to a checkbox would not reflect proper checked/unchecked value when using local data
    • NAB - Pivot Grids: Corrected issue where the set color rule for a column was not properly pulling values from other referenced columns
    • NAB - Grids: Corrected issue where time formatting applied to a column could cause the remainder of the grid row to not be rendered if time value is not a string (per forum post)
    • NAB - Grids: Added two helper methods ("setBackgroundColor" and "setTextColor") for use in custom formatters so the cell's background or text color can be adjusted (per forum post)
    • NAB - Grids: Added new app variable link so that initially hidden grid column(s) can be shown (per forum post)
    • NAB - Grids: Added new app variable link to disable paging of a widget if standard paging is turned on
    • NAB - Grids: Corrected issue where overriding a column's label via an app variable would cause the column's tooltip to be dropped (per forum post)
    • NAB - Forms: Added a new app var link to focus cursor on an editable field (Desktop only)
    • NAB - Forms: Added option to set fields to the value of an app variable whenever field is reset
    • NAB - Forms: Input formatter now includes option to add before or after text, similar to what's available on grid formatters. For example, a numeric field that is expressed as a percent would have a percent sign appended to the end of the input value.
    • NAB - Forms: Corrected issue where, under certain circumstances, a form helper program would not get called as expected when a field value is changed
    • NAB - Tab Utility Container: Added three new app variable links for tabs to (1) issue a confirmation when exiting a tab, (2) fire an event when activating a tab, and (3) fire an event when exiting a tab (per forum post)
    • NAB - Tiles: Corrected issue in Designer where, when tile was used in a popup, was not saving off properties for "Selectable" and "Enable and Allow Multiple Selections", as well as any defined buttons in the tile
    • NAB - Data Sources: SQL parser updated to fully support sub joins
    • NAB - Data Sources: SQL parser updated to support START WITH / CONNECT BY syntax
    • NAB - Data Sources: Corrected issue that could unnecessarily cause extra parentheses to be inserted into SQL statements containing sub-queries joined in the FROM clause
    • NAB - Behaviors: Adjusted Designer so that event listeners are now grouped by app and event name in alphabetical order
    • NAB - Behaviors: Corrected issue where if application had applications running within itself, global events would not be passed to any nested applications (per forum post)
    • NAB - General: Added new NAB app variable "nabAppMsgHide" to either hide the App Message (true) or show it if its active (false)
    • NAB - General: Added new NAB app variable "nabChangeAppName" that can be used to change the name of the running app while in the desktop portal
    • NAB - General: Added a new widget-level app variable to set focus on a specific filter field
    • NAB - General: Added new app-level setting to disable auto-focus. When checked, no field or widget will auto-focus; developer must set focus manually (per forum post)
    • NAB - General: Added check for literals on inline data when transforming to a combo or radio button (literals list is accessed via F4 key in Designer)
    • NAB - General: In Designer, removed app-level 'allow vertical scroll' since this functionality is now provided through the scrolling container utility widget. For backward compatibility, apps already set to 'allow vertical scroll' will continue to see this setting until unchecked.
    • NAB - General: In Designer, corrected issue where app variables would not show usage when linked to pop-up widgets
    • NAB - General: Corrected issue where a combobox using "On Demand Filtering" would issue an SQL error if the underlying data source was created with the data source wizard
    • File Editor: Corrected issue where a date field would sometimes not show correctly based on format selected in valence base settings (per forum post)
    • RPG Toolkit - vvOut_execSQLtoJSON (extractRowCount logic): Corrected issue that was causing a "Keyword AS not expected" SQL exception to be thrown into the job log, which would force vvOut to derive the total row count in a less efficient manner. Condition was occurring on SQL statements containing both a WITH clause and a main SELECT clause with one or more aggregate functions.
    • RPG Toolkit - vvMail_validateEmailAddr: Adjusted installer to ensure all additonal .jar file references needed in classpath are included (specifically, dnsjava-3.5.2.jar and slf4j-api-1.7.36.jar)
    • RPG Toolkit - EXEXITPGMM (exit program for VVMAIL): Updated VVMAIL data structure to reflect latest incarnation. Not necessary if using copy source to pull in VVMAIL data structure at compile time.
    • Spool File Viewer: Increased maximum number of output queues supported from 2000 to 4000

    New features and fixes in Valence 6.2.20240126:
    • Nitro App Builder (NAB) - Grids: Added new link-to-app variable 'Summary Values' to allow an app variable to pull in the summary value of a column (per forum post)
    • NAB - Grids: Corrected issue on grids with grouping activated where the "expand all" action linked to an app variable would sometimes not work properly when first set to 'true'
    • NAB - Edit Grids: Corrected issue in Designer where sometimes the combo box of form widgets available to link to an edit grid would be hidden when it should be shown, or would show incorrect values
    • NAB - Tree Grids: Corrected issue where an auto-load-all-levels tree grid containing no second level records would still show the expander toggle
    • NAB - Tree Grids: Corrected issue in Designer where it was not allowing label text to be changed in "container" columns
    • NAB - Pivot Grids: Corrected issue where min/max values were not working properly [.1 build]
    • NAB - Forms: Added new SetReadOnly() procedure in helper program
    • NAB - Forms: Adjusted logic to consolidate all combo/radio store loads into one AJAX request, thereby improving load performance. [This has been temporarily removed in .1 build for further stress testing.]
    • NAB - Forms: Adjusted 'validate as phone number' to not validate the field if set to zero or blank and 'suppress zero value' is checked
    • NAB - Forms: Corrected issue where app variables linked to "get value" was not working properly for radio buttons
    • NAB - Forms: Corrected issue in which a helper program would not be called on show if the form was inside a utility widget like vertical container, tab container, etc.
    • NAB - Forms: Adjusted so that when a minimum value is specified on a date field, ensure the date is valid before comparing to min value [.1 build]
    • NAB - Tiles: Corrected issue where "bottom" position for buttons was not being saved in Designer
    • NAB - Tiles: Corrected issue where horizontal scrolling would sometimes cut off the content of the leftmost tile. Also adjusted to ensure vertical scrolling remains functional when needed.
    • NAB - Tab Container: Added new link-to-app-variable 'currentActiveTab' that will be set to the current active tab's index, starting at 1. Whenever the active tab changes, this linked app variable will change with the corresponding tab's index.
    • NAB - Info Widget: Corrected issue where sometimes the widget would show despite being hidden via Behaviors
    • NAB - Filters: Corrected issue where filter fields added against a widget on an older NAB build would, under certain scenarios, not show as selected
    • NAB - Behaviors: Added ability to dynamically change a button's color via an app variable (per forum post)
    • NAB - Behaviors: Added new 'nabFireLocalEvent' app variable to facilitate firing a local event (string passed in app variable will be the event fired)
    • NAB - Behaviors: Corrected issue where a button set to be hidden via an appVar would sometimes show anyway
    • NAB - General: Added new "Scrolling Container" utility widget
    • NAB - General: Adjusted rendering logic so that on apps with "Allow Vertical Scroll" activated, widgets with no explicit height will grow to the full height available. Previously NAB was forcing each widget to have an implied fixed height.
    • NAB - General: Adjusted logic to trim any leading/trailing spaces from tags
    • NAB - General: Adjusted Designer to ensure all newly specified app variables must start with an alpha character
    • NAB - General: Corrected issue in Designer where read-only app variables were being shown in the "set app variables list" (via behaviors) that should not be shown. For example, nabCurrentTime.
    • Portal - General: Added new Valence.util.App.setName to support dynamically changing the name of an application that is currently running (Desktop only). This new function accepts two parameters: (1) the application key (if set to null, will apply the key from the calling application); (2) the value of the new name. (per forum post) [.1 build]
    • Portal - General: Adjusted VVCALL so that each CGI job no longer re-validates the existence of the same program object processed on prior call. This should slightly improve performance on rapid-fire calls to the same program [.1 build]
    • Portal - Running Apps menu: Adjusted so that the actively running app is highlighted
    • Portal - Corrected issue when counting total opened apps that are cross-origin (meaning going to a different domain), such as Valence Guides app (per forum post)
    • RPG Toolkit - VVPDF_addTable: Corrected issue where italics and underline formatting for column headings, passed via the VVPDF data structure in first parameter, were being ignored [.1 build]
    • RPG Toolkit - vvUtility_getFieldInfo: Adjusted logic to accommodate older versions of IBM i OS 7.3 and 7.4, which was causing "object not found" pop-up messages to appear
    • Examples App - Send Email: Adjusted to no longer set an overriding auth type by default (previously was *NONE)

    New features and fixes in Valence 6.2.20231220:
    • Nitro App Builder (NAB) - Edit Grids: Adjusted UI to remove the toolbar entirely when Add button is hidden via an app variable and no other buttons are present
    • NAB - Edit Grids: Adjusted so when using local data, calculated columns can now be set to editable
    • NAB - Edit Grids: Corrected issue that would prevent record adds or edits to data sources pulling from unqualified long table names
    • NAB - Edit Grids: Corrected issue where a grid column transformed to a lookup and set to "read only" via an app variable was not being set to disabled as expected
    • NAB - Tree Grids: Corrected issue where app would sometimes remain masked after all levels are loaded
    • NAB - Grids: Added new property that can be assigned to app variables to track total selection count when checkbox selections are active
    • NAB - Grids: Added a new configuration option to not save state on stores, meaning changes to the grid sort revert to the default when app is closed and relaunched (per forum post)
    • NAB - Grids: Adjusted so that nabTotalCount is now updated on grids set to local data (previously only supported non-local data)
    • NAB - Grids: Corrected issue where checkbox conditions were being ignored if the grid was inside a popup window
    • NAB - Grids: Corrected issue where an icon column conditioned on anything other than a data source column value would result in a blank grid (per forum post)
    • NAB - Grids: Corrected issue where a row menu option set to show conditionally could break the grid (per forum post)
    • NAB - Grids: Corrected issue where a grid containing a column container ("super columns") would ignore the grid's slim view setting
    • NAB - Grids: Corrected issue where a grid containing locked columns could cause the Designer to crash if column containers are present
    • NAB - Grids: Adjusted non-legacy Excel download to set column to wrap text when "Wrap Cell" is specified in grid configuration
    • NAB - Grids: Adjusted non-legacy Excel download to recognize "<br>" in column headers or cells as a line feed
    • NAB - Grids: Corrected issue where non-legacy Excel downloads were ignoring any before/after text specified in column renderer
    • NAB - Forms: Added ability to set a field's "required" property based on an app variable
    • NAB - Forms: Added ability to set a numeric field's minimum value via an app variable
    • NAB - Forms: Added new "nabActiveFormHelperCnt" variable that is incremented each time a form helper program is called and decremented when program completes. This can be used to disable a "Save" button until all form helper programs have done their thing (i.e., via nabActiveFormHelperCnt === 0 )
    • NAB - Forms: Added new "hightlightError" app variable (in the General tab). When set to true, the form will automatically scroll up to the first errant field listed and briefly highlight the field to draw attention to it
    • NAB - Forms: Adjusted the "Reset" linked app variable field list to include non-editable fields
    • NAB - Forms: Adjusted the "Get Field Value" linked app variables to pull initial values rather than only user-altered values
    • NAB - Forms: Adjusted radio button logic to show "required" indicator on the field label when applicable
    • NAB - Forms: Adjusted formatting so that when "suppress zeros" is checked on a field it supersedes any other formatting specified
    • NAB - Forms: Messages returned from a form helper exit program are now trimmed, as untrimmed messages were imparting a lot of blank space in the response
    • NAB - Forms: Corrected issue where a form configured to show errors as tooltips would not work properly when errant field(s) were inside a field set
    • NAB - Forms: Corrected issue where an app variable linked to a combo box would not set the value under certain conditions
    • NAB - Forms: Corrected issue where back-end helper program "formShow" could send previous values in some circumstances (per forum post)
    • NAB - Tab Panels: Added ability to disable tabs via an app variable
    • NAB - Tab Panels: Added ability to set an error indicator on any tab via an app variable
    • NAB - Tab Panels: Corrected issue where tabActive value was not being set as expected
    • NAB - Tab Panels: Corrected issue where, under certain conditions, moving a widget could cause the Designer to break
    • NAB - Tiles: Added new option for horizontal scrolling
    • NAB - Tiles: Corrected issue where buttons placed on a tile would always go on the bottom, even if "top" was specified in Behaviors. Note: Existing apps that had been showing tile buttons on the bottom will now show them on the top if so configured
    • NAB - Data Sources: Corrected issue where global member override was not automatically being applied to multi-member files (per forum post)
    • NAB - Charts: On a multi series chart, corrected issue where a chart reload would cause a previously hidden series to start showing, despite app variable directing it to remain hidden
    • NAB - Widget Filters: Adjusted to support decimal precision up to the number of decimals in the underlying field. Previously would only support precision to two decimal places (per forum post)
    • NAB - Widget Filters: Corrected issue where an app variable used to pull a filter value would not work when underlying field was a calculated column
    • NAB - Widget Filters: Corrected issue where an attempt to set a filter value through an app variable would sometimes not work properly
    • NAB - Widget Filters: Corrected issue where the loading of a filter would not always unmask the underlying widget
    • NAB - Import: Corrected issue where a *SAVF imported from another system would sometimes not plug details such as the export instance name and export description in repository file
    • NAB - Behaviors: In Designer, added a search field in the "Set App Variables" action section. Also added a search field to the main App Variables list.
    • NAB - Behaviors: Corrected bug where a menu button configured to include an icon would not show the icon when rendered
    • NAB - Uploads: Corrected issue where an upload attempt could lead to a MSGW under certain circumstances, typically in apps containing many app variables
    • NAB - General: In Designer (App view), expanded vertical size of the Sections list and shrunk row size so more sections can be seen without having to scroll
    • NAB - General: Added new "on demand filter" and "enable manual input" options on combo boxes
    • NAB - General: Added new helper app variable "nabCurrentSection" -- returns name of the currently displayed section
    • NAB - General: Added option in Designer to save a widget without exiting
    • NAB - General: Escape key shortcut is now disabled on pop-up windows when the window is configured as non-closable
    • NAB - General: Corrected issue where adding a widget after altering a section's width could cause Designer to break
    • NAB - General: Corrected issue that could cause Designer to lock up when saving behaviors. This condition would only arise on apps containing multiple sections, with one or more grid widgets that include icon columns or custom renderers that alter row height
    • Portal Admin - Settings: Added new "case sensitive" setting for web service URLs
    • Portal Admin - Settings: Added new "Log QSZRTVPR calls" setting for IBM API tracing
    • Portal Admin - Users: Adjusted back-end to use the SQL table USER_INFO_BASIC where available (based on IBM i OS level) to improve performance
    • File Editor: Adjusted edit window to use the default date format specified in Portal Admin > Settings, matching the date format used in the main grid. Previously was always showing dates in *ISO format.
    • Portal - General: Adjusted VVVPORT to ensure polling and badge exit programs utilize the session library list
    • Portal - General: When launching applications in a new browser tab, portal now checks "max open" limit on app before proceeding (per forum post)
    • Fusion5250: Adjusted field background color to extend fully to field edges in order to eliminate black spacing between lines
    • Fusion5250: Corrected issue with bypass field input (affects DBU)
    • VVBATCH: Adjusted non-CGI batch processing job to stop throwing unnecessary exception messages into Errors log related to nonexistent REQUEST_METHOD environment variable
    • VVBATCH: Corrected issue where housekeeping routine to eliminate unused data queues could result in an infinite loop condition
    • RPG Toolkit - vvIn_****: Adjusted logic surrounding QzhbCgiParse to perform more efficiently on rapid-fire repeat calls
    • RPG Toolkit - vvUtility_getObjectLibrary: Adjusted to accommodate long table names in addition to system object names
    • RPG Toolkit - vvUtility_getFieldInfo: Corrected issue that was causing this recently updated routine to return a date format of blank rather than, say, *ISO. This was causing date fields in the File Editor edit window to show as "undefined".
    • RPG Toolkit - vvIfs_readFile: Corrected issue in READLINE mode that would cause one character from the subsequent line to be included on the response in documents containing two-byte line feeds (CR+LF)

    New features and fixes in Valence 6.2.20231107:
    • Nitro App Builder (NAB) - Edit Grids: Added new app variable for applying a value to a specific field on all rows when working with local data
    • NAB - Edit Grids: Adjusted linked forms to recognize address lookup fields
    • NAB - Edit Grids: Corrected issue causing 'clear' icon to not show in one field after clearing another field
    • NAB - Tree Grids: Corrected issue where vvIn_virtual values in a second+ level data source would not be set properly during all-level autoload
    • NAB - Forms: Added new app variable for retrieving the value of a field
    • NAB - Forms: Corrected issue where the presence of a Rich Text Editor field might cause an unnecessary vertical scrollbar to appear on the form
    • NAB - Forms: Corrected issue where cursor would not auto-focus properly if first editable element in the form is a Rich Text Editor field
    • NAB - Forms: Corrected issue where new address lookup feature would only function properly when inside a popup window
    • NAB - File Upload: Adjusted to replace values of any parameter segments with a value of "\n" to "\\n"
    • NAB - General: App variables now allow an expression on their definition or within a "Set App Variable" behavior. The expression may reference other app variables and/or record data.
    • NAB - General: Added new app variable to optionally hide popup window header
    • NAB - General: Corrected issue where the "Set to Blank" option in the initial value field was not working properly
    • NAB - General: Corrected issue where nabFeatureXXX app variables were not saving URL parameters correctly
    • NAB - Exit Programs: Adjusted button helper to no longer throw an exception message into the log when searching for nonexistent session variables (stems from backward compatibility logic)
    • Portal Admin - Users: Corrected issue where middle initial was not being saved
    • RPG Toolkit - vvIn_xxxx: Adjusted to avoid throwing a MSGW condition when procedure call is attempted inside a non-CGI job
    • RPG Toolkit - vvUtility_getFieldInfo: Corrected issue where decimal values were not being encoded properly (per forum post)
    • VVBATCH: Adjusted to better handle cases where batch service job (VBCHxxxxxx) has been killed, or activation group has been reclaimed between calls in an interactive setting

    New features and fixes in Valence 6.2.20231026:
    • Nitro App Builder (NAB) - Grids: Added ability to change column container labels (super columns) via an app variable, similar to how regular column headings can be changed (per forum post)
    • NAB - Grids: Added a new app variable to pull the total count for grids with paging enabled (per forum post)
    • NAB - Grids: Corrected issue where extra whitespace would sometimes show upon scrolling when one or more columns are locked
    • NAB - Edit Grids: Added option to transform an editable column into a series of radio buttons based on in-line or data source data, similar to an in-line combo box
    • NAB - Edit Grids: On linked forms, corrected issue where having a field marked as being in error would not prevent proceeding with the update
    • NAB - Tree Grids: Improved performance by eliminating record count logic when paging is turned off
    • NAB - Forms: Added new utility field for auto-filling address information based on Google Maps api. Other hidden or visible form fields can then be designated to auto-receive the parsed values (street address, city, state, country, zip code, etc). Note: This feature is not yet available for forms linked to edit grids.
    • NAB - Forms: Added new utility field for selecting and uploading files from the local machine. Note: This feature is not yet available for forms linked to edit grids.
    • NAB - Forms: Added option to transform a field into a radio button selection (same as grid)
    • NAB - Forms: Adjusted numeric fields to not adjust value up or down in conjunction with mouse scroll wheel action
    • NAB - Forms: Corrected Issue where the Rich Text Editor was not showing on "call RPG Program / prompt for more information" under certain conditions (per forum post)
    • NAB - Forms: Corrected issue where a button assigned to a field marked in error could move incorrectly
    • NAB - Forms: Corrected issue where, when a form is used in conjunction with an edit grid, fields marked as required would not show as being required
    • NAB - Forms: Corrected issue that could throw a console error when a field set to clearable is changed to non-editable
    • NAB - Forms (Mobile): Corrected issue where an event fired from a back-end RPG helper program was not being executed on the front-end
    • NAB - Data Sources: Added option in Designer to show system column names in lieu of long names
    • NAB - Data Sources: Corrected issue where parser was removing alias on a listAgg column under certain conditions (per forum post)
    • NAB - Data Sources: Corrected issue in Designer where long field names exceeding 30 characters were being truncated
    • NAB - Data Sources: Corrected issue where column headings were not being decoded in the Designer
    • NAB - Charts: Added "Suppress minimum value" option to accommodate cases where the value to display is actually zero. When activated, the minimally visible 2 pixel bar will not show on zero values.
    • NAB - Charts: Corrected issue where "Rotate text" option was not being displayed in Designer under certain conditions
    • NAB - Behaviors: Corrected issue where "Show Previous Section" could show buttons that should be hidden under certain conditions
    • NAB - Behaviors: Corrected issue where placing a button into a utility widget would result in a blank screen upon execution
    • NAB - General: Adjusted back-end logic to accommodate larger collections of widgets/popups/appvars etc. in a single app
    • NAB - General (Mobile): Corrected issue where date/time picker and combo box drop-down was not working under certain circumstances on a phone, such as when contained inside a popup (per forum post)
    • NAB - Exit program (form helper): FilterCombo now includes an optional 4th parameter for operator, can be set to one of the following: = (default), <, >, <=, >=, in, notin, like.
    • NAB - Exit program (button helper): Corrected issue where gSelectionCnt was not being populated when uploading a document (per forum post)
    • Portal: Added logic to show an exception message whenever an app attempts to launch another app to which the user is not authorized
    • Portal: Adjusted lock screen to show user ID in a format similar to login screen
    • RPG Toolkit - vvUtility_isInteractive: Converted into an exported procedure (formerly was "isInteractive" for internal use)
    • RPG Toolkit - vvUtility_getFieldInfo: Adjusted to use SQL instead of API calls to retrieve file/field details, to better accommodate field names exceeding 30 characters
    • RPG Toolkit - vvMail_Send: Added additional basic edit checks to email address validation (double @ signs in an address would throw an error in the Java routine)
    • RPG Toolkit - vvOut_execSQLtoXXX: Adjusted to ignore SQL warnings coming out of user-defined functions (SQLCOD 462), rather than terminating the result set load (applies to NAB data sources as well)
    • RPG Toolkit - vvOut_execSQLtoCSV: When downloading to IFS, procedure now validates file path before proceeding.

    New features and fixes in Valence 6.2.20230927:
    • NAB (Nitro App Builder) - Grids: Adjusted logic to check for an already set focusRow or focusRowRRN value after loading, and act accordingly (previously the focus action would only take place when a change was detected in either of these values)
    • NAB - Grids: Corrected issue where "include hidden columns" on .csv download was not working properly (per forum post)
    • NAB - Forms: Corrected issues causing "Refresh & Primary" to no longer function properly (per forum post)
    • NAB - Forms (mobile): Adjusted UI so fields with a validation type of "Phone" will present user with a phone keyboard rather than a standard keyboard
    • NAB - Forms: Adjusted to allow input formats on editable numeric fields (e.g., currency, phone numbers)
    • NAB - Forms: Corrected issue with date/time picker that was causing the component to not focus properly, and adjusted location of the error message (per forum post)
    • NAB - Maps: Added ability to set marker color and adjust based on underlying data source
    • NAB - Calendar: Corrected issue where displayed time could be incorrectly offset by an hour
    • NAB - Popup Windows: Corrected issue where certain theme overrides could cause buttons to be nearly invisible (per forum post)
    • NAB - Behaviors: Added ability in Launch App to launch the app into an existing URL Widget
    • NAB - Behaviors: Adjusted to fire the "When Shown" event for the Main section upon app launch
    • NAB - Charts: Corrected issue where 'rotate text' would sometimes not be applied
    • NAB - Data Sources: Adjusted to accommodate longer column names (previously truncated after 30 characters)
    • NAB - Button Exit Program: Added GetFormNull procedure, used for determining if field value passed is null.
    • NAB - Mobile: Corrected issue specific to Android where app would behave as if it were running in a tablet when it was actually a phone (per forum post)
    • NAB - General: Added ability at the app level to show navigation breadcrumbs
    • NAB - General: Corrected issue where a widget subtitle would occasionally not appear when set via an app variable
    • All Widgets Example app: Adjusted calendar widget to pull last user login information, rather than active session records
    • VVMAIL: Added new vvMail_validateEmailAddr() procedure to validate the domain on an email address (returns *on if valid, *off if not), with an optional parameter to call an external API (BriteVerify) for full address validation
    • RPG Toolkit - vvOut_execSQLtoJSON: Corrected issue where total count could be incorrect on statements containing a Group By clause
    • RPG Toolkit - vvUtility_replaceSubs: Adjusted to check for session variables prior to looking for Valence settings
    • RPG Toolkit - vvUtility_initJava: Adjusted to only execute once per job, rather than on each invocation of a Java routine
    • Portal - LDAP authentication: Corrected issue that was preventing authentication error messages from being conveyed to the front-end
    • iAdmin - Job Queues: Corrected issue in desktop app preventing list of jobs from scrolling beyond the initial page

    New features and fixes in Valence 6.2.20230808:
    • Nitro App Builder (NAB) - Tree Grids: Adjusted so when checkbox selection is turned on, 'auto-select children' is active and 'auto-load levels' is not active, widget will now automatically load the children when checking a row, then auto-select its children
    • NAB - Tree Grids: Adjusted cell formatting to only be applied when cell value is not undefined, thereby avoiding (for example) a "$" showing with no subsequent value (per forum post)
    • NAB - Tree Grids: Corrected issue where unexpected whitespace would sometimes appear inside the grid on a reload
    • NAB - URL Widget: Corrected issue where URL Widgets housed within a vertical or horizontal container would not always function properly
    • NAB - Buttons: Adjusted RPG exit program logic to backward-support the use of vvOut_toJsonPair() the same as SetResponse() method
    • NAB - Popup Windows: Corrected issue that could cause windows to not show as expected on app startup
    • NAB - Popup Windows: Adjusted height setting to only show fixed height / max height toggle option when popup contains a form
    • NAB - Forms: Adjusted email validation to recognize longer domain suffixes (per forum post)
    • NAB - KPI Widget: Added auto load option, matching functionality on other widgets
    • NAB - Behaviors: Added a new URL parameter option in Behaviors to fire an event upon starting up the application. The name of the event fired will be the value of the named parameter.
    • NAB - Behaviors: Corrected issue when filtering a widget where it would sometimes ignore filter rules, such as not filtering on blank dates (per forum post)
    • NAB - Import: Corrected issue where attempting to import a NAB app from prior to version 6.0 would throw an API error and fail to import properly
    • NAB - Import: Corrected issue where attempting to import a NAB app from prior to version 6.1 would fail to update the SAVF repository
    • Portal Admin - Users: Corrected issue where attempting to filter the user list would throw an SQL exception
    • Portal: Added a new exit program to be called whenever a user switches environments (available in Portal Admin > Settings > Exit Programs). The EXEXITPGM example template was updated to show how this concept can be put to use.
    • Portal: When an app path includes a substitution value coming from a back-end call, adjusted logic such that the substitution now occurs every time app is launched, rather than reusing (caching) the value obtained on the app's initial launch

    New features and fixes in Valence 6.2.20230721:
    • Nitro App Builder (NAB) - Forms: Added new linked app variable for setting all editable fields in the form to Read Only, or for removing Read Only from all editable fields
    • NAB - Forms: Added new linked app variable for programmatically changing field labels
    • NAB - Forms: Added new linked app variable for extracting additional data source record values for combo box selections
    • NAB - Grids: Added ability to pull data source columns and/or app variable values into an icon column tool tip (specified in Behaviors)
    • NAB - Grids: Add new "Clear Search" app variable link to facilitate clearing the global search and any column-specific search values
    • NAB - Grids: Expanded column width for row number to accommodate four digits without truncating (per forum post)
    • NAB - Grids: Corrected issue where an app variable linked to "Collapse All" with an initial value of true was being ignored on initial grid render
    • NAB - Grids: Corrected issue with grid sometimes showing extra white space after a filter was applied (per forum post)
    • NAB - Grid: Corrected issue that would arise on grids with conditional checkbox selections active, where clicking the header-level checkbox would select all rows, including rows where the checkbox was disabled
    • NAB - Edit Grids: Added new configuration option for single-click row or cell editing (as opposed to double click)
    • NAB - Tree Grids: Corrected issue where tree was scrolling to top when expanding a row under certain conditions
    • NAB - Behaviors: Corrected issue where applying a filter to a widget would fail due to unqualified field names in the data source SQL statement (per forum post)
    • NAB - General: Corrected issue in designer where widgets added as popups were treated as fixed height, even though "Fixed height" checkbox is unchecked
    • NAB - General: Corrected issue where creating an app directly from a single widget (via menu option) could result in a non-functional app
    • NAB - General: Corrected issue in Designer that could arise when clicking the link button in utility widgets (URL Widget, Spool File Viewer, and Info Widget), resulting in settings appearing on the left that never go away
    • NAB - General: Corrected issue where popup window height could become null; Adjusted default for popup windows to be a fixed height rather than using the new max height
    • NAB - Import: Adjusted import logic to create VVEXPORT library and/or VVEXPORTS repository file when necessary
    • Portal Admin - Users: Added IBM i user status and default environment to users list
    • Portal (Desktop): Added new keyboard shortcuts for switching between active apps, logging out, locking the session, editing user settings, searching the launchpad, showing the left navigation panel and showing the launch pad. Shortcut keys are listed in the user settings control window, accessed by clicking on the user icon in the upper right. This is a Beta feature.

    New features and fixes in Valence 6.2.20230630:
    • Nitro App Builder (NAB) - Charts: Added option for users to download chart image to a file, and an app variable to set the title of the image (otherwise defers to widget title)
    • NAB - Charts: Added ability to set a rotation angle on chart data points
    • NAB - Charts: Added option for bar and column charts to auto-create a series based on the unique values provided for specified field
    • NAB - Charts: Added option to include a 'total' section for auto-created series
    • NAB - Tree Grids: Added logic to honor expand-all app variable setting when moving between pages
    • NAB - Tree Grids: Corrected issue where unexpected blank space could sometimes show up at the top of the grid (per forum post)
    • NAB - Tree Grids (mobile): Corrected issue where grid could sometimes not show any data
    • NAB - Edit Grids: Corrected issue where a row set to be auto-edited (via an app variable row identifier) was not excluding hidden columns
    • NAB - Edit Grids: Corrected issue in Designer where, under certain conditions, grids with very large numbers of columns would fail to save
    • NAB - Edit Grids: Corrected issue in Designer where selected columns on the Post tab were no longer showing as selected once widget was saved and reopened
    • NAB - Edit Grid: Adjusted back-end to send a pertinent exception message to the front-end on rare occasion where a record update or add fails
    • NAB - Edit Grids: On linked forms, adjusted to automatically omit field group border when all fields inside the group have been hidden (same as regular standalone forms)
    • NAB - Forms: Editable, required fields can now be configured to not validate the field contents upon losing focus ("Defer validation")
    • NAB - Forms: Date fields can now be configured so certain days of the week are non-selectable in the date-picker (i.e., Saturdays and Sundays)
    • NAB - Forms: Date fields can now be configured to disallow selection of dates in the past
    • NAB - Forms: Corrected issue where an app could go into endless loop when form helper program sets a field value via a linked app variable (per forum post)
    • NAB - Forms: Corrected issue where disabled checkboxes were not adhering to the "if checked" / "if not checked" value transformation (per forum post)
    • NAB - Forms (mobile): Corrected issue on forms set to auto-load, where a field linked to an app variable would get reset/cleared when the underlying data source did not return any data (per forum post)
    • NAB - Tilles (mobile): Added space between listed items for better aesthetics (per forum post)
    • NAB - Maps: Corrected issue where map widgets were not rendering properly in mobile
    • NAB - Data Sources: Corrected issue in SQL parser that could cause FETCH FIRST clause to be ignored when specified after a GROUP BY
    • NAB - Info Widget: Added this new utility widget option for showing information without an underlying data source
    • NAB - Import: Adjusted to accommodate change to file VVRMTDB on imports from prior to Valence 6.2
    • NAB - Popup Windows: Changed "height" to "max height" so popup window height will auto-size down to its contents when appropriate. Click on new "Fixed Height" checkbox to force window to retain specified size, regardless of contents.
    • NAB - General: Improved app variable "where used" information to show additional details regarding how it's changed or used, and expanded scope to include all levels of Behaviors where app variable is referenced
    • NAB - General: Added shortcut to launch an app directly from designer by clicking the selector icon adjacent to desired app, then selecting "Launch"
    • NAB - General: Corrected issue where an exceptionally large number of app variables in an app could result in an unlaunchable app. Number of app variables is now unlimited (per forum post)
    • NAB - General: Corrected issue where initial save of an app would ignore the "Mobile" checkbox
    • NAB - General: Corrected issue where configuration settings for more than one popup window could be opened simultaneously
    • RPG Toolkit - vvOut_execSQLtoCSV: Corrected flaw in new vvOut.useBOM logic that was causing the expected byte order mark to not be included in generated CSV file
    • Portal Admin: Corrected issue that could cause large amounts of whitespace to appear at the top of the Apps/Users/Groups grid under certain conditions
    • Installer: Adjusted instance update routine to accommodate newly distributed core apps assigned to deleted groups - such apps will now revert to default group
    • Installer: Adjusted to include file QRPGLESRC2 on installation, which houses non full-free form EXNAB*** source code
    • Fusion5250: Fixed issue with windows not properly overlaying background when the window touches a screen boundary
    • Fusion5250: Fixed field tabbing issue when fields start beyond column 99

    New features and fixes in Valence 6.2.20230526:
    • Nitro App Builder (NAB) - Forms: When form is initially shown and has one or more fields marked as required, adjusted logic to ensure that any buttons set to "Disable when form is in error" are disabled
    • NAB - Forms (mobile): Corrected issue where checkbox values were not being passed to the back-end exit program (per forum post)
    • NAB - Grids: Adjusted so "Disallow Select All" is auto-checked and disabled (so it cannot be unchecked) in Designer when grid is set to infinite scroll, since it's mathematically impossible to 'select all' from infinity
    • NAB - Import: Corrected issue on app import where NAB object cross-reference file info was not being updated with new IDs for Launch App and App Listener actions
    • NAB - Tab Container: Corrected issue where Designer was not allowing more than one tab container in an app under certain conditions
    • NAB - General: Added a new base app variable to optionally turn off the AppBar title
    • NAB - General: Corrected issue where NAB apps set to launch into a new browser window would fail to launch
    • Portal Admin - Apps: Adjusted search filter to be case-insensitive
    • Fusion5250: Fixed issue where auto login would fail when user id was less than three characters

    New features and fixes in Valence 6.2.20230515:
    • Nitro App Builder (NAB) - Popup Windows: Added ability to hide the window close icon via new "Closable" checkbox on popup options
    • NAB - Grids: Added ability to place tool tips on column containers, matching functionality of regular column headers
    • NAB - Tree Grids: Added support for summary information via custom formatters, matching the functionality available in regular grids
    • NAB - Tree Grids: Corrected a timing issue in the tree load that could sometimes cause NAB Designer to become unresponsive
    • NAB - Tree Grids: Corrected issue introduced in 6.2 Beta where summary for level 1 in selected column section was missing
    • NAB - Tree Grids: Corrected issue where changing the label on a column container was not possible
    • NAB - Buttons: Corrected issue where buttons attached to widgets and set to top toolbar/position left were actually positioning to the right when widget had a title
    • NAB - URL Widget: Added new setting to insert cache buster when loading (per forum post)
    • NAB - URL Widget: Adjusted link URL to support app variables
    • vvUtility_addCache: Adjusted to accommodate rare occasion where two CGI jobs are attempting to cache the same item at the same time
    • Fusion5250: Fixed bug with decoding whether function key roles are CAXX (command attention) or CFXX (command function) on certain screens where many CAXX keys are defined

    New Features in 6.2.20230428 (BETA) since the last version of 6.1:
    • Nitro App Builder (NAB) - Tree grid: Added ability to place columns into a column container, similar to what can already be done in Grids and Edit Grids (per forum post)
    • NAB - Edit Grid: Adjusted in-line cell editing so that when a field is in error it will no longer undo changes after tabbing or clicking elsewhere; User must now either fix the issue or hit ESC (per forum post)
    • NAB - Grids: When paging is active, app variables linked to Refresh will now accept "firstPage" to move the grid back to page one
    • NAB - Forms: Added new "Non Editable Field Background" checkbox to control whether or not display-only field values will have a slight background for better contrast
    • NAB - Forms: Added new "slim view" UI option to allow for a more compact collection of fields (similar to "slim view" option on grids)
    • NAB - Forms: Added new option for bold field labels
    • NAB - Forms: Added new top-level "Number of columns" spanning property, allowing for greater control of left-to-right items, including fieldsets
    • NAB - Forms: Added regex edit-checking option for editable fields that are not a textarea or linked to a combobox, checkbox or lookup
    • NAB - Forms: Now shows column/field description where available
    • NAB - Forms: Added new option for text/number fields to show a "clear" icon that can be executed to blank out the value
    • NAB - Forms: Added option to ignore "Set Value" linkages that would otherwise override the data source values on form fields
    • NAB - Forms: Adjusted UI for buttons that are placed next to a form field so that they match the height of the accompanying field
    • NAB - Tab container/tab panel: Added new utility widget for creating tab panels (formerly a 6.1 Beta feature)
    • NAB - Data Sources: Added support for TRY_CAST expression
    • NAB - Data Sources: Added new global and environment-level member override option, applies whenever a data source references a multi-member file that has not been overridden to a specific member. Global default is *FIRST.
    • NAB - Data Sources: Improved logic for detecting summary functions within fields, for better determining when and how edit grid widgets can be applied
    • NAB - Data Sources: Improved logic for distinguishing when distinct keyword is being applied at main statement level or at column level
    • NAB - Data Sources: Adjusted Designer to show long column names (in lieu of system names) in the column selection panel whenever long column names exist
    • NAB - Behaviors: Added new "section hide/show" behaviors that can be executed whenever a section is hidden or shown (formerly a 6.1 Beta feature)
    • NAB - Behaviors: Added two new actions for easier navigation control: "Show section" and its corollary "Show previous section" (formerly a Beta feature)
    • NAB - App Variables: Improved manner in which app variable links are handled so a single app variable can be used on multiple linkages without causing any issues
    • NAB - App Variables: When setting filter field values via app variables, values are now applied even if the underlying widget containing the filter fields is hidden (per forum post)
    • NAB - Exit Programs: Added an optional timeout field that can be applied on the startup program call
    • NAB - Example Programs: Multiple new example programs created; back-end exit programs and templates are now in full free-format
    • NAB - General: When saving an app for the first time in Designer, the save prompt now includes icon, icon color and tool tip
    • NAB - Examples: Removed old obsolete NAB examples and added three new examples: "All Widgets", "Orders" and "Sales Dashboard"
    • Portal - login: Added optional days interval option for two-factor authentication (days must be entered in Portal Admin > Settings > Login Method)
    • Portal Launchpad: App tooltips (descriptions) will now show for users on hover when activated in Portal Admin > Settings > Portal Appearance > "Show tooltips on apps"
    • Portal Admin - Apps: Added description and appID to global search
    • Portal Admin - Logs: Post and response fields expanded to 32K each to mitigate truncation of text
    • Portal Admin - Logs: App variables in NAB calls are now auto-decoded from hex into human-readable form
    • VVIMPORT: NAB objects are now matched for replacement based solely on object creation timestamp if a timestamp + name match is not found
    • Active Sessions: Added column showing comma-delimited list of apps currently in use for each session
    • RPG Toolkit - Added new procedures vvUtility_httpOption, vvUtility_httpHeader, vvUtility_httpGet and vvUtility_httpPost
    • RPG Toolkit - vvOut_execSQLtoCSV and execSQLtoSS: added new “useBOM” parameter to indicate a byte order mark should be encoded into the start of the file
    • Instance Manager: Adjusted to prohibit applying an update from an instance that is not on the same release as the base instance

    Fixes in 6.2.20230428 (BETA) since the last version of 6.1:
    • Portal - login: Corrected issue where, under certain conditions, user/password specified in the login URL was being ignored
    • Portal - login: Corrected issue where, under certain conditions, load mask was not being turned off when forcePrompt=true specified in URL
    • NAB - Edit Grids: Corrected issue where copy option was disabled when it shouldn't have been on grids having one or more columns configured to support "add" mode
    • NAB - Edit Grids: Corrected issue where the setting for "allow delete" could get dropped under certain circumstances when the underlying data source included multiple tables
    • NAB - Edit grids: Corrected issue where a grid specified as using local data was not sending all records (via Call RPG Program) if a filter was applied
    • NAB - Forms: Corrected issue where lookup was not honoring "readOnly" property set via app variable linkage
    • NAB - Forms: Adjusted so that large forms with vertical scrolling now automatically move back to the top when new data is loaded
    • NAB: Forms - Improved manner in which pending combobox load counts are incremented/decremented, correcting an issue that could sometimes cause form to not drop its load mask
    • NAB - Charts: Corrected issue where linking an app variable to transform to area chart was not working
    • NAB - Data Sources: Adjusted SQL parser to prohibit more than 500 columns from being selected, as doing so would exceed work field size limitations, resulting in truncated data.
    • NAB - Data Sources: Corrected issue where SQL parser was dropping double quotes on aliases to expressions (per forum post)
    • NAB - Data Sources: Corrected issue where using a long table name (rather than the file's system name) would cause columns to be treated as non-editable in an edit grid
    • NAB - Data Sources: Retired option to auto-convert a wizard-based data source to SQL, due to conflicts with column naming conventions. As an alternative, you can view the SQL behind any wizard-based data source in the Preview panel (via the SQL button), then copy/paste that into a new SQL-based data source.
    • NAB - Tab Panel Utility: Corrected issue where a pivot grid located inside a tab would not show any data upon switching to its tab
    • NAB - Behaviors: Corrected issue in Designer where option to change a button's size would no longer show after button was set as a menu
    • NAB - Exit Programs: Corrected issue where front-end was ignoring any updated app variables, features or fireevents specified in the validation program on the deletion of a record from an edit grid
    • NAB - General: Corrected issue where App Variable Usage in Designer was not showing app variables being used as a condition on an icon column, row menu button or grid checkbox (per forum post)
    • NAB - General: The "getSettings" routine called on app launch has been adjusted so that the QSZRTVPR API used to determine IBM i OS level is called only once per job, rather than on each getSettings invocation
    Last edited by robert.swanson; 03-25-2024, 07:53 AM.

  • #2
    Valence for IBM i 6.2.20230428 BETA now available. Download at https://www.cnxcorp.com/downloads.

    IMPORTANT!:

    This version is a "beta" release of Valence 6.2 for both new installs and updates to existing versions of Valence 6.X and is compatible with systems running IBM i 7.2 through 7.5. Since Valence 6.2 is still in its beta phase, please only use this version in development and QA environments, and avoid implementing it in production environments for now. The beta designation should be removed from Valence 6.2 in approximately one week. Once the beta period has passed we will notify you about the official release of Valence 6.2 for production use. Your feedback during this beta phase would be appreciated. If you encounter any issues, please do not hesitate to reach out to our support team at support@cnxcorp.com or post on our forum. Your input will help us make Valence 6.2 the best possible version for all our customers.


    Note Regarding Instance Manager:

    Once you have installed Valence 6.2 to your "base" VALENCE6 instance, you must only use Instance Manager from the base instance to manage all Valence instances on a particular system/partition. This is important since you must be running the latest Instance Manager code for it to manage the instances properly.


    Licensing:

    If you are updating a Valence 6.0 or 6.1 instance to 6.2, and you already have a valid license key installed, your key should update automatically for Valence 6.2 upon installation. However, in some circumstances you may need to obtain a new 6.2 key from CNX. Be sure to obtain a valid Valence 6.2 key prior to updating any production instances to Valence 6.2. Email support@cnxcorp.com to obtain a new license key if you need one.

    If you are installing Valence 6.X to an IBM i system or partition for the first time, Valence should operate automatically with a 30-day trial key. To have your trial key extended please email support@cnxcorp.com.

    By obtaining and using the Valence Framework, it is your responsibility to ensure that you and your company are following the proper licensing terms of the product. Be sure to review the licensing options on the Valence Pricing page and also review the Licensing and Support FAQs page before downloading and using the Valence Framework.


    Installing This Release:
    • If you already have an earlier version of Valence 6.X installed, the Valence 6.2 installer will automatically upgrade your Valence 6.X base instance to Valence 6.2 in place. There is no need to run the VVMIGRATE utility as in prior major upgrades. Once your base instance is upgraded to Valence 6.2 you can then use the Instance Manager app in the base instance to update other instances as usual.
    • Go to the downloads page to see what releases are available. If this release is superseded by another release it may no longer be available.
    • If this release is available for download, click the link to download the installation app. Be sure to download the correct version of the installer for your PC operating system and for your IBM i OS (Valence 6.2 is compatible with 7.2, 7.3, 7.4 and 7.5). For sites running on earlier operating systems you can see if older Valence versions are still available on the download page. If you need assistance with finding a Valence installer compatible with your operating system contact CNX to discuss alternative installation options.
    • Follow the prompts to install Valence Framework 6.2 onto your IBM i. Note that you may need administrative rights on your PC or Mac to launch the installer.
    • It is highly recommended that you use QSECOFR to perform the installation to avoid permissions issues.
    • If you are installing Valence 6.X for the first time, this release will create library VALENCE6 and ifs path /valence-6. It will also create an Apache server instance named VALENCE6. If you are updating a prior 6.X installation, then these resources will be updated accordingly.
    • If you have Valence Framework versions 5.2+ or prior installed on your system, installing this release will not affect those earlier versions.
    • Once Valence 6.2 is installed you can access the Valence Portal with the link http://xxx.xxx.xxx.xxx:7060 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7060 is the default installation port for all Valence 6.X versions.
    • It is recommended to log in with a security administrator IBM i user profile (like QSECOFR or a profile with similar authority) when first logging into Valence 6.2 to check operation. You can also access most administrative functions in Valence by logging in with user vvadmin, password vvadmin (this should be changed after installation). You may also try to log in with any valid IBM i profile.
    • If using the vvadmin profile, it is highly recommended that you go into the Portal Admin app in the Valence Portal and add an IBM i user cross reference to vvadmin with security officer authority (like QSECOFR) so you will not have permissions issues.

    New Features in 6.2.20230428 (BETA) since the last version of 6.1:
    • NAB - Tree grid: Added ability to place columns into a column container, similar to what can already be done in Grids and Edit Grids (per forum post)
    • NAB - Edit Grid: Adjusted in-line cell editing so that when a field is in error it will no longer undo changes after tabbing or clicking elsewhere; User must now either fix the issue or hit ESC (per forum post)
    • NAB - Grids: When paging is active, app variables linked to Refresh will now accept "firstPage" to move the grid back to page one
    • NAB - Forms: Added new "Non Editable Field Background" checkbox to control whether or not display-only field values will have a slight background for better contrast
    • NAB - Forms: Added new "slim view" UI option to allow for a more compact collection of fields (similar to "slim view" option on grids)
    • NAB - Forms: Added new option for bold field labels
    • NAB - Forms: Added new top-level "Number of columns" spanning property, allowing for greater control of left-to-right items, including fieldsets
    • NAB - Forms: Added regex edit-checking option for editable fields that are not a textarea or linked to a combobox, checkbox or lookup
    • NAB - Forms: Now shows column/field description where available
    • NAB - Forms: Added new option for text/number fields to show a "clear" icon that can be executed to blank out the value
    • NAB - Forms: Added option to ignore "Set Value" linkages that would otherwise override the data source values on form fields
    • NAB - Forms: Adjusted UI for buttons that are placed next to a form field so that they match the height of the accompanying field
    • NAB - Tab container/tab panel: Added new utility widget for creating tab panels (formerly a 6.1 Beta feature)
    • NAB - Data Sources: Added support for TRY_CAST expression
    • NAB - Data Sources: Added new global and environment-level member override option, applies whenever a data source references a multi-member file that has not been overridden to a specific member. Global default is *FIRST.
    • NAB - Data Sources: Improved logic for detecting summary functions within fields, for better determining when and how edit grid widgets can be applied
    • NAB - Data Sources: Improved logic for distinguishing when distinct keyword is being applied at main statement level or at column level
    • NAB - Data Sources: Adjusted Designer to show long column names (in lieu of system names) in the column selection panel whenever long column names exist
    • NAB - Behaviors: Added new "section hide/show" behaviors that can be executed whenever a section is hidden or shown (formerly a 6.1 Beta feature)
    • NAB - Behaviors: Added two new actions for easier navigation control: "Show section" and its corollary "Show previous section" (formerly a Beta feature)
    • NAB - App Variables: Improved manner in which app variable links are handled so a single app variable can be used on multiple linkages without causing any issues
    • NAB - App Variables: When setting filter field values via app variables, values are now applied even if the underlying widget containing the filter fields is hidden (per forum post)
    • NAB - Exit Programs: Added an optional timeout field that can be applied on the startup program call
    • NAB - Example Programs: Multiple new example programs created; back-end exit programs and templates are now in full free-format
    • NAB - General: When saving an app for the first time in Designer, the save prompt now includes icon, icon color and tool tip
    • NAB - Examples: Removed old obsolete NAB examples and added three new examples: "All Widgets", "Orders" and "Sales Dashboard"
    • Portal - login: Added optional days interval option for two-factor authentication (days must be entered in Portal Admin > Settings > Login Method)
    • Portal Launchpad: App tooltips (descriptions) will now show for users on hover when activated in Portal Admin > Settings > Portal Appearance > "Show tooltips on apps"
    • Portal Admin - Apps: Added description and appID to global search
    • Portal Admin - Logs: Post and response fields expanded to 32K each to mitigate truncation of text
    • Portal Admin - Logs: App variables in NAB calls are now auto-decoded from hex into human-readable form
    • VVIMPORT: NAB objects are now matched for replacement based solely on object creation timestamp if a timestamp + name match is not found
    • Active Sessions: Added column showing comma-delimited list of apps currently in use for each session
    • RPG Toolkit - Added new procedures vvUtility_httpOption, vvUtility_httpHeader, vvUtility_httpGet and vvUtility_httpPost
    • RPG Toolkit - vvOut_execSQLtoCSV and execSQLtoSS: added new “useBOM” parameter to indicate a byte order mark should be encoded into the start of the file
    • Instance Manager: Adjusted to prohibit applying an update from an instance that is not on the same release as the base instance

    Fixes in 6.2.20230428 (BETA) since the last version of 6.1:
    • Portal - login: Corrected issue where, under certain conditions, user/password specified in the login URL was being ignored
    • Portal - login: Corrected issue where, under certain conditions, load mask was not being turned off when forcePrompt=true specified in URL
    • NAB - Edit Grids: Corrected issue where copy option was disabled when it shouldn't have been on grids having one or more columns configured to support "add" mode
    • NAB - Edit Grids: Corrected issue where the setting for "allow delete" could get dropped under certain circumstances when the underlying data source included multiple tables
    • NAB - Edit grids: Corrected issue where a grid specified as using local data was not sending all records (via Call RPG Program) if a filter was applied
    • NAB - Forms: Corrected issue where lookup was not honoring "readOnly" property set via app variable linkage
    • NAB - Forms: Adjusted so that large forms with vertical scrolling now automatically move back to the top when new data is loaded
    • NAB: Forms - Improved manner in which pending combobox load counts are incremented/decremented, correcting an issue that could sometimes cause form to not drop its load mask
    • NAB - Charts: Corrected issue where linking an app variable to transform to area chart was not working
    • NAB - Data Sources: Adjusted SQL parser to prohibit more than 500 columns from being selected, as doing so would exceed work field size limitations, resulting in truncated data.
    • NAB - Data Sources: Corrected issue where SQL parser was dropping double quotes on aliases to expressions (per forum post)
    • NAB - Data Sources: Corrected issue where using a long table name (rather than the file's system name) would cause columns to be treated as non-editable in an edit grid
    • NAB - Data Sources: Retired option to auto-convert a wizard-based data source to SQL, due to conflicts with column naming conventions. As an alternative, you can view the SQL behind any wizard-based data source in the Preview panel (via the SQL button), then copy/paste that into a new SQL-based data source.
    • NAB - Tab Panel Utility: Corrected issue where a pivot grid located inside a tab would not show any data upon switching to its tab
    • NAB - Behaviors: Corrected issue in Designer where option to change a button's size would no longer show after button was set as a menu
    • NAB - Exit Programs: Corrected issue where front-end was ignoring any updated app variables, features or fireevents specified in the validation program on the deletion of a record from an edit grid
    • NAB - General: Corrected issue where App Variable Usage in Designer was not showing app variables being used as a condition on an icon column, row menu button or grid checkbox (per forum post)
    • NAB - General: The "getSettings" routine called on app launch has been adjusted so that the QSZRTVPR API used to determine IBM i OS level is called only once per job, rather than on each getSettings invocation
    Last edited by robert.swanson; 05-03-2023, 10:55 AM.

    Comment


    • #3
      Valence Framework 6.2.20230515 is now available. This is the first release of Valence 6.2 approved for production environments. Changes and fixes in this build since the previous beta release are:
      • NAB - Popup Windows: Added ability to hide the window close icon via new "Closable" checkbox on popup options
      • NAB - Grids: Added ability to place tool tips on column containers, matching functionality of regular column headers
      • NAB - Tree Grids: Added support for summary information via custom formatters, matching the functionality available in regular grids
      • NAB - Tree Grids: Corrected a timing issue in the tree load that could sometimes cause NAB Designer to become unresponsive
      • NAB - Tree Grids: Corrected issue introduced in 6.2 Beta where summary for level 1 in selected column section was missing
      • NAB - Tree Grids: Corrected issue where changing the label on a column container was not possible
      • NAB - Buttons: Corrected issue where buttons attached to widgets and set to top toolbar/position left were actually positioning to the right when widget had a title
      • NAB - URL Widget: Added new setting to insert cache buster when loading (per forum post)
      • NAB - URL Widget: Adjusted link URL to support app variables
      • vvUtility_addCache: Adjusted to accommodate rare occasion where two CGI jobs are attempting to cache the same item at the same time
      • Fusion5250: Fixed bug with decoding whether function key roles are CAXX (command attention) or CFXX (command function) on certain screens where many CAXX keys are defined
      Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

      Go to https://forums.cnxcorp.com/node/16398 for full release notes.
      Last edited by richard.milone; 03-14-2024, 09:48 PM.

      Comment


      • #4
        Valence Framework 6.2.20230526 is now available. Changes in this build since the previous release are:
        • NAB - Forms: When form is initially shown and has one or more fields marked as required, adjusted logic to ensure that any buttons set to "Disable when form is in error" are disabled
        • NAB - Forms (mobile): Corrected issue where checkbox values were not being passed to the back-end exit program (per forum post)
        • NAB - Grids: Adjusted so "Disallow Select All" is auto-checked and disabled (so it cannot be unchecked) in Designer when grid is set to infinite scroll, since it's mathematically impossible to 'select all' from infinity
        • NAB - Import: Corrected issue on app import where NAB object cross-reference file info was not being updated with new IDs for Launch App and App Listener actions
        • NAB - Tab Container: Corrected issue where Designer was not allowing more than one tab container in an app under certain conditions
        • NAB - General: Added a new base app variable to optionally turn off the AppBar title
        • NAB - General: Corrected issue where NAB apps set to launch into a new browser window would fail to launch
        • Portal Admin - Apps: Adjusted search filter to be case-insensitive
        • Fusion5250: Fixed issue where auto login would fail when user id was less than three characters
        Go to https://www.cnxcorp.com/downloads to download Valence 6.

        Go to https://forums.cnxcorp.com/node/16398 for full release notes.
        Last edited by richard.milone; 03-14-2024, 09:49 PM.

        Comment


        • #5
          Valence Framework 6.2.20230630 is now available. Changes in this build since the previous release are:
          • Nitro App Builder (NAB) - Charts: Added option for users to download chart image to a file, and an app variable to set the title of the image (otherwise defers to widget title)
          • NAB - Charts: Added ability to set a rotation angle on chart data points
          • NAB - Charts: Added option for bar and column charts to auto-create a series based on the unique values provided for specified field
          • NAB - Charts: Added option to include a 'total' section for auto-created series
          • NAB - Tree Grids: Added logic to honor expand-all app variable setting when moving between pages
          • NAB - Tree Grids: Corrected issue where unexpected blank space could sometimes show up at the top of the grid (per forum post)
          • NAB - Tree Grids (mobile): Corrected issue where grid could sometimes not show any data
          • NAB - Edit Grids: Corrected issue where a row set to be auto-edited (via an app variable row identifier) was not excluding hidden columns
          • NAB - Edit Grids: Corrected issue in Designer where, under certain conditions, grids with very large numbers of columns would fail to save
          • NAB - Edit Grids: Corrected issue in Designer where selected columns on the Post tab were no longer showing as selected once widget was saved and reopened
          • NAB - Edit Grid: Adjusted back-end to send a pertinent exception message to the front-end on rare occasion where a record update or add fails
          • NAB - Edit Grids: On linked forms, adjusted to automatically omit field group border when all fields inside the group have been hidden (same as regular standalone forms)
          • NAB - Forms: Editable, required fields can now be configured to not validate the field contents upon losing focus ("Defer validation")
          • NAB - Forms: Date fields can now be configured so certain days of the week are non-selectable in the date-picker (i.e., Saturdays and Sundays)
          • NAB - Forms: Date fields can now be configured to disallow selection of dates in the past
          • NAB - Forms: Corrected issue where an app could go into endless loop when form helper program sets a field value via a linked app variable (per forum post)
          • NAB - Forms: Corrected issue where disabled checkboxes were not adhering to the "if checked" / "if not checked" value transformation (per forum post)
          • NAB - Forms (mobile): Corrected issue on forms set to auto-load, where a field linked to an app variable would get reset/cleared when the underlying data source did not return any data (per forum post)
          • NAB - Tilles (mobile): Added space between listed items for better aesthetics (per forum post)
          • NAB - Maps: Corrected issue where map widgets were not rendering properly in mobile
          • NAB - Data Sources: Corrected issue in SQL parser that could cause FETCH FIRST clause to be ignored when specified after a GROUP BY
          • NAB - Info Widget: Added this new utility widget option for showing information without an underlying data source
          • NAB - Import: Adjusted to accommodate change to file VVRMTDB on imports from prior to Valence 6.2
          • NAB - Popup Windows: Changed "height" to "max height" so popup window height will auto-size down to its contents when appropriate. Click on new "Fixed Height" checkbox to force window to retain specified size, regardless of contents.
          • NAB - General: Improved app variable "where used" information to show additional details regarding how it's changed or used, and expanded scope to include all levels of Behaviors where app variable is referenced
          • NAB - General: Added shortcut to launch an app directly from designer by clicking the selector icon adjacent to desired app, then selecting "Launch"
          • NAB - General: Corrected issue where an exceptionally large number of app variables in an app could result in an unlaunchable app. Number of app variables is now unlimited (per forum post)
          • NAB - General: Corrected issue where initial save of an app would ignore the "Mobile" checkbox
          • NAB - General: Corrected issue where configuration settings for more than one popup window could be opened simultaneously
          • RPG Toolkit - vvOut_execSQLtoCSV: Corrected flaw in new vvOut.useBOM logic that was causing the expected byte order mark to not be included in generated CSV file
          • Portal Admin: Corrected issue that could cause large amounts of whitespace to appear at the top of the Apps/Users/Groups grid under certain conditions
          • Installer: Adjusted instance update routine to accommodate newly distributed core apps assigned to deleted groups - such apps will now revert to default group
          • Installer: Adjusted to include file QRPGLESRC2 on installation, which houses non full-free form EXNAB*** source code
          • Fusion5250: Fixed issue with windows not properly overlaying background when the window touches a screen boundary
          • Fusion5250: Fixed field tabbing issue when fields start beyond column 99
          Go to https://www.cnxcorp.com/downloads to download Valence 6.

          Go to https://forums.cnxcorp.com/node/16398 for full release notes.
          Last edited by richard.milone; 03-14-2024, 09:51 PM.

          Comment


          • #6
            Valence Framework 6.2.20230721 is now available. Changes in this build since the previous release are:
            • NAB - Forms: Added new linked app variable for setting all editable fields in the form to Read Only, or for removing Read Only from all editable fields
            • NAB - Forms: Added new linked app variable for programmatically changing field labels
            • NAB - Forms: Added new linked app variable for extracting additional data source record values for combo box selections
            • NAB - Grids: Added ability to pull data source columns and/or app variable values into an icon column tool tip (specified in Behaviors)
            • NAB - Grids: Add new "Clear Search" app variable link to facilitate clearing the global search and any column-specific search values
            • NAB - Grids: Expanded column width for row number to accommodate four digits without truncating (per forum post)
            • NAB - Grids: Corrected issue where an app variable linked to "Collapse All" with an initial value of true was being ignored on initial grid render
            • NAB - Grids: Corrected issue with grid sometimes showing extra white space after a filter was applied (per forum post)
            • NAB - Grid: Corrected issue that would arise on grids with conditional checkbox selections active, where clicking the header-level checkbox would select all rows, including rows where the checkbox was disabled
            • NAB - Edit Grids: Added new configuration option for single-click row or cell editing (as opposed to double click)
            • NAB - Tree Grids: Corrected issue where tree was scrolling to top when expanding a row under certain conditions
            • NAB - Behaviors: Corrected issue where applying a filter to a widget would fail due to unqualified field names in the data source SQL statement (per forum post)
            • NAB - General: Corrected issue in designer where widgets added as popups were treated as fixed height, even though "Fixed height" checkbox is unchecked
            • NAB - General: Corrected issue where creating an app directly from a single widget (via menu option) could result in a non-functional app
            • NAB - General: Corrected issue in Designer that could arise when clicking the link button in utility widgets (URL Widget, Spool File Viewer, and Info Widget), resulting in settings appearing on the left that never go away
            • NAB - General: Corrected issue where popup window height could become null; Adjusted default for popup windows to be a fixed height rather than using the new max height
            • NAB - Import: Adjusted import logic to create VVEXPORT library and/or VVEXPORTS repository file when necessary
            • Portal Admin - Users: Added IBM i user status and default environment to users list
            • Portal (Desktop): Added new keyboard shortcuts for switching between active apps, logging out, locking the session, editing user settings, searching the launchpad, showing the left navigation panel and showing the launch pad. Shortcut keys are listed in the user settings control window, accessed by clicking on the user icon in the upper right. This is a Beta feature.
            Go to https://www.cnxcorp.com/downloads to download Valence 6.

            Go to https://forums.cnxcorp.com/node/16398 for full release notes.
            Last edited by richard.milone; 03-14-2024, 09:53 PM.

            Comment


            • #7
              Valence Framework 6.2.20230808 is now available. Changes in this build since the previous release are:
              • NAB - Tree Grids: Adjusted so when checkbox selection is turned on, 'auto-select children' is active and 'auto-load levels' is not active, widget will now automatically load the children when checking a row, then auto-select its children
              • NAB - Tree Grids: Adjusted cell formatting to only be applied when cell value is not undefined, thereby avoiding (for example) a "$" showing with no subsequent value (per forum post)
              • NAB - Tree Grids: Corrected issue where unexpected whitespace would sometimes appear inside the grid on a reload
              • NAB - URL Widget: Corrected issue where URL Widgets housed within a vertical or horizontal container would not always function properly
              • NAB - Buttons: Adjusted RPG exit program logic to backward-support the use of vvOut_toJsonPair() the same as SetResponse() method
              • NAB - Popup Windows: Corrected issue that could cause windows to not show as expected on app startup
              • NAB - Popup Windows: Adjusted height setting to only show fixed height / max height toggle option when popup contains a form
              • NAB - Forms: Adjusted email validation to recognize longer domain suffixes (per forum post)
              • NAB - KPI Widget: Added auto load option, matching functionality on other widgets
              • NAB - Behaviors: Added a new URL parameter option in Behaviors to fire an event upon starting up the application. The name of the event fired will be the value of the named parameter.
              • NAB - Behaviors: Corrected issue when filtering a widget where it would sometimes ignore filter rules, such as not filtering on blank dates (per forum post)
              • NAB - Import: Corrected issue where attempting to import a NAB app from prior to version 6.0 would throw an API error and fail to import properly
              • NAB - Import: Corrected issue where attempting to import a NAB app from prior to version 6.1 would fail to update the SAVF repository
              • Portal Admin - Users: Corrected issue where attempting to filter the user list would throw an SQL exception
              • Portal: Added a new exit program to be called whenever a user switches environments (available in Portal Admin > Settings > Exit Programs). The EXEXITPGM example template was updated to show how this concept can be put to use.
              • Portal: When an app path includes a substitution value coming from a back-end call, adjusted logic such that the substitution now occurs every time app is launched, rather than reusing (caching) the value obtained on the app's initial launch
              Go to https://www.cnxcorp.com/downloads to download Valence 6.

              Go to https://forums.cnxcorp.com/node/16398 for full release notes.
              Last edited by richard.milone; 03-14-2024, 09:50 PM.

              Comment


              • #8
                Valence 6.2.20230927 for IBM i is now available. Changes in this build since the previous release are:
                • NAB - Grids: Adjusted logic to check for an already set focusRow or focusRowRRN value after loading, and act accordingly (previously the focus action would only take place when a change was detected in either of these values)
                • NAB - Grids: Corrected issue where "include hidden columns" on .csv download was not working properly (per forum post)
                • NAB - Forms: Corrected issues causing "Refresh & Primary" to no longer function properly (per forum post)
                • NAB - Forms (mobile): Adjusted UI so fields with a validation type of "Phone" will present user with a phone keyboard rather than a standard keyboard
                • NAB - Forms: Adjusted to allow input formats on editable numeric fields (e.g., currency, phone numbers)
                • NAB - Forms: Corrected issue with date/time picker that was causing the component to not focus properly, and adjusted location of the error message (per forum post)
                • NAB - Maps: Added ability to set marker color and adjust based on underlying data source
                • NAB - Calendar: Corrected issue where displayed time could be incorrectly offset by an hour
                • NAB - Popup Windows: Corrected issue where certain theme overrides could cause buttons to be nearly invisible (per forum post)
                • NAB - Behaviors: Added ability in Launch App to launch the app into an existing URL Widget
                • NAB - Behaviors: Adjusted to fire the "When Shown" event for the Main section upon app launch
                • NAB - Charts: Corrected issue where 'rotate text' would sometimes not be applied
                • NAB - Data Sources: Adjusted to accommodate longer column names (previously truncated after 30 characters)
                • NAB - Button Exit Program: Added GetFormNull procedure, used for determining if field value passed is null.
                • NAB - Mobile: Corrected issue specific to Android where app would behave as if it were running in a tablet when it was actually a phone (per forum post)
                • NAB - General: Added ability at the app level to show navigation breadcrumbs
                • NAB - General: Corrected issue where a widget subtitle would occasionally not appear when set via an app variable
                • All Widgets Example app: Adjusted calendar widget to pull last user login information, rather than active session records
                • VVMAIL: Added new vvMail_validateEmailAddr() procedure to validate the domain on an email address (returns *on if valid, *off if not), with an optional parameter to call an external API (BriteVerify) for full address validation
                • RPG Toolkit - vvOut_execSQLtoJSON: Corrected issue where total count could be incorrect on statements containing a Group By clause
                • RPG Toolkit - vvUtility_replaceSubs: Adjusted to check for session variables prior to looking for Valence settings
                • RPG Toolkit - vvUtility_initJava: Adjusted to only execute once per job, rather than on each invocation of a Java routine
                • Portal - LDAP authentication: Corrected issue that was preventing authentication error messages from being conveyed to the front-end
                • iAdmin - Job Queues: Corrected issue in desktop app preventing list of jobs from scrolling beyond the initial page
                Go to https://www.cnxcorp.com/downloads to download Valence 6.

                Go to https://forums.cnxcorp.com/node/16398 for full release notes.
                Last edited by richard.milone; 03-14-2024, 09:52 PM.

                Comment


                • #9
                  Valence 6.2.20231026 for IBM i is now available. Changes in this build since the previous release are:
                  • Nitro App Builder (NAB) - Grids: Added ability to change column container labels (super columns) via an app variable, similar to how regular column headings can be changed (per forum post)
                  • NAB - Grids: Added a new app variable to pull the total count for grids with paging enabled (per forum post)
                  • NAB - Grids: Corrected issue where extra whitespace would sometimes show upon scrolling when one or more columns are locked
                  • NAB - Edit Grids: Added option to transform an editable column into a series of radio buttons based on in-line or data source data, similar to an in-line combo box
                  • NAB - Edit Grids: On linked forms, corrected issue where having a field marked as being in error would not prevent proceeding with the update
                  • NAB - Tree Grids: Improved performance by eliminating record count logic when paging is turned off
                  • NAB - Forms: Added new utility field for auto-filling address information based on Google Maps api. Other hidden or visible form fields can then be designated to auto-receive the parsed values (street address, city, state, country, zip code, etc). Note: This feature is not yet available for forms linked to edit grids.
                  • NAB - Forms: Added new utility field for selecting and uploading files from the local machine. Note: This feature is not yet available for forms linked to edit grids.
                  • NAB - Forms: Added option to transform a field into a radio button selection (same as grid)
                  • NAB - Forms: Adjusted numeric fields to not adjust value up or down in conjunction with mouse scroll wheel action
                  • NAB - Forms: Corrected Issue where the Rich Text Editor was not showing on "call RPG Program / prompt for more information" under certain conditions (per forum post)
                  • NAB - Forms: Corrected issue where a button assigned to a field marked in error could move incorrectly
                  • NAB - Forms: Corrected issue where, when a form is used in conjunction with an edit grid, fields marked as required would not show as being required
                  • NAB - Forms: Corrected issue that could throw a console error when a field set to clearable is changed to non-editable
                  • NAB - Forms (Mobile): Corrected issue where an event fired from a back-end RPG helper program was not being executed on the front-end
                  • NAB - Data Sources: Added option in Designer to show system column names in lieu of long names
                  • NAB - Data Sources: Corrected issue where parser was removing alias on a listAgg column under certain conditions (per forum post)
                  • NAB - Data Sources: Corrected issue in Designer where long field names exceeding 30 characters were being truncated
                  • NAB - Data Sources: Corrected issue where column headings were not being decoded in the Designer
                  • NAB - Charts: Added "Suppress minimum value" option to accommodate cases where the value to display is actually zero. When activated, the minimally visible 2 pixel bar will not show on zero values.
                  • NAB - Charts: Corrected issue where "Rotate text" option was not being displayed in Designer under certain conditions
                  • NAB - Behaviors: Corrected issue where "Show Previous Section" could show buttons that should be hidden under certain conditions
                  • NAB - Behaviors: Corrected issue where placing a button into a utility widget would result in a blank screen upon execution
                  • NAB - General: Adjusted back-end logic to accommodate larger collections of widgets/popups/appvars etc. in a single app
                  • NAB - General (Mobile): Corrected issue where date/time picker and combo box drop-down was not working under certain circumstances on a phone, such as when contained inside a popup (per forum post)
                  • NAB - Exit program (form helper): FilterCombo now includes an optional 4th parameter for operator, can be set to one of the following: = (default), <, >, <=, >=, in, notin, like.
                  • NAB - Exit program (button helper): Corrected issue where gSelectionCnt was not being populated when uploading a document (per forum post)
                  • Portal: Added logic to show an exception message whenever an app attempts to launch another app to which the user is not authorized
                  • Portal: Adjusted lock screen to show user ID in a format similar to login screen
                  • RPG Toolkit - vvUtility_isInteractive: Converted into an exported procedure (formerly was "isInteractive" for internal use)
                  • RPG Toolkit - vvUtility_getFieldInfo: Adjusted to use SQL instead of API calls to retrieve file/field details, to better accommodate field names exceeding 30 characters
                  • RPG Toolkit - vvMail_Send: Added additional basic edit checks to email address validation (double @ signs in an address would throw an error in the Java routine)
                  • RPG Toolkit - vvOut_execSQLtoXXX: Adjusted to ignore SQL warnings coming out of user-defined functions (SQLCOD 462), rather than terminating the result set load (applies to NAB data sources as well)
                  • RPG Toolkit - vvOut_execSQLtoCSV: When downloading to IFS, procedure now validates file path before proceeding.
                  Go to https://www.cnxcorp.com/downloads to download Valence 6.

                  Go to https://forums.cnxcorp.com/node/16398 for full release notes.
                  Last edited by richard.milone; 03-14-2024, 09:51 PM.

                  Comment


                  • #10
                    Valence 6.2.20231107 for IBM i is now available. Changes in this build since the previous release are:
                    • NAB - Edit Grids: Added new app variable for applying a value to a specific field on all rows when working with local data
                    • NAB - Edit Grids: Adjusted linked forms to recognize address lookup fields
                    • NAB - Edit Grids: Corrected issue causing 'clear' icon to not show in one field after clearing another field
                    • NAB - Tree Grids: Corrected issue where vvIn_virtual values in a second+ level data source would not be set properly during all-level autoload
                    • NAB - Forms: Added new app variable for retrieving the value of a field
                    • NAB - Forms: Corrected issue where the presence of a Rich Text Editor field might cause an unnecessary vertical scrollbar to appear on the form
                    • NAB - Forms: Corrected issue where cursor would not auto-focus properly if first editable element in the form is a Rich Text Editor field
                    • NAB - Forms: Corrected issue where new address lookup feature would only function properly when inside a popup window
                    • NAB - File Upload: Adjusted to replace values of any parameter segments with a value of "\n" to "\\n"
                    • NAB - General: App variables now allow an expression on their definition or within a "Set App Variable" behavior. The expression may reference other app variables and/or record data.
                    • NAB - General: Added new app variable to optionally hide popup window header
                    • NAB - General: Corrected issue where the "Set to Blank" option in the initial value field was not working properly
                    • NAB - General: Corrected issue where nabFeatureXXX app variables were not saving URL parameters correctly
                    • NAB - Exit Programs: Adjusted button helper to no longer throw an exception message into the log when searching for nonexistent session variables (stems from backward compatibility logic)
                    • Portal Admin - Users: Corrected issue where middle initial was not being saved
                    • RPG Toolkit - vvIn_xxxx: Adjusted to avoid throwing a MSGW condition when procedure call is attempted inside a non-CGI job
                    • RPG Toolkit - vvUtility_getFieldInfo: Corrected issue where decimal values were not being encoded properly (per forum post)
                    • VVBATCH: Adjusted to better handle cases where batch service job (VBCHxxxxxx) has been killed, or activation group has been reclaimed between calls in an interactive setting
                    Go to https://www.cnxcorp.com/downloads to download Valence 6.

                    Go to https://forums.cnxcorp.com/node/16398 for full release notes.
                    Last edited by richard.milone; 03-14-2024, 09:52 PM.

                    Comment


                    • #11
                      Valence 6.2.20231220 for IBM i is now available. Changes in this build since the previous release are:
                      • NAB - Edit Grids: Adjusted UI to remove the toolbar entirely when Add button is hidden via an app variable and no other buttons are present
                      • NAB - Edit Grids: Adjusted so when using local data, calculated columns can now be set to editable
                      • NAB - Edit Grids: Corrected issue that would prevent record adds or edits to data sources pulling from unqualified long table names
                      • NAB - Edit Grids: Corrected issue where a grid column transformed to a lookup and set to "read only" via an app variable was not being set to disabled as expected
                      • NAB - Tree Grids: Corrected issue where app would sometimes remain masked after all levels are loaded
                      • NAB - Grids: Added new property that can be assigned to app variables to track total selection count when checkbox selections are active
                      • NAB - Grids: Added a new configuration option to not save state on stores, meaning changes to the grid sort revert to the default when app is closed and relaunched (per forum post)
                      • NAB - Grids: Adjusted so that nabTotalCount is now updated on grids set to local data (previously only supported non-local data)
                      • NAB - Grids: Corrected issue where checkbox conditions were being ignored if the grid was inside a popup window
                      • NAB - Grids: Corrected issue where an icon column conditioned on anything other than a data source column value would result in a blank grid (per forum post)
                      • NAB - Grids: Corrected issue where a row menu option set to show conditionally could break the grid (per forum post)
                      • NAB - Grids: Corrected issue where a grid containing a column container ("super columns") would ignore the grid's slim view setting
                      • NAB - Grids: Corrected issue where a grid containing locked columns could cause the Designer to crash if column containers are present
                      • NAB - Grids: Adjusted non-legacy Excel download to set column to wrap text when "Wrap Cell" is specified in grid configuration
                      • NAB - Grids: Adjusted non-legacy Excel download to recognize "<br>" in column headers or cells as a line feed
                      • NAB - Grids: Corrected issue where non-legacy Excel downloads were ignoring any before/after text specified in column renderer
                      • NAB - Forms: Added ability to set a field's "required" property based on an app variable
                      • NAB - Forms: Added ability to set a numeric field's minimum value via an app variable
                      • NAB - Forms: Added new "nabActiveFormHelperCnt" variable that is incremented each time a form helper program is called and decremented when program completes. This can be used to disable a "Save" button until all form helper programs have done their thing (i.e., via nabActiveFormHelperCnt === 0 )
                      • NAB - Forms: Added new "hightlightError" app variable (in the General tab). When set to true, the form will automatically scroll up to the first errant field listed and briefly highlight the field to draw attention to it
                      • NAB - Forms: Adjusted the "Reset" linked app variable field list to include non-editable fields
                      • NAB - Forms: Adjusted the "Get Field Value" linked app variables to pull initial values rather than only user-altered values
                      • NAB - Forms: Adjusted radio button logic to show "required" indicator on the field label when applicable
                      • NAB - Forms: Adjusted formatting so that when "suppress zeros" is checked on a field it supersedes any other formatting specified
                      • NAB - Forms: Messages returned from a form helper exit program are now trimmed, as untrimmed messages were imparting a lot of blank space in the response
                      • NAB - Forms: Corrected issue where a form configured to show errors as tooltips would not work properly when errant field(s) were inside a field set
                      • NAB - Forms: Corrected issue where an app variable linked to a combo box would not set the value under certain conditions
                      • NAB - Forms: Corrected issue where back-end helper program "formShow" could send previous values in some circumstances (per forum post)
                      • NAB - Tab Panels: Added ability to disable tabs via an app variable
                      • NAB - Tab Panels: Added ability to set an error indicator on any tab via an app variable
                      • NAB - Tab Panels: Corrected issue where tabActive value was not being set as expected
                      • NAB - Tab Panels: Corrected issue where, under certain conditions, moving a widget could cause the Designer to break
                      • NAB - Tiles: Added new option for horizontal scrolling
                      • NAB - Tiles: Corrected issue where buttons placed on a tile would always go on the bottom, even if "top" was specified in Behaviors. Note: Existing apps that had been showing tile buttons on the bottom will now show them on the top if so configured
                      • NAB - Data Sources: Corrected issue where global member override was not automatically being applied to multi-member files (per forum post)
                      • NAB - Charts: On a multi series chart, corrected issue where a chart reload would cause a previously hidden series to start showing, despite app variable directing it to remain hidden
                      • NAB - Widget Filters: Adjusted to support decimal precision up to the number of decimals in the underlying field. Previously would only support precision to two decimal places (per forum post)
                      • NAB - Widget Filters: Corrected issue where an app variable used to pull a filter value would not work when underlying field was a calculated column
                      • NAB - Widget Filters: Corrected issue where an attempt to set a filter value through an app variable would sometimes not work properly
                      • NAB - Widget Filters: Corrected issue where the loading of a filter would not always unmask the underlying widget
                      • NAB - Import: Corrected issue where a *SAVF imported from another system would sometimes not plug details such as the export instance name and export description in repository file
                      • NAB - Behaviors: In Designer, added a search field in the "Set App Variables" action section. Also added a search field to the main App Variables list.
                      • NAB - Behaviors: Corrected bug where a menu button configured to include an icon would not show the icon when rendered
                      • NAB - Uploads: Corrected issue where an upload attempt could lead to a MSGW under certain circumstances, typically in apps containing many app variables
                      • NAB - General: In Designer (App view), expanded vertical size of the Sections list and shrunk row size so more sections can be seen without having to scroll
                      • NAB - General: Added new "on demand filter" and "enable manual input" options on combo boxes
                      • NAB - General: Added new helper app variable "nabCurrentSection" -- returns name of the currently displayed section
                      • NAB - General: Added option in Designer to save a widget without exiting
                      • NAB - General: Escape key shortcut is now disabled on pop-up windows when the window is configured as non-closable
                      • NAB - General: Corrected issue where adding a widget after altering a section's width could cause Designer to break
                      • NAB - General: Corrected issue that could cause Designer to lock up when saving behaviors. This condition would only arise on apps containing multiple sections, with one or more grid widgets that include icon columns or custom renderers that alter row height
                      • Portal Admin - Settings: Added new "case sensitive" setting for web service URLs
                      • Portal Admin - Settings: Added new "Log QSZRTVPR calls" setting for IBM API tracing
                      • Portal Admin - Users: Adjusted back-end to use the SQL table USER_INFO_BASIC where available (based on IBM i OS level) to improve performance
                      • File Editor: Adjusted edit window to use the default date format specified in Portal Admin > Settings, matching the date format used in the main grid. Previously was always showing dates in *ISO format.
                      • Portal - General: Adjusted VVVPORT to ensure polling and badge exit programs utilize the session library list
                      • Portal - General: When launching applications in a new browser tab, portal now checks "max open" limit on app before proceeding (per forum post)
                      • Fusion5250: Adjusted field background color to extend fully to field edges in order to eliminate black spacing between lines
                      • Fusion5250: Corrected issue with bypass field input (affects DBU)
                      • VVBATCH: Adjusted non-CGI batch processing job to stop throwing unnecessary exception messages into Errors log related to nonexistent REQUEST_METHOD environment variable
                      • VVBATCH: Corrected issue where housekeeping routine to eliminate unused data queues could result in an infinite loop condition
                      • RPG Toolkit - vvIn_****: Adjusted logic surrounding QzhbCgiParse to perform more efficiently on rapid-fire repeat calls
                      • RPG Toolkit - vvUtility_getObjectLibrary: Adjusted to accommodate long table names in addition to system object names
                      • RPG Toolkit - vvUtility_getFieldInfo: Corrected issue that was causing this recently updated routine to return a date format of blank rather than, say, *ISO. This was causing date fields in the File Editor edit window to show as "undefined".
                      • RPG Toolkit - vvIfs_readFile: Corrected issue in READLINE mode that would cause one character from the subsequent line to be included on the response in documents containing two-byte line feeds (CR+LF)
                      Go to https://www.cnxcorp.com/downloads to download Valence 6.

                      Go to https://forums.cnxcorp.com/node/16398 for full release notes.
                      Last edited by richard.milone; 03-14-2024, 09:52 PM.

                      Comment


                      • #12
                        Valence 6.2.20240126 for IBM i is now available. Changes in this build since the previous release are:
                        • NAB - Grids: Added new link-to-app variable 'Summary Values' to allow an app variable to pull in the summary value of a column (per forum post)
                        • NAB - Grids: Corrected issue on grids with grouping activated where the "expand all" action linked to an app variable would sometimes not work properly when first set to 'true'
                        • NAB - Edit Grids: Corrected issue in Designer where sometimes the combo box of form widgets available to link to an edit grid would be hidden when it should be shown, or would show incorrect values
                        • NAB - Tree Grids: Corrected issue where an auto-load-all-levels tree grid containing no second level records would still show the expander toggle
                        • NAB - Tree Grids: Corrected issue in Designer where it was not allowing label text to be changed in "container" columns
                        • NAB - Forms: Added new SetReadOnly() procedure in helper program
                        • NAB - Forms: Adjusted logic to consolidate all combo/radio store loads into one AJAX request, thereby improving load performance
                        • NAB - Forms: Adjusted 'validate as phone number' to not validate the field if set to zero or blank and 'suppress zero value' is checked
                        • NAB - Forms: Corrected issue where app variables linked to "get value" was not working properly for radio buttons
                        • NAB - Forms: Corrected issue in which a helper program would not be called on show if the form was inside a utility widget like vertical container, tab container, etc.
                        • NAB - Tiles: Corrected issue where "bottom" position for buttons was not being saved in Designer
                        • NAB - Tiles: Corrected issue where horizontal scrolling would sometimes cut off the content of the leftmost tile. Also adjusted to ensure vertical scrolling remains functional when needed.
                        • NAB - Tab Container: Added new link-to-app-variable 'currentActiveTab' that will be set to the current active tab's index, starting at 1. Whenever the active tab changes, this linked app variable will change with the corresponding tab's index.
                        • NAB - Info Widget: Corrected issue where sometimes the widget would show despite being hidden via Behaviors
                        • NAB - Filters: Corrected issue where filter fields added against a widget on an older NAB build would, under certain scenarios, not show as selected
                        • NAB - Behaviors: Added ability to dynamically change a button's color via an app variable (per forum post)
                        • NAB - Behaviors: Added new 'nabFireLocalEvent' app variable to facilitate firing a local event (string passed in app variable will be the event fired)
                        • NAB - Behaviors: Corrected issue where a button set to be hidden via an appVar would sometimes show anyway
                        • NAB - General: Added new "Scrolling Container" utility widget
                        • NAB - General: Adjusted rendering logic so that on apps with "Allow Vertical Scroll" activated, widgets with no explicit height will grow to the full height available. Previously NAB was forcing each widget to have an implied fixed height.
                        • NAB - General: Adjusted logic to trim any leading/trailing spaces from tags
                        • NAB - General: Adjusted Designer to ensure all newly specified app variables must start with an alpha character
                        • NAB - General: Corrected issue in Designer where read-only app variables were being shown in the "set app variables list" (via behaviors) that should not be shown. For example, nabCurrentTime.
                        • Portal - Running Apps menu: Adjusted so that the actively running app is highlighted
                        • Portal - Corrected issue when counting total opened apps that are cross-origin (meaning going to a different domain), such as Valence Guides app (per forum post)
                        • RPG Toolkit - vvUtility_getFieldInfo: Adjusted logic to accommodate older versions of IBM i OS 7.3 and 7.4, which was causing "object not found" pop-up messages to appear
                        • Examples App - Send Email: Adjusted to no longer set an overriding auth type by default (previously was *NONE)
                        Go to https://www.cnxcorp.com/downloads to download Valence 6.

                        Go to https://forums.cnxcorp.com/node/16398 for full release notes.
                        Last edited by richard.milone; 03-14-2024, 09:53 PM.

                        Comment


                        • #13
                          Valence 6.2.20240314 for IBM i is now available. Changes in this build since the previous release are:
                          • NAB - Edit Grid: Added ability to set a field to be edited as a text area
                          • NAB - Edit Grid: For cases where a column is transformed to a dropdown, added ability to save the combo display value chosen by the user to a separate column on the grid's data source
                          • NAB - Edit Grid: Corrected issue where a column transformed to a checkbox would not reflect proper checked/unchecked value when using local data
                          • NAB - Pivot Grid: Corrected issue where the set color rule for a column was not properly pulling values from other referenced columns
                          • NAB - Grid: Corrected issue where time formatting applied to a column could cause the remainder of the grid row to not be rendered if time value is not a string (per forum post)
                          • NAB - Grid: Added two helper methods ("setBackgroundColor" and "setTextColor") for use in custom formatters so the cell's background or text color can be adjusted (per forum post)
                          • NAB - Grid: Added new app variable link so that initially hidden grid column(s) can be shown (per forum post)
                          • NAB - Grid: Added new app variable link to disable paging of a widget if standard paging is turned on
                          • NAB - Grid: Corrected issue where overriding a column's label via an app variable would cause the column's tooltip to be dropped (per forum post)
                          • NAB - Forms: Added a new app var link to focus cursor on an editable field (Desktop only)
                          • NAB - Forms: Added option to set fields to the value of an app variable whenever field is reset
                          • NAB - Forms: Input formatter now includes option to add before or after text, similar to what's available on grid formatters. For example, a numeric field that is expressed as a percent would have a percent sign appended to the end of the input value.
                          • NAB - Forms: Corrected issue where, under certain circumstances, a form helper program would not get called as expected when a field value is changed
                          • NAB - Tab Utility Container: Added three new app variable links for tabs to (1) issue a confirmation when exiting a tab, (2) fire an event when activating a tab, and (3) fire an event when exiting a tab (per forum post)
                          • NAB - Tiles: Corrected issue in Designer where, when tile was used in a popup, was not saving off properties for "Selectable" and "Enable and Allow Multiple Selections", as well as any defined buttons in the tile
                          • NAB - Data Sources: SQL parser updated to fully support sub joins
                          • NAB - Data Sources: SQL parser updated to support START WITH / CONNECT BY syntax
                          • NAB - Data Sources: Corrected issue that could unnecessarily cause extra parentheses to be inserted into SQL statements containing sub-queries joined in the FROM clause
                          • NAB - Behaviors: Adjusted Designer so that event listeners are now grouped by app and event name in alphabetical order
                          • NAB - Behaviors: Corrected issue where if application had applications running within itself, global events would not be passed to any nested applications (per forum post)
                          • NAB - General: Added new NAB app variable "nabAppMsgHide" to either hide the App Message (true) or show it if its active (false)
                          • NAB - General: Added new NAB app variable "nabChangeAppName" that can be used to change the name of the running app while in the desktop portal
                          • NAB - General: Added a new widget-level app variable to set focus on a specific filter field
                          • NAB - General: Added new app-level setting to disable auto-focus. When checked, no field or widget will auto-focus; developer must set focus manually (per forum post)
                          • NAB - General: Added check for literals on inline data when transforming to a combo or radio button (literals list is accessed via F4 key in Designer)
                          • NAB - General: In Designer, removed app-level 'allow vertical scroll' since this functionality is now provided through the scrolling container utility widget. For backward compatibility, apps already set to 'allow vertical scroll' will continue to see this setting until unchecked.
                          • NAB - General: In Designer, corrected issue where app variables would not show usage when linked to pop-up widgets
                          • NAB - General: Corrected issue where a combobox using "On Demand Filtering" would issue an SQL error if the underlying data source was created with the data source wizard
                          • File Editor: Corrected issue where a date field would sometimes not show correctly based on format selected in valence base settings (per forum post)
                          • RPG Toolkit - vvOut_execSQLtoJSON (extractRowCount logic): Corrected issue that was causing a "Keyword AS not expected" SQL exception to be thrown into the job log, which would force vvOut to derive the total row count in a less efficient manner. Condition was occurring on SQL statements containing both a WITH clause and a main SELECT clause with one or more aggregate functions.
                          • RPG Toolkit - vvMail_validateEmailAddr: Adjusted installer to ensure all additonal .jar file references needed in classpath are included (specifically, dnsjava-3.5.2.jar and slf4j-api-1.7.36.jar)
                          • RPG Toolkit - EXEXITPGMM (exit program for VVMAIL): Updated VVMAIL data structure to reflect latest incarnation. Not necessary if using copy source to pull in VVMAIL data structure at compile time.
                          • Spool File Viewer: Increased maximum number of output queues supported from 2000 to 4000
                          Go to https://cnxcorp.com/downloads to download Valence 6.

                          Go to https://forums.cnxcorp.com/node/16398 for full release notes.

                          Comment

                          Working...
                          X