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

    New features and fixes in Valence 6.2.20230927:
    • 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

    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: 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 richard.milone; Yesterday, 10:48 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://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

      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://secure.cnxcorp.com/downloads to download Valence 6.

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

        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://secure.cnxcorp.com/downloads to download Valence 6.

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

          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://secure.cnxcorp.com/downloads to download Valence 6.

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

            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: 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://secure.cnxcorp.com/downloads to download Valence 6.

              Go to http://forums.cnxcorp.com/node/16398 for full release notes.
              Last edited by robert.swanson; 08-08-2023, 11:34 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://secure.cnxcorp.com/downloads to download Valence 6.

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

                Comment

                Working...
                X