Announcement

Collapse
No announcement yet.

Valence 6.0 (All Builds)

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

  • Valence 6.0 (All Builds)

    Versions:

    6.0.20210119, released on January 19, 2021
    6.0.20201222, released on December 22, 2020
    6.0.20201119, released on November 19, 2020
    6.0.20201030, released on October 30, 2020
    6.0.20201002, released on October 2, 2020
    6.0.20200912, released on September 12, 2020
    6.0.20200904 (BETA), released on September 4, 2020
    6.0.20200827 (BETA), released on August 27, 2020
    6.0.20200819 (BETA), released on August 19, 2020
    6.0.20200810 (BETA), released on August 10, 2020


    What's New in Valence 6.0?

    Learn more about changes and new features at https://www.cnxcorp.com/page/valence-6. Existing Valence 4.* and 5.* installations can migrate to Valence 6.0 by following the instructions in the Valence 6 Upgrade Guide. Please contact CNX for a new license key.

    Note that the back-end library name for this release is VALENCE6 rather than VALENCE60. This is to make it easier to upgrade the Valence 6.0 base installation to Valence 6.1, 6.2, etc. in the future, as it will not require a wholly separate instance each time. This is similar to how Valence 5.2 and Valence 5.2+ utilized the same base library name of VALENCE52, a popular approach with existing customers as it significantly simplified the upgrade process. So you can expect that upgrading to new 6.* releases in the years ahead will essentially be no different than applying an intra-release maintenance build.


    Licensing:

    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:
    • 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 then click the link to the download installation file. Be sure to download the correct version of the installer for your PC operating system and for your IBM i OS (7.1 through 7.4). For sites running on V5R4 or V6R1, contact CNX to discuss your options.
    • Unlike previous versions of Valence which were delivered as zip files, the Windows installer is now an exe file, and the Mac installer is now a dmg file. Both types are code signed so they should be trusted when run, and not cause any security issues. To launch the installer just double click on the exe file on your Windows PC, or launch the .dmg file on your Mac. Follow the prompts to install Valence Framework 6 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.
    • This release will install to library VALENCE6 and ifs path /valence-6. It will also install an Apache server instance named VALENCE6.
    • If you have Valence Framework versions 5.2+ and prior installed on your system, installing this release will not affect those earlier versions.
    • Once 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 Valence Framework 6. You can use Advanced Settings to change the port number at installation time.
    • The default user for administrative login to the portal after installation is vvadmin with password vvadmin. However you may also 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.

    Changes Pending for the Next Build:
    • Nitro App Builder (NAB) - Form Widget: Added ability to set a minimum value on numeric fields
    • NAB - Helper Program: Added ability to pull in any application variable via vvIn_virtual() on all runtime calls
    • NAB - Apps: Corrected issue where exported NAB apps containing more than 50 widgets would not import properly.
    • NAB - Apps: Corrected issue that could sometimes cause an application to take an exceedingly long time to save.
    • NAB - Data Sources: Corrected parser issue that could cause an ORDER BY clause to be inadvertently lumped in with a GROUP BY or HAVING clause
    • NAB - Mobile: Corrected rendering issue with popups to properly resize when set to full screen
    • NAB - Mobile: Corrected issue with non-primary form buttons not being set to disabled when the form is invalid
    • NAB - Mobile: Corrected forms to properly handle disable/enable features from the form helper program

    New Features and Fixes in 6.0.20210119:
    • Nitro App Builder (NAB) - Data Sources: Added ability to pull in current user on a data source SQL statement via vvIn_char('vvUser')
    • NAB - Pivot Grid Widget: Added ability to control location of column sub-total and total
    • NAB - Pivot Grid Widget: Added ability to format left & top axis columns
    • NAB - Pivot Grid Widget: Fixed issue where export would not work while configuring the widget
    • NAB - Pivot Grid Widget: Fixed issue where the user configuration panel wasn't correctly showing top axis columns
    • NAB - Pivot Grid Widget: Fixed issue where aggregate shows as blank instead of zero when top axis is active and "Show Zero As Blank" is unchecked
    • NAB - Grid Widget: Removed hide/show option on menu and icon columns
    • NAB - Chart Widgets: Added ability to have multi line chart labels via the HTML line break element tag <br>
    • NAB - Chart Widgets: Adjusted to match sort sequence of Valence 5.2 charts
    • NAB - Chart Widgets: Added ability to download to excel for all charts excluding gauge
    • NAB - Line Chart Widget: Added "stepped" option
    • NAB - Column Chart Widget: Added ability to transform any additional series to a line or area
    • NAB - Widget Filters: Fixed default value max length when the column is numeric
    • NAB - Widget Filters: Fixed issue when transforming to a lookup over date columns
    • NAB - Form Widget: Adjusted mobile to support HTML markup in fields
    • NAB - SQL Data Sources: Fixed parsing issue when using cross join lateral table function with a UDF
    • Portal Admin - Users: Added ability to set or change user's default environment at next login
    • Fusion5250: Added support for graphical pushbuttons
    • Fusion5250: Added basic support for graphical scrollbar area on subfiles (will be further refined in a subsequent release)
    • Desktop Portal: Fixed issue with showing/hiding split screen when entering/exiting fullscreen mode via the browser
    • Desktop Portal: Adjusted to hide language options when multilingual feature is turned off in Portal Admin > Settings
    • Desktop Portal: Added ability to exit split screen mode by hitting the escape key
    • RPG Toolkit - vvIn_sorters: Corrected issue where JSON pointer exception would be thrown into job log unnecessarily
    • RPG Toolkit - vvOut_execSQLtoJSON: Corrected issue where an SQL statement containing VVIN_CHAR() could fail to return a correct result set count. This would affect NAB data sources too.
    • RPG Toolkit - error handler: Adjusted exit program call to support EXEXITPGM template, passing an exit mode of "ERROR_HANDLER"
    • VVMIGRATE - Corrected issue where active web service consumers were not migrating to new instance

    New Features and Fixes in 6.0.20201222:
    • Nitro App Builder (NAB) - Grid Widget: Added option to limit PDF or Excel download to selected rows only
    • NAB - Grid Widget: Added new feature to allow for overriding columns on Excel and/or PDF downloads
    • NAB - Grid Widget: Added ability to hide/show grid columns via app variables
    • NAB - Grid Widget: Corrected issue with app variable-based grid column hide/show not working if column name contains special character
    • NAB - Grid Widget (Mobile): Corrected issue that would prevent app from starting if grid had checkbox selection enabled
    • NAB - Edit Grid Widget: Added ability to auto-edit row based off RRN or row index
    • NAB - Charts: allow adjustment of font size/style on the series title, label title and legend text
    • NAB - Charts: Fixed issue where charts were not displaying series and/or label titles
    • NAB - Timeline Widget: Fixed issue that could throw a console error when applying a filter
    • NAB - RPG backend: Adjusted NAB template programs to send back true boolean values when calling SetAppVar
    • NAB - Startup behaviors: Corrected issue with feature ids not saving properly for any Startup actions
    • Instance Manager: Adjusted to restore DSPF/PRTF objects and core source code files in updated instances
    • Nitro iAdmin: Corrected issue where a user with insufficient authority would not see correlating error message
    • Portal: Added pound sign (#) to list of acceptable special characters for Valence password rules
    • Portal exit programs: Corrected the "app initialization" exit program to pass an vvExitMode value of 'VVCALL_INIT' instead of 'VVCALL0'
    • RPG Toolkit - error handler: Added option to call an exit program (new column in VVERRHNDLR). Watch for a future blog post on this.

    New Features and Fixes in 6.0.20201119:
    • General: Corrected issue where fieldset titles were no longer showing properly due to a recent Chrome update (.1 build)
    • Nitro App Builder (NAB) - Form widget: Adjusted to pass widgetId on any calls to form helper RPG program
    • NAB - Form widget: Adjusted to pass all fields from the underlying data source record to the form helper program, including fields that are not in the form
    • NAB - Form widget: Corrected issue where form field error messages sent by EXNABBTN template programs were not being properly decoded on mobile (.1 build)
    • NAB - Grid widget: Fixed bug where grid button calling RPG program would not function if "allow copy row data" was activated
    • NAB - Grid widget: Corrected issue where grand total summary row was not showing when field grouping activated (.1 build)
    • NAB - Edit grid widget: Corrected issue where inline editing (i.e., max length and decimal positions) was not being enforced
    • NAB - Chart widget: Corrected issue in builder mode where filters may incorrectly refresh
    • NAB - Filters section: Corrected issue in builder mode where filter loses its search results after selecting a field for filtering
    • NAB: Adjusted call RPG program logic to encode array params (i.e., on combo box multi select)
    • NAB: Adjusted all combo boxes to employ a "contains" search rather than a "starts with" search
    • NAB: when adding/copying/deleting a record within an edit grid, ensure that the page reload remains at the same page if applicable.
    • NAB: mobile form widget error messages not working
    • Instance Manager: Corrected issue that was causing CGI job performing an instance update to terminate rather than respond with "success:true" upon completion.
    • Instance Manager: Corrected issue where front-end IFS files were not getting updated under certain circumstances
    • Instance Manager: Corrected issue where session records on a copied instance were not always getting cleared
    • RPG Toolkit - vvOut_execSQLtoJSON: Added logic to accommodate rare cases where total record count cannot be derived from SQL statement due to an SQL error
    • VVCHGAPPID - new utility for changing the app ID on an existing app record (.1 build)

    New Features and Fixes in 6.0.20201030:
    • Nitro App Builder (NAB): Startup program now gets a timeout value pulled from Portal Admin -&gt; Settings &gt; Nitro App Builder &gt; Data source timeout
    • NAB: Added "Utility" related behaviors from a close widget event
    • NAB: SQL data sources now allow reserved words to be used in column selection and aliases.
    • NAB: Fixed form widget boolean renderer "Checkmark"
    • NAB: Fixed issue where column searching/multi sort would not be active when "Allow copy of row data" is checked
    • NAB: Fixed mobile issue when using a edit grid with cell/row editing turned on
    • RPG Toolkit - vvOut_execRPGtoJSON: Adjusted to accommodate paging on SQL statements containing non-deterministic functions (cannot use OFFSET clause)
    • VVCALL: Added exit program for initial call to a CGI job (see Portal Admin &gt; Settings &gt; Exit Programs)
    • VVSYSMON: Added grace period for MSGW notification (see Portal Admin &gt; Settings &gt; iAdmin)
    • Portal Admin &gt; Settings: Ignore blank values on non-mandatory settings
    • VVSESSDATA: added VVPCGIJOB to table. Holds job number associated with session when using persistent CGI
    • Portal Admin &gt; Users: Sort by last login date was not working correctly
    New Features and Fixes in 6.0.20201002:
    • Nitro App Builder (NAB): Reworked UI for adding/editing buttons, row menu buttons, icon columns, and tile buttons
    • NAB: Adjusted to allow for tooltips on buttons, row menu buttons, and tile buttons
    • NAB: Corrected issue with appbar title URL parameter not saving
    • NAB: Corrected issue where execute script behavior was not saving under "Startup"
    • NAB: Corrected issue where chart legend text was not saving properly when more than six series exist
    • NAB: Corrected issue where inline editing date renderer format was only defaulting to date format from Valence settings. If a date renderer exists, it will now use the same date format as the renderer.
    • NAB: Corrected issue where inline grid editing function would sometimes not treat date cells as dates
    • NAB: added ability for edit grid validation programs (EXNABVAL) to send back custom responses that will now allow for: setting app variables, disable/enable features, set values of other fields (for cell editing), and sending back messages.
    • NAB: cell editing - No longer masks grid when doing inline updates to cells
    • NAB: Multiple fixes when running on a small mobile device
    • NAB: SQL DS allow for alias on over syntax
    • NAB: Edit Grid cell editing auto select text on edit
    • Portal: Adjusted so that apps in disabled categories do not show in Autostart list
    • RPG Toolkit - vvOut: Added support for Apache's Persistent CGI, activated by passing a query parameter of vvPersistCgi='true'
    • VVSYSMON: Adjusted to accommodate subsystems ending or starting while analysis is being performed (CPF187A)
    Last edited by robert.swanson; Today, 04:16 PM.

  • #2
    Valence Framework 6.0.20201002 is now available. Changes in this build since the previous release are:
    • Nitro App Builder (NAB): Reworked UI for adding/editing buttons, row menu buttons, icon columns, and tile buttons
    • NAB: Adjusted to allow for tooltips on buttons, row menu buttons, and tile buttons
    • NAB: Corrected issue with appbar title URL parameter not saving
    • NAB: Corrected issue where execute script behavior was not saving under "Startup"
    • NAB: Corrected issue where chart legend text was not saving properly when more than six series exist
    • NAB: Corrected issue where inline editing date renderer format was only defaulting to date format from Valence settings. If a date renderer exists, it will now use the same date format as the renderer.
    • NAB: Corrected issue where inline grid editing function would sometimes not treat date cells as dates
    • NAB: added ability for edit grid validation programs (EXNABVAL) to send back custom responses that will now allow for: setting app variables, disable/enable features, set values of other fields (for cell editing), and sending back messages.
    • NAB: cell editing - No longer masks grid when doing inline updates to cells
    • NAB: Multiple fixes when running on a small mobile device
    • NAB: SQL DS allow for alias on over syntax
    • NAB: Edit Grid cell editing auto select text on edit
    • Portal: Adjusted so that apps in disabled categories do not show in Autostart list
    • RPG Toolkit - vvOut: Added support for Apache's Persistent CGI, activated by passing a query parameter of vvPersistCgi='true'
    • VVSYSMON: Adjusted to accommodate subsystems ending or starting while analysis is being performed (CPF187A)
    Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

    Comment


    • #3
      Valence Framework 6.0.20201030 is now available. Changes in this build since the previous release are:
      • NAB: Startup program now gets a timeout value pulled from Portal Admin -> Settings > Nitro App Builder > Data source timeout
      • NAB: Added "Utility" related behaviors from a close widget event
      • NAB: SQL data sources now allow reserved words to be used in column selection and aliases.
      • NAB: Fixed form widget boolean renderer "Checkmark"
      • NAB: Fixed issue where column searching/multi sort would not be active when "Allow copy of row data" is checked
      • NAB: Fixed mobile issue when using a edit grid with cell/row editing turned on
      • RPG Toolkit - vvOut_execRPGtoJSON: Adjusted to accommodate paging on SQL statements containing non-deterministic functions (cannot use OFFSET clause)
      • VVCALL: Added exit program for initial call to a CGI job (see Portal Admin > Settings > Exit Programs)
      • VVSYSMON: Added grace period for MSGW notification (see Portal Admin > Settings > iAdmin)
      • Portal Admin > Settings: Ignore blank values on non-mandatory settings
      • VVSESSDATA: added VVPCGIJOB to table. Holds job number associated with session when using persistent CGI
      • Portal Admin > Users: Sort by last login date was not working correctly
      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

      Comment


      • #4
        Valence Framework 6.0.20201119 is now available. Changes in this build since the previous release are:
        • General: Corrected issue where fieldset titles were no longer showing properly due to a recent Chrome update (.1 build)
        • Nitro App Builder (NAB) - Form widget: Adjusted to pass widgetId on any calls to form helper RPG program
        • NAB - Form widget: Adjusted to pass all fields from the underlying data source record to the form helper program, including fields that are not in the form
        • NAB - Form widget: Corrected issue where form field error messages sent by EXNABBTN template programs were not being properly decoded on mobile (.1 build)
        • NAB - Grid widget: Fixed bug where grid button calling RPG program would not function if "allow copy row data" was activated
        • NAB - Grid widget: Corrected issue where grand total summary row was not showing when field grouping activated (.1 build)
        • NAB - Edit grid widget: Corrected issue where inline editing (i.e., max length and decimal positions) was not being enforced
        • NAB - Chart widget: Corrected issue in builder mode where filters may incorrectly refresh
        • NAB - Filters section: Corrected issue in builder mode where filter loses its search results after selecting a field for filtering
        • NAB: Adjusted call RPG program logic to encode array params (i.e., on combo box multi select)
        • NAB: Adjusted all combo boxes to employ a "contains" search rather than a "starts with" search
        • NAB: when adding/copying/deleting a record within an edit grid, ensure that the page reload remains at the same page if applicable.
        • NAB: mobile form widget error messages not working
        • Instance Manager: Corrected issue that was causing CGI job performing an instance update to terminate rather than respond with "success:true" upon completion.
        • Instance Manager: Corrected issue where front-end IFS files were not getting updated under certain circumstances
        • Instance Manager: Corrected issue where session records on a copied instance were not always getting cleared
        • RPG Toolkit - vvOut_execSQLtoJSON: Added logic to accommodate rare cases where total record count cannot be derived from SQL statement due to an SQL error
        • VVCHGAPPID - new utility for changing the app ID on an existing app record (.1 build)
        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

        Go to http://forums.cnxcorp.com/node/13172 for full release notes.
        Last edited by robert.swanson; 11-22-2020, 03:55 PM.

        Comment


        • #5

          Valence Framework 6.0.20201222 is now available. Changes in this build since the previous release are:
          • Nitro App Builder (NAB) - Grid Widget: Added option to limit PDF or Excel download to selected rows only
          • NAB - Grid Widget: Added new feature to allow for overriding columns on Excel and/or PDF downloads
          • NAB - Grid Widget: Added ability to hide/show grid columns via app variables
          • NAB - Grid Widget: Corrected issue with app variable-based grid column hide/show not working if column name contains special character
          • NAB - Grid Widget (Mobile): Corrected issue that would prevent app from starting if grid had checkbox selection enabled
          • NAB - Edit Grid Widget: Added ability to auto-edit row based off RRN or row index
          • NAB - Charts: allow adjustment of font size/style on the series title, label title and legend text
          • NAB - Charts: Fixed issue where charts were not displaying series and/or label titles
          • NAB - Timeline Widget: Fixed issue that could throw a console error when applying a filter
          • NAB - RPG backend: Adjusted NAB template programs to send back true boolean values when calling SetAppVar
          • NAB - Startup behaviors: Corrected issue with feature ids not saving properly for any Startup actions
          • Instance Manager: Adjusted to restore DSPF/PRTF objects and core source code files in updated instances
          • Nitro iAdmin: Corrected issue where a user with insufficient authority would not see correlating error message
          • Portal: Added pound sign (#) to list of acceptable special characters for Valence password rules
          • Portal exit programs: Corrected the "app initialization" exit program to pass an vvExitMode value of 'VVCALL_INIT' instead of 'VVCALL0'
          • RPG Toolkit - error handler: Added option to call an exit program (new column in VVERRHNDLR). Watch for a future blog post on this.
          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

          Comment


          • #6
            Valence Framework 6.0.20210119 is now available. Changes in this build since the previous release are:
            • Nitro App Builder (NAB) - Data Sources: Added ability to pull in current user on a data source SQL statement via vvIn_char('vvUser')
            • NAB - Pivot Grid Widget: Added ability to control location of column sub-total and total
            • NAB - Pivot Grid Widget: Added ability to format left & top axis columns
            • NAB - Pivot Grid Widget: Fixed issue where export would not work while configuring the widget
            • NAB - Pivot Grid Widget: Fixed issue where the user configuration panel wasn't correctly showing top axis columns
            • NAB - Pivot Grid Widget: Fixed issue where aggregate shows as blank instead of zero when top axis is active and "Show Zero As Blank" is unchecked
            • NAB - Grid Widget: Removed hide/show option on menu and icon columns
            • NAB - Chart Widgets: Added ability to have multi line chart labels via the HTML line break element tag <br>
            • NAB - Chart Widgets: Adjusted to match sort sequence of Valence 5.2 charts
            • NAB - Chart Widgets: Added ability to download to excel for all charts excluding gauge
            • NAB - Line Chart Widget: Added "stepped" option
            • NAB - Column Chart Widget: Added ability to transform any additional series to a line or area
            • NAB - Widget Filters: Fixed default value max length when the column is numeric
            • NAB - Widget Filters: Fixed issue when transforming to a lookup over date columns
            • NAB - Form Widget: Adjusted mobile to support HTML markup in fields
            • NAB - SQL Data Sources: Fixed parsing issue when using cross join lateral table function with a UDF
            • Portal Admin - Users: Added ability to set or change user's default environment at next login
            • Fusion5250: Added support for graphical pushbuttons
            • Fusion5250: Added basic support for graphical scrollbar area on subfiles (will be further refined in a subsequent release)
            • Desktop Portal: Fixed issue with showing/hiding split screen when entering/exiting fullscreen mode via the browser
            • Desktop Portal: Adjusted to hide language options when multilingual feature is turned off in Portal Admin > Settings
            • Desktop Portal: Added ability to exit split screen mode by hitting the escape key
            • RPG Toolkit - vvIn_sorters: Corrected issue where JSON pointer exception would be thrown into job log unnecessarily
            • RPG Toolkit - vvOut_execSQLtoJSON: Corrected issue where an SQL statement containing VVIN_CHAR() could fail to return a correct result set count. This would affect NAB data sources too.
            • RPG Toolkit - error handler: Adjusted exit program call to support EXEXITPGM template, passing an exit mode of "ERROR_HANDLER"
            • VVMIGRATE - Corrected issue where active web service consumers were not migrating to new instance
            Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

            Comment

            Working...
            X