Announcement

Collapse
No announcement yet.

Valence 6.1 (All Builds)

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

  • Valence 6.1 (All Builds)

    Versions:

    6.1.20220518, released on May 18, 2022
    6.1.20220425, released on April 25, 2022
    6.1.20220405, released on April 5, 2022
    6.1.20220316, released on March 16, 2022


    Licensing:

    If you are updating a Valence 6.0 instance to 6.1 and you already have a valid 6.0 license key installed, your key should update automatically for Valence 6.1 upon installation. However, in some circumstances you may need to obtain a new 6.1 key from CNX. Be sure to have a valid Valence 6.1 key applied prior to updating any production instances to Valence 6.1. 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 Valence 6.0 installed, the Valence 6.1 installer will automatically upgrade your Valence 6.0 base instance to Valence 6.1 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.1 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.1 is compatible with 7.2, 7.3 and 7.4). For sites running on earlier operating systems you can see if older Valence versions are still available on the download. 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.1 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.1 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.1 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:
    • Instance Manager: Corrected location of VVEXPORTS file object, which should only exist in the VVEXPORT library. The instance update process will correct this.

    New features and fixes in Valence 6.1.20220518:
    • Nitro App Builder (NAB) - Grids: Added new column formatter to show decimal percentage (numbers between 0.00 and 1.00) as a progress bar in the cell
    • NAB - Grids: Added new app variables to optionally focus cursor on a particular row index or RRN
    • NAB - Grids: Adjusted non-legacy Excel downloads to support column containers (aka "Super Column Headings") on generated spreadsheets
    • NAB - Grids: Added ability to override grid column colors at the app level, including via app variables
    • NAB - Grids: Added ability to conditionally set icon colors
    • NAB - Tree Grids: Corrected issue on custom renderers where grid component (fifth parameter) was not being passed
    • NAB - Charts: Corrected issue where setting a column chart to multi-series, with its own axis on the right, would cause chart to crash in Designer
    • NAB - Forms: Adjusted so fields in error that are in a hidden state still call the Form Helper program (EXNABFHLP-based programs)
    • NAB - Filter exit program: Added ability to set app variables and enable/disable filters from EXNABFLT-based programs
    • NAB - Filter exit program: Added logic for getValue to return a comma-separated list when pulling from a filter that supports multiple values (EXNABFLT-based programs)
    • NAB - Horizontal containers: Corrected issue where slider to adjust component widths was not showing in Designer
    • NAB - Tiles: Added ability to conditionally set tile button colors
    • NAB - General: Added a subtitle option to all widgets. Subtitle text may be changed via a new app variable.
    • NAB - General: Added ability to pull (get) user filter values for any widget via app variables
    • NAB - General: Corrected issue where an app variable linked to a URL parameter that was set to hide a button could hide more buttons than intended
    • NAB - General: Corrected issue where moving widgets around in the Designer, with vertical scrolling enabled, could cause display errors
    • NAB - General: Corrected issue where filters over integer columns were limiting user input to approximately half the maximum digits allowed (based on bytes rather than numeric precision)
    • Fusion5250: Added support for programs using graphical Subfile Choice Control (DDS keyword SFLCHCCTL)
    • Instance Manager: Added logic to trap attempts to upgrade any instance from an instance that is at a version below the base instance
    • File Editor: Adjusted filter function to accommodate strings with single quotes
    • Portal Admin - Users: Added paging functionality
    • Portal Admin - Apps: Added "enabled" column to apps grid
    • Portal - Login: Adjusted to allow login via email address (must be activated via new setting in Portal Admin > Settings > Login Method)

    New features and fixes in Valence 6.1.20220425:
    • Nitro App Builder (NAB) - Grids: Added ability to specify action of download/open/print on PDF downloads
    • NAB - Grids: Corrected issue where saved state could inadvertently override the autoload setting
    • NAB - Tree Grids: Adjusted to auto-expand any levels that contain a positive match on a local-search filter
    • NAB - Mobile: Expanded field widths where necessary to accommodate clear icon
    • NAB - Mobile: Corrected issue where apps were not honoring the "Initially Hidden" setting on buttons
    • NAB - Filters: Added ability to reload a user filter combobox via an app variable
    • NAB - Filters: Corrected issue where vvIn_Virtual fields in an underlying data source would not always appear as a filterable column in the widget
    • NAB - Filters: Corrected issue where default value on the "to" side of a Between filter was not always being applied
    • NAB - Filters: Corrected issue where a user filter linked to a vvIn_virtual clause would continue to "stick" after being cleared/blanked by the user
    • NAB - Behaviors: Corrected issue where Enter key listener was not functioning when calling an RPG program and prompting user for additional info
    • NAB - General: Added new "clearAllData" property on widget link to app variables, causing all widget data to be cleared when set to 'true'
    • NAB - General: Corrected issue in Designer where removing a calendar widget in a popup was leaving associated behaviors in the app
    • NAB - General: Corrected issue where saving larger apps, particularly ones with multiple pop-ups, could cause app config to become corrupted
    • NAB - Import: Corrected issue where changes to app icons, colors, etc were not overriding existing apps on import
    • NAB - Exit Programs: Corrected issue where EXNABFLT-based programs were not properly handling "contains" type filters if overriding the filter string
    • Portal Admin - Environments: Corrected issue where adjustments to tags would not appear to save
    • Portal Admin - Users: Improved rendering of users with multiple tags
    • Portal Admin - General: Adjusted back-end to accommodate earlier TRs of IBM i 7.2 and 7.3 that do not support the "listAgg" SQL function
    • Remote DB: Adjusted VVBATCH routine to not leave any open file locks, which could interfere with the update process in Instance Manager

    New features and fixes in Valence 6.1.20220405:
    • Nitro App Builder (NAB): New Calendar widget added to Designer - works with any data source containing a timestamp column. Your IBM i timezone system setting (QTIMZON) must be set correctly to use this widget.
    • NAB - Grids: Added new "HTML encode" column renderer
    • NAB - Grids: Adjusted so row background changes when user hovers over the row
    • NAB - Grids: Adjusted Excel/PDF download to recognize hyperlinks (i.e., defined as "<a href="https://cnxcorp.com">Link</a>") and render them as conventional links in the document
    • NAB - Grids: Improved auto column width calculation for PDF downloads
    • NAB - Grids: Corrected issue where checkboxes were not showing on grids with "Checkbox Row Selections" enabled
    • NAB - Grids: Corrected issue in Designer where "Checkbox Row Selections" options are not visible unless you save and go back in to edit
    • NAB - Grids (Mobile): Corrected issue where if paging and grouping were both activated, paging would not work properly
    • NAB - URL Widget: Fixed issue where close behaviors and buttons were not saving in Designer
    • NAB - Forms: Adjusted so when a tooltip is assigned to a field, a visual indicator now shows in the label so users know the tooltip exists
    • NAB - Behaviors: Corrected issue in Designer where hide/show behaviors could not be deleted
    • NAB - Filters: Corrected issue where an app variable linked to a filter field on an SQL-based data source, that had been previously converted from wizard-based, was not setting properly
    • NAB - Export/Import: Corrected issue where some widgets could be unintentionally excluded on an app export
    • NAB - General: Added exit program option on app close
    • NAB - General: Added support for timestamp(0) on renderers, calendar/timeline widgets and editable form widget fields (.1 build)
    • NAB - General (Mobile): Corrected issue where force uppercase wasn't being applied correctly (.1 build)
    • NAB Import App: Adjusted to work properly with Valence 6.1 (.1 build)
    • Portal Admin - Logs: Minor improvement to SQL statement rendering on "Log Data" tab - formerly truncated lines are now wrapping (.1 build)
    • Portal Admin - Apps: Corrected issue where filtering app list on a category would cause the category to not be available when editing app record
    • File Editor: Adjusted VVUTILITY to reset dependent logical file object definitions whenever the parent physical file is changed. This addresses issue where new fields added to a physical file were being ignored when looking at the logical.
    • VVMIGRATE: Corrected issue that was causing migration process to crash prior to completion


    New features in Valence 6.1.20220316 since final Valence 6.0 build:
    • Nitro App Builder (NAB) - Tree Grids: New widget introduced, acts as a hybrid of both a tree and a grid, fed by multiple data sources
    • NAB - Grids: Added "super column headers" (aka containers) so you can now configure headings that span across the top of multiple columns
    • NAB - Grids: Added app variables for grouped grids so rows can now be expanded/contracted by a back-end RPG program
    • NAB - Grids: In addition to saving a user's column width and arrangement overrides, stored state now also includes the grid's sort sequence
    • NAB - Grids: Moved "Reset Columns" right-click user action to column heading row; Right-clicks on data rows reverts to standard browser behavior
    • NAB - Edit Grids: Fields in the edit window can now be arranged in a sequence that is independent of the main grid columns
    • NAB - Edit Grids: Adjusted styling so selected rows stand out more clearly
    • NAB - Edit Grids: Adjusted row editor so that icon columns are not disabled while fields are open for data editing
    • NAB - User Filters: Added option to "remember" (make stateful) filter entries, so users don't have to re-key filter values on subsequent launch of app
    • NAB - Forms: Added ability to add tool tips to editable fields
    • NAB - Forms: Added ability to specify height on a text area field
    • NAB - Forms: Adjusted popup windows to allow access to all fields in underlying data source, instead of just the ones used in the form widget
    • NAB - Charts: Added a secondary axis option for transformed fields on column charts
    • NAB - Charts: Added series-specific behavior events for multi-series charts
    • NAB - Themes: Added more color options to better align with app icon color choices
    • NAB - Data Sources: Added a new back-end template for pre-execution programs (EXNABDS) that includes a mechanism for pulling in app variables
    • NAB - Data Sources: Free-form SQL parser now supports in-line table definitions in the "from" clause
    • NAB - Data Sources: Any fields in the main SELECT clause that come from WITH clauses (CTEs) can now be referenced on filters
    • NAB - Renderers: Added various time format renderers for grid columns, form fields, etc.
    • NAB - Export/Import: NAB now maintains a repository for all export save files with pertinent export info such as instance name, date, user, notes, etc.
    • NAB - Export/Import: Group membership and in-app authorities are now included on initial import of app
    • NAB - General: Security section functions have been moved to Behaviors, thereby providing a more complete picture of the app's functionality
    • NAB - General: Behavior section (formerly Security) now applies feature names to each widget/section affected by Hide/Show directives, allowing for more refined control
    • NAB - General: Added horizontal container utility widget (similar to existing vertical container), allowing for more intricate widget arrangements
    • NAB - General: Added new runtime app variables (booleans): isDesktop, isMobile, isPhone, isTablet
    • NAB - General: When listing apps, tag filter now applies only to the app-level; All underlying widgets and data sources for an included app are now listed regardless of tag
    • NAB - General: Applied numerous aesthetic improvements in the NAB Designer for widget selection, saving, etc.
    • Fusion5250: Added ability for sessions to detect a communications failure and gracefully attempt to reconnect without restarting the app
    • Spool File Viewer (also iAdmin): Added option to display spool files as PDFs, including support for AFPDS files
    • Portal Admin - Settings: Added password expiration interval for Valence-specific (non-IBM i) users
    • Portal Admin - Settings: Added option to show user's current Valence environment name in Portal header
    • Portal Admin - Apps: Added tag support, mimicking functionality already in place for apps listed in NAB Designer
    • Portal Admin - Apps: Added ability to filter apps by category
    • Portal Admin - Users: Added tags and tag/group/environment filtering
    • Portal Admin - Environments: Added tags and tag filtering
    • Portal Admin - Groups: Added tags and tag/app/user filtering
    • Portal Admin - Web Services: Added tags and tag filtering
    • Portal Admin - Logs: Added a "Log Data" tab to list any log file data for each call, so executed SQL statements will show here when they're being logged. Also improved the formatting of the Post and Response tabs.
    • Portal - Login: Added "eyeball" toggle button in password field so users can optionally see the characters they're typing
    • Portal - General: Added support for IBM i virtual serial numbers
    • Test RPG Call: Added highlighting to the JSON tab for improved readability on RPG program responses
    • Instance Manager: Added ability to make a back-end batch call to VVINSTMGR to update any instance to the latest build
    • 6.1.20220316.1: Problem with Google Maps api key used when Valence is in the trial period fixed

    Fixes applied to 6.1.20220316 since final Valence 6.0 build:
    • Nitro App Builder (NAB) - Behaviors: Corrected issue where Call RPG Program was not working with an event listener
    • NAB - Grids: Corrected issue where sorting over locked columns would not function as expected when multi-sort configuration was activated
    • NAB - Edit Grids (mobile): Miscellaneous pop-up window sizing adjustments and removal of animations from lookup field
    • NAB - Forms: Corrected issue where disabled checkbox fields were not honoring true/false overrides when passed to the back-end
    • NAB - Forms (mobile): Corrected issue where HTML markup was sometimes showing in display fields
    • NAB - Forms (mobile): Corrected issue causing checkboxes to not accept taps
    • NAB - Tiles (mobile): Corrected issue causing scrolling to not function properly
    • NAB - General (mobile): Corrected issue where date picker was not working
    • NAB - General (mobile): Adjusted so that any specified filter width is honored provided it's less than the device's display width
    • Mobile portal - Pop-ups: Corrected issue causing pop-up windows to not render after the first time displayed
    • NAB - General: Fixed issue with date picker
    • NAB - Timeline Widget: Fixed issue where widget would break if you set a group text value from a data source column
    • NAB - General: Fixed issued where in certain cases the relationships between data sources and widgets was not being displayed properly
    • RPG ToolKit - vvOut_execSQLtoJSON: Corrected issue where SQL order by clauses containing special characters would get enclosed in hard brackets. This should only occur when accessing remote databases.
    • RPG ToolKit - vvOut_execSQLtoSS: Corrected issue that would cause an overflow error on larger "legacy" Excel downloads exceeding 999,999 rows
    • Fusion5250: Adjusted to accommodate scenario in which a user's profile becomes disabled/expired after logging into Valence but prior to initiating a Fusion session. This was triggering a MSGW condition.
    • File Editor: Corrected issue where saving a view with more than 99 columns would trigger a MSGW overflow condition
    Last edited by robert.swanson; Today, 12:45 PM.

  • #2
    Valence Framework 6.1.20220405 is now available. Changes in this build since the previous release are:
    • Nitro App Builder (NAB): New Calendar widget added to Designer - works with any data source containing a timestamp column. Your IBM i timezone system setting (QTIMZON) must be set correctly to use this widget.
    • NAB - Grids: Added new "HTML encode" column renderer
    • NAB - Grids: Adjusted so row background changes when user hovers over the row
    • NAB - Grids: Adjusted Excel/PDF download to recognize hyperlinks (i.e., defined as "<a href="https://cnxcorp.com">Link</a>") and render them as conventional links in the document
    • NAB - Grids: Improved auto column width calculation for PDF downloads
    • NAB - Grids: Corrected issue where checkboxes were not showing on grids with "Checkbox Row Selections" enabled
    • NAB - Grids: Corrected issue in Designer where "Checkbox Row Selections" options are not visible unless you save and go back in to edit
    • NAB - Grids (Mobile): Corrected issue where if paging and grouping were both activated, paging would not work properly
    • NAB - URL Widget: Fixed issue where close behaviors and buttons were not saving in Designer
    • NAB - Forms: Adjusted so when a tooltip is assigned to a field, a visual indicator now shows in the label so users know the tooltip exists
    • NAB - Behaviors: Corrected issue in Designer where hide/show behaviors could not be deleted
    • NAB - Filters: Corrected issue where an app variable linked to a filter field on an SQL-based data source, that had been previously converted from wizard-based, was not setting properly
    • NAB - Export/Import: Corrected issue where some widgets could be unintentionally excluded on an app export
    • NAB - General: Added exit program option on app close
    • NAB - General: Added support for timestamp(0) on renderers, calendar/timeline widgets and editable form widget fields (.1 build)
    • NAB - General (Mobile): Corrected issue where force uppercase wasn't being applied correctly (.1 build)
    • NAB Import App: Adjusted to work properly with Valence 6.1 (.1 build)
    • Portal Admin - Logs: Minor improvement to SQL statement rendering on "Log Data" tab - formerly truncated lines are now wrapping (.1 build)
    • Portal Admin - Apps: Corrected issue where filtering app list on a category would cause the category to not be available when editing app record
    • File Editor: Adjusted VVUTILITY to reset dependent logical file object definitions whenever the parent physical file is changed. This addresses issue where new fields added to a physical file were being ignored when looking at the logical.
    • VVMIGRATE: Corrected issue that was causing migration process to crash prior to completion
    Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

    Go to http://forums.cnxcorp.com/node/14769 for full release notes.
    Last edited by robert.swanson; 04-06-2022, 07:19 PM.

    Comment


    • #3
      Valence Framework 6.1.20220425 is now available. Changes in this build since the previous release are:
      • Nitro App Builder (NAB) - Grids: Added ability to specify action of download/open/print on PDF downloads
      • NAB - Grids: Corrected issue where saved state could inadvertently override the autoload setting
      • NAB - Tree Grids: Adjusted to auto-expand any levels that contain a positive match on a local-search filter
      • NAB - Mobile: Expanded field widths where necessary to accommodate clear icon
      • NAB - Mobile: Corrected issue where apps were not honoring the "Initially Hidden" setting on buttons
      • NAB - Filters: Added ability to reload a user filter combobox via an app variable
      • NAB - Filters: Corrected issue where vvIn_Virtual fields in an underlying data source would not always appear as a filterable column in the widget
      • NAB - Filters: Corrected issue where default value on the "to" side of a Between filter was not always being applied
      • NAB - Filters: Corrected issue where a user filter linked to a vvIn_virtual clause would continue to "stick" after being cleared/blanked by the user
      • NAB - Behaviors: Corrected issue where Enter key listener was not functioning when calling an RPG program and prompting user for additional info
      • NAB - General: Added new "clearAllData" property on widget link to app variables, causing all widget data to be cleared when set to 'true'
      • NAB - General: Corrected issue in Designer where removing a calendar widget in a popup was leaving associated behaviors in the app
      • NAB - General: Corrected issue where saving larger apps, particularly ones with multiple pop-ups, could cause app config to become corrupted
      • NAB - Import: Corrected issue where changes to app icons, colors, etc were not overriding existing apps on import
      • NAB - Exit Programs: Corrected issue where EXNABFLT-based programs were not properly handling "contains" type filters if overriding the filter string
      • Portal Admin - Environments: Corrected issue where adjustments to tags would not appear to save
      • Portal Admin - Users: Improved rendering of users with multiple tags
      • Portal Admin - General: Adjusted back-end to accommodate earlier TRs of IBM i 7.2 and 7.3 that do not support the "listAgg" SQL function
      • Remote DB: Adjusted VVBATCH routine to not leave any open file locks, which could interfere with the update process in Instance Manager
      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

      Comment


      • #4

        Valence Framework 6.1.20220518 is now available. Changes in this build since the previous release are:
        • Nitro App Builder (NAB) - Grids: Added new column formatter to show decimal percentage (numbers between 0.00 and 1.00) as a progress bar in the cell
        • NAB - Grids: Added new app variables to optionally focus cursor on a particular row index or RRN
        • NAB - Grids: Adjusted non-legacy Excel downloads to support column containers (aka "Super Column Headings") on generated spreadsheets
        • NAB - Grids: Added ability to override grid column colors at the app level, including via app variables
        • NAB - Grids: Added ability to conditionally set icon colors
        • NAB - Tree Grids: Corrected issue on custom renderers where grid component (fifth parameter) was not being passed
        • NAB - Charts: Corrected issue where setting a column chart to multi-series, with its own axis on the right, would cause chart to crash in Designer
        • NAB - Forms: Adjusted so fields in error that are in a hidden state still call the Form Helper program (EXNABFHLP-based programs)
        • NAB - Filter exit program: Added ability to set app variables and enable/disable filters from EXNABFLT-based programs
        • NAB - Filter exit program: Added logic for getValue to return a comma-separated list when pulling from a filter that supports multiple values (EXNABFLT-based programs)
        • NAB - Horizontal containers: Corrected issue where slider to adjust component widths was not showing in Designer
        • NAB - Tiles: Added ability to conditionally set tile button colors
        • NAB - General: Added a subtitle option to all widgets. Subtitle text may be changed via a new app variable.
        • NAB - General: Added ability to pull (get) user filter values for any widget via app variables
        • NAB - General: Corrected issue where an app variable linked to a URL parameter that was set to hide a button could hide more buttons than intended
        • NAB - General: Corrected issue where moving widgets around in the Designer, with vertical scrolling enabled, could cause display errors
        • NAB - General: Corrected issue where filters over integer columns were limiting user input to approximately half the maximum digits allowed (based on bytes rather than numeric precision)
        • Fusion5250: Added support for programs using graphical Subfile Choice Control (DDS keyword SFLCHCCTL)
        • Instance Manager: Added logic to trap attempts to upgrade any instance from an instance that is at a version below the base instance
        • File Editor: Adjusted filter function to accommodate strings with single quotes
        • Portal Admin - Users: Added paging functionality
        • Portal Admin - Apps: Added "enabled" column to apps grid
        • Portal - Login: Adjusted to allow login via email address (must be activated via new setting in Portal Admin > Settings > Login Method)
        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

        Comment

        Working...
        X