Announcement

Collapse
No announcement yet.

Valence 5.1 (All Builds)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Valence 5.1 (All Builds)

    Versions:

    5.1.20170911.0, released on September 11, 2017
    5.1.20170822.0, released on August 22, 2017
    5.1.20170808.1, released on August 8, 2017
    5.1.20170714.0, released on July 14, 2017
    5.1.20170621.0, released on June 21, 2017
    5.1.20170607.0, released on June 7, 2017
    5.1.20170530.0, released on May 30, 2017
    5.1.20170515.0, released on May 15, 2017
    5.1.20170508.0, released on May 8, 2017

    About Release Notes:

    These release notes are intended to document what has been added, changed and fixed in Valence Framework 5.1 since the last 5.0 release and provide general information about the Valence Framework.

    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 Editions and 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 (V6R1 or V7R1+).
    • It is highly recommend that you perform the installation from a PC or Mac that is on the same internal network as your IBM i. Performing the installation through a slow WAN connection or via a VPN connection may work but can take many hours to install.
    • The download is a zip file. To launch the installer extract the zip file and double click on the ValenceInstall.exe file on your Windows PC, or launch the ValenceInstall.app file on your Mac. Follow the prompts to install Valence Framework 5.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.
    • This release will install to library VALENCE51 and ifs path /valence-5.1. It will also install an Apache server instance named VALENCE51.
    • If you have Valence Framework versions 5.0 and prior installed on your system you may install this release without affecting those earlier versions.
    • Once installed you can access the Valence Portal with the link http://xxx.xxx.xxx.xxx:7051 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7051 is the default installation port for Valence Framework 5.1. 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.

    Pending Changes for next Valence 5.1 Build:
    • Nitro Query App Builder: Ensure "autoload" setting is always observed on grid apps
    • Nitro Query App Builder: On back-end RPG processing of button calls, corrected MSGW condition that could occur when a global filter is applied to underlying grid
    • Remote DB: Corrected issue where some numeric fields would show as character on remote JDE files
    • VVMIGRATE: Ensure max open apps for mobile/touch (VVAPPS/VVMAXOPNT) is migrated from older instance when it exists
    • Nitro Query App Builder - Data Source SQL parser: Added support for WITH compound statements and fetch first row only/fetch first X rows only on those compound statements
    • RPG Toolkit - VVUTILITY: on vvUtility_getLiteral, defer to English literal when desired non-English literal does not exist
    • IBM i Access for Web: Adjusted to ensure a 5250 app does not launch if another just-launched 5250 app has not yet completed, as 5250 app launches must be processed serially (not in parallel)

    Changed in Valence 5.1.20170911.0:
    • Nitro Query App Builder: Added support in the SQL parser/regenerator for date/time calculations
    • Nitro Query App Builder: Fixed issue that could cause an invalid JSON response when saving a remote DB data source
    • Nitro Query App Builder: Added ability to set custom renderers to bar/column/pie charts
    • Nitro Query App Builder: Added new widget: "Single KPI"
    • Nitro Query App Builder: Corrected issue where line and area charts could break in preview if a label field is not specified
    • Nitro Query App Builder: Vertical container widget now allows height/width adjustments
    • Nitro Query App Builder: Fixed issue that could cause the grid column header text to get double decoded, resulting in strange characters
    • Nitro Query App Builder: On pivot grids over very large data sets, corrected issue where filter would be dropped after initial page of data loaded
    • Nitro Query App Builder: Corrected issue in edit grid where setting a numeric value to zero would result in an SQL error
    • Valence Portal: When logging in with a Valence profile tied to a different IBM i user, ensure Valence profile disabled through invalid password attempts is not automatically re-enabled on subsequent login attempt due to "Mirror user status" setting.
    • Portal Admin - Users: When setting a password on a Valence-specific profile, the password expiration was being reset. Adjusted to ensure expiration date is retained.
    • Nitro iAdmin: Added new MSGW and subsystem monitoring features (sends emails to appropriate users when problems detected)
    • RPG Toolkit - VVOUT: Adjusted buffer logic to avoid potential memory pointer error
    • Remote DB: Corrected issue where character fields on remote JDE files would come through as hex
    • VVMIGRATE: Program now stops migration if active sessions exist in target instance (sessions must be ended first)

    Changed in Valence 5.1.20170822.0:
    • Nitro Query App Builder: SQL parser/regenerator add support for the key word CONCAT and join row value expression
    • Nitro Query App Builder: Fix SQL error that would occur in Edit Grid app when adding records and first field in file is omitted from the add form
    • Nitro Query App Builder: Corrected problem that would cause Remote DB to fail when an Order By clause was included on the data source
    • Nitro Query App Builder: New feature on grid/edit grid widget to remember column order if the user is allowed to move columns and moves them around
    • Nitro Query App Builder: New feature allows users to change the sort of the grid/edit grid widget on multiple columns.
    • Nitro Query App Builder: In some cases the "Add Widget" window was missing available widgets.
    • Nitro Query App Builder: Grid widgets that have a download will now only have the columns that are visible in the excel document.
    • Nitro Query App Builder: SQL parser/regenerator add support for where clauses that have column list in etc. Example "where (fld1, fld2) in (select xFld1, xFld2 from FILEB)"
    • Nitro Query App Builder: Include the ability to remove any existing behavior filters before showing a widget
    • Nitro Query App Builder: Fixed problem with creating a data source with more than 99 fields
    • Nitro File Editor: Fixed editing problem when file is multi-member
    • Nitro File Editor: Fixed problem with length check on O type fields
    • Nitro File Editor: Fixed problem where Valence could terminate in some cases when opening large data files
    • Nitro AutoCode: Fixed problem where RPG would not compile when Japanese char used in the COLHDG
    • Nitro iAdmin: Fix problem when set to ignore MSGW for certain users was not actually ignoring them in all cases
    • Portal Admin > Categories: Fixed problem where category name could not be edited in Japanese
    • Spool File Viewer: Fix problem when downloading spool files with x'41' replacement character
    • Valence RPG Toolkit: Fixed problem with large data responses with mixed SBCS and DBCS

    Changed in Valence 5.1.20170808.1:
    • Nitro Query App Builder: Display form can now have fields laid out horizontally
    • Nitro Query App Builder: Updated UI of mobile edit grid form so read-only fields are obvious
    • Nitro Query App Builder: Will now auto-scroll/highlight/select the last added or edited datasource/widget/app
    • Nitro Query App Builder: Query button attached to RPG program does not make call in some circumstances due to front-end error (getExtraParams of null)
    • Nitro Query App Builder: application level buttons that call RPG programs are not working
    • Nitro Query App Builder: SQL parser/regenerator for datasource has been updated to handle complex statements and ensure parentheses are placed where they originally existed.
    • Nitro Query App Builder: SQL based datasource now has searching within the statement.
    • Nitro Query App Builder: Fix bug in Edit Grid widget where it would validate fields that were flagged as read-only. Now only validates fields that are not marked as read-only.
    • Nitro Query App Builder: SQL based datasources now accept fetch first, just not on the main select clause since that constraint will be applied to the widget.
    • Nitro Query App Builder: Feature, SQL editor flags ambiguous columns that need to be prefixed and files that are not found.
    • Nitro Query App Builder: Feature, SQL editor now has the ability to look up a file and add it to the statement.
    • Nitro Query App Builder: Feature, SQL editor now displays the files in the from clause and selected columns in a list. Selecting/deselecting fields in the list will dynamically update the SQL statement. The list displays all the fields in the file and each fields length, text and if it's a key.
    • Nitro Query App Builder: Feature, Edit Grid widget that has a data source with multiple files now has the ability to be configured to remove a record only in specific file(s).
    • Nitro Query App Builder: improved searching of widgets.
    • Nitro Query App Builder: Expanded maximum capacity of fields in a data source from 99 to 999
    • Nitro Query App Builder: Now supports multilingual, by default it has access to all Valence literals and custom literals can be added to the instances resources/Query/locale/language javascript file. Literals are defined within brackets. Example "[userid]", you can prompt within Nitro Query App Builder to get the available literals by hitting F4.
    • Nitro Query App Builder: SQL based datasources now will default sort grids if an order by exists on the statement.
    • Nitro Query App Builder: Allow for overriding the search text on grids.
    • Nitro Query App Builder: Gauge widget now allows setting of the maximum value, visible marker ticks, and the current value.
    • Nitro Query App Builder: Fix runtime error when a SQL based data source has an order by doesn't have a direction specified.
    • Nitro Query App Builder: Fix where numbers were disappearing from Data Source/Widget name/descriptions.
    • Valence package ajax error handling: add support for binary requests
    • Spool File Viewer: For Japan only, download spool files to .xlsx instead of .pdf
    • Spool File Viewer: Fixed issue that would cause certain files with Japanese characters to fail to load
    • Portal Admin > Remote Databases: Will now auto-update Java CLASSPATH setting if necessary whenever a remote DB connection is created or saved
    • Portal Admin > Remote Databases: Will now only show the default port number when adding a new remote DB connection
    • FileValidator (used by Nitro Query App Builder, Auto Code, and File Editor): In some cases the "Snackbar" error messaging was outputting encoded text.
    • FileValidator (used by Nitro Query App Builder, Auto Code, and File Editor): Adjusted to no longer lock the Schema combo box. This allows multiple libraries/schemas to be specified for files/tables on remote DB data sources.
    • FileValidator (used by Nitro Query App Builder, Auto Code, and File Editor): Add *LIBL as library option for remote IBM i connection
    • RPG Toolkit - VVPDF: In addTableFromSQL, any value other than "1" or "Y" will now result in the column being included in the PDF table
    • RPG Toolkit - VVOUT: in execSQLtoJSON, treat maxResults setting of zero as no limit on remote database calls
    • RPG Toolkit - VVOUT: in out_File, added explicit content-type accommodation for .xlsx extensions
    • Desktop Portal: Ensure "Forgot Password" function is controlled by setting in Portal Admin
    • Desktop Portal: Ability for users to change password is now controlled by new setting in Portal Admin
    Changed in Valence 5.1.20170714.0:
    • Nitro Query App Builder: Remote DB functionality unlocked to general public (though still considered Beta)
    • Nitro Query App Builder: Added ability to download files via the behaviors button RPG call
    • Nitro Query App Builder: RPG button program template (EXQRYBTN) includes new GetFilterValue procedure
    • Nitro Query App Builder: Corrected issue where edit grid validation program errors if user passes down a line feed in any of the fields
    • Nitro Query App Builder: Edit grid add/update was passing down "null" for empty fields; Now passes down an empty string.
    • Nitro Query App Builder: Edit grid add/update was passing down blanks for any dates not included in the form; Now passes "0001-01-01"
    • Nitro Query App Builder: Edit grid will now refresh all of its data after successfully editing a record
    • Nitro Query App Builder: Corrected issue where the save of a grid would occasionally error out while creating the parameters to post
    • Nitro Query App Builder: Corrected issue when saving a grid where some selected columns would not be saved if the column list is filtered
    • Nitro Query App Builder: Applied UI fix for any widget with a title and buttons.
    • Nitro Query App Builder: Corrected issue where incorrect filter information from a filter behavior would sometimes be passed to the backend RPG program
    • Nitro Query App Builder - Modern/Mobile: Corrected problem where changes made to checkboxes in an edit grid would not update the record
    • Nitro Query App Builder: When importing a query that launches other apps, import function now attempts to adjust app IDs to matching apps on destination instance based on app name/description
    • Nitro Query App Builder: Fixed scrolling issue that would occur when running an app containing more than one widget on a mobile device
    • Nitro Query App Builder: Adjusted to ensure filters on an underlying data source are applied to Excel downloads
    • Nitro Query App Builder: Added support for multiple widget filtering against a row/marker/chart click
    • Nitro Query App Builder: button template program (EXQRYBTN) procedure GetSqlStatement did not pull in any group by information
    • Nitro File Editor: Saved views now support multiple filter values (previously would only accept one filter record)
    • RPG Toolkit - vvOut_execSQLtoJSON: Functionality for pulling data from remote DB connections unlocked (Beta)
    • VVMIGRATE: Corrected problem on migration of VVQRY300 from 5.0 instances
    • Portal Admin - Settings: When an error in a field is detected, the page now scrolls to first field in error
    • Desktop Portal - IBM i Access for Web: Fixed issue with sessions/applications not closing automatically
    • Desktop Portal - IBM i Access for Web: Fixed issue with sessions/applications not working when same application is launched more than once
    • Desktop Portal: Corrected issue where a missing custom login image would cause the Portal load to stop, thus not allowing any login
    • Desktop Portal: Document classes are now available for theming via overrides.css.
    • Desktop Portal: Reincorporated change password functionality
    Changed in Valence 5.1.20170621.0:
    • Active Sessions app: Update image in list when the session is a webservice.
    • Nitro Query App Builder: Added logic to refresh data sources and widgets after an app is saved so the menu selections are correct.
    • Nitro Query App Builder: Fixed problem where in some cases when removing a widget from a query app it would cause an error after the save causing the query app to be broken.
    • Nitro Query App Builder: Fixed problem where in some cases calculated column lengths were not being derived properly.
    • Nitro Query App Builder: Fixed calculation field issue involving field names greater than 10 chars or aggregate functions in lower case
    • Nitro Query App Builder: Adjusted data source logic to ensure newly compiled validation programs are always called in development instances (vs QRPLOBJ)
    • Nitro Query App Builder: Corrected problem on import function that could cause loss of Group By clause in imported data sources
    • Nitro Query App Builder: Fix mobile grids that have a row tap and row menu action from behaviors. Previously was always issuing the row tap, even when user tapped explicitly on the row menu.
    • Nitro Query App Builder: Fixed SQL exception that would be triggered when doing a global search over a data source containing a count() column
    • Nitro Query App Builder: Fixed launching an application in mobile and sometimes not loading. Parameters were not being properly encoded.
    • Nitro Query App Builder: Add new data renderers for phone numbers in grid widgets.
    • Nitro Query App Builder: Fix double encoding of column descriptions.
    • Nitro Query App Builder: Removing widgets while building an app is not destroying the app rows properly thus leaving blank sections.
    • Nitro Query App Builder: edit grid validation program now has the ability to retrieve the RRN for each file.
    • Nitro Query App Builder: edit grid validation would error when calling in "POSTADD" and "POSTEDIT" modes.
    • Nitro Query App Builder: Show button text when creating a new row menu button in behaviors that launches an application.
    • Nitro Query App Builder: When using checkboxes for filtering don't force a value for checked or unchecked.
    • Nitro Source Editor: Fix bug when file is locked by another user.
    • Portal Admin - Settings: Added target release for Nitro Query exports (if left blank assumes *PRV)
    • Portal Admin - Apps: Enabled scrolling of groups list to accommodate Valence sites with very large numbers of groups
    • Portal Admin - Web Services: Fixed to avoid MSGW situation when deleting a web service associated with an active session ID
    • RPG Tookit - vvOut_initialize: Fixed character conversion problem when CCSID is 65535 and should be job default CCSID.
    • RPG Toolkit - vvIn_JSON: Ensure object name is upper cased to avoid problems in vvUtility_parse
    • RPG Toolkit - vvIn_timestamp: Expanded format parameter from 4A to 5A to accommodate *ISO0 value

    Changed in Valence 5.1.20170607.0:
    • VVMIGRATE: Corrected issue that could result in missing column function options (MIN, MAX, COUNT, etc) in new instance
    • VVMIGRATE: Corrected issue that could result in environments not migrating from old instance to new instance
    • Nitro Query App Builder: Fixed visibility of buttons that exist at the application level in behaviors when the Appbar doesn't have a title.
    • Nitro Query App Builder: Fixed problem with widget filters not getting applied in popup window.
    • General: Uppercased RPG program names in UI code with the letter "i" in them for compatibility with Turkish CCSID 1026.

    Changed in Valence 5.1.20170530.0:
    • Nitro Query: Fixed problem where "undefined" would show for field names in Widget filters.
    • Nitro Query: Fixed problem where numeric fields were sometimes interpreted as text fields when searching on a Grid Widget by column.
    • Nitro AutoCode: Fixed launch app button in Japan build.
    • Nitro File Editor: Fixed problem in download where filters/sql were not properly applied.
    • Nitro iAdmin: Fixed problem with saving ignored messages.
    • Nitro iAdmin: Fixed problem with subsystem list not scrolling.
    • Valence Portal: Fixed problem in Portal Admin where new categories would not be immediately seen in the launchpad.
    • Valence Portal: Adjusted VVCALL to ensure newly recompiled objects are always called in development instances (vs what may be in QRPLOBJ).
    • RPG Toolkit - vvOut: Adjusted execSQLtoJSON to accommodate program objects compiled to Valence 5.0 (backward compatibility).
    Changed in Valence 5.1.20170515.0:
    • Nitro Query: Added ability to filter widgets via URL parameters.
    • Nitro Query: Various SQL-based Data Source fixes.
    • Nitro Query: Added ability to pull in the column text instead of using just the field name in SQL-based Data Sources.
    • Valence Portal: Session ID generator in VVSECURE now incorporates an incrementer to ensure session ID is always unique.
    • Valence Portal: Removed Nitro App Path from Portal Admin > Settings (no longer used in 5.1).
    Changed in Valence 5.1.20170508.0 Since the Last Release of Valence 5.0:
    • Nitro Query: Added ability to create Edit Grid widgets with joined files so maintenance apps can access and update multiple files at once.
    • Nitro Query: Added ability to call external RPG programs which can respond and act on front-end user actions.
    • Nitro Query: Can now import and convert old green screen queries directly into Nitro Query.
    • Nitro Query: Added feature to directly paste in SQL statements for instant conversion to a grid or spreadsheet.
    • Nitro Query: Added new Pivot Grid widget to organize and summarize large data sets.
    • Nitro Query: Apps can now include images, icons, links and text formatting in any grid columns through custom renderers.
    • Nitro Query: Data sources can pull data from remote database servers (IBM i, SQL Server or MySQL). This feature is in early Beta -- will be activated in an upcoming maintenance build.
    • Nitro Query: Added additional standard renderers for displaying various date, timestamp and numeric formats.
    • Nitro Query: Added ability to prefix or suffix a column with text (like “2 lbs”).
    • Nitro Query: Added ability to provide initial default values for filter fields in Query.
    • Nitro Query: Added new utility widget to lay out widgets vertically within their own container.
    • Nitro Query: Added ability to have a grand total row summary along with grouping summary when grouping a column.
    • Nitro Query: Added new checkbox selection capability to a grid and have a button to automatically enable/disable based on a selection.
    • Nitro Query: Added ability to copy and paste info from grids.
    • Nitro Query: In the Query designer, apps now show their relationships to widgets and data sources.
    • Nitro Query: Various minor bug fixes and UI refinements.
    • RPG Toolkit: Added new vvIn_Body() procedure.
    • RPG Toolkit: SQL statements passed into vvOut_execSQLtoJSON() can pull data from remote database servers (IBM i, SQL Server or MySQL). This feature is in early Beta -- will be activated in an upcoming maintenance build.
    • Valence Node.js Toolkit: Developers can now use Node.js in lieu of (or in addition to) RPG, PHP or Java for server-side logic. This feature is in beta -- customers wanting to try Node.js should contact CNX.
    System Requirements:
    • Any hardware running the IBM i operating system V6R1 or higher. For installation of Valence Framework 5.1 to your IBM i, a PC running any newer version of Windows or a Mac running any newer version of OS X is required.
    • The client computer utilizing Valence apps can be Mac OS X, Windows, Unix, Linux, iPhone, iPad, Android, Blackberry and virtually any hardware that has a compatible browser.
    • A compatible browser on client computers. CNX recommends Google Chrome for the best development and user experience on the desktop, and iSafari or other integrated browsers on mobile devices. This version of Valence should work in newer versions of Google Chrome, Firefox, Safari and Internet Explorer as well as WebKit-based mobile device browsers like those on iPhone, iPad and Android.
    Uninstalling Valence Framework 5.1:

    Follow these instructions if you previously installed this release and would like to completely remove it from your system:
    • Log onto a 5250 session as QSECOFR or another profile with security officer authority.
    • End the VALENCE51 Apache server instance with command "ENDTCPSVR SERVER(*HTTP) HTTPSVR(VALENCE51)".
    • Before continuing, be certain there are no users and/or developers with a lock on the VALENCE51 library with command "WRKOBJLCK OBJ(VALENCE51) OBJTYPE(*LIB)". If there are any jobs listed, cancel them or ask the users/developers to exit.
    • Delete the VALENCE51 library with command "DLTLIB LIB(VALENCE51)".
    • Delete the IFS folder named /valence-5.1 and all subfolders and files. The easiest way to do this is to start with command "WRKLNK /" then use option 2 against the root folder, then option 9 (recursive delete) against the /valence-5.1 folder.
    • Delete the VALENCE51 Apache server instance by navigating with your browser to http://[your_IBMi_ip_address]:2001/HTTPAdmin. Use the QSECOFR profile or another profile with security officer authority when prompted. Click on the “ALL Servers” tab, select the VALENCE51 server instance and then click the delete option.
    If you need assistance with installing this release or have other questions please email support@cnxcorp.com or call CNX at (312) 477-7450.
    Last edited by robert.swanson; Yesterday, 05:20 PM.
    Richard
    CNX Development Team
    richard.milone@cnxcorp.com

  • #2
    Just Released: Valence 5.1! Valence Framework 5.1.20170508.0 is now available. Significant changes in this new release since the last version of Valence Framework 5.0 are:
    • Nitro Query: Added ability to create Edit Grid widgets with joined files so maintenance apps can access and update multiple files at once.
    • Nitro Query: Added ability to call external RPG programs which can respond and act on front-end user actions.
    • Nitro Query: Can now import and convert old green screen queries directly into Nitro Query.
    • Nitro Query: Added feature to directly paste in SQL statements for instant conversion to a grid or spreadsheet.
    • Nitro Query: Added new Pivot Grid widget to organize and summarize large data sets.
    • Nitro Query: Apps can now include images, icons, links and text formatting in any grid columns through custom renderers.
    • Nitro Query: Data sources can pull data from remote database servers (IBM i, SQL Server or MySQL). This feature is in early Beta -- will be activated in an upcoming maintenance build.
    • Nitro Query: Added additional standard renderers for displaying various date, timestamp and numeric formats.
    • Nitro Query: Added ability to prefix or suffix a column with text (like “2 lbs”).
    • Nitro Query: Added ability to provide initial default values for filter fields in Query.
    • Nitro Query: Added new utility widget to lay out widgets vertically within their own container.
    • Nitro Query: Added ability to have a grand total row summary along with grouping summary when grouping a column.
    • Nitro Query: Added new checkbox selection capability to a grid and have a button to automatically enable/disable based on a selection.
    • Nitro Query: Added ability to copy and paste info from grids.
    • Nitro Query: In the Query designer, apps now show their relationships to widgets and data sources.
    • Nitro Query: Various minor bug fixes and UI refinements.
    • RPG Toolkit: Added new vvIn_Body() procedure.
    • RPG Toolkit: SQL statements passed into vvOut_execSQLtoJSON() can pull data from remote database servers (IBM i, SQL Server or MySQL). This feature is in early Beta -- will be activated in an upcoming maintenance build.
    • Valence Node.js Toolkit: Developers can now use Node.js in lieu of (or in addition to) RPG, PHP or Java for server-side logic. This feature is in beta -- customers wanting to try Node.js should contact CNX.
    Go to http://forums.cnxcorp.com/node/11825 for full release notes.
    Richard
    CNX Development Team
    richard.milone@cnxcorp.com

    Comment


    • #3
      Valence Framework 5.1.20170515.0 is now available. Changes in this build since the previous release are:
      • Nitro Query: Added ability to filter widgets via URL parameters.
      • Nitro Query: Various SQL-based Data Source fixes.
      • Nitro Query: Added ability to pull in the column text instead of using just the field name in SQL-based Data Sources.
      • Valence Portal: Session ID generator in VVSECURE now incorporates an incrementer to ensure session ID is always unique.
      • Valence Portal: Removed Nitro App Path from Portal Admin > Settings (no longer used in 5.1).
      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

      Go to http://forums.cnxcorp.com/node/11825 for full release notes.
      Richard
      CNX Development Team
      richard.milone@cnxcorp.com

      Comment


      • #4
        Valence Framework 5.1.20170530.0 is now available. Changes in this build since the previous release are:
        • Nitro Query: Fixed problem where "undefined" would show for field names in Widget filters.
        • Nitro Query: Fixed problem where numeric fields were sometimes interpreted as text fields when searching on a Grid Widget by column.
        • Nitro AutoCode: Fixed launch app button in Japan build.
        • Nitro File Editor: Fixed problem in download where filters/sql were not properly applied.
        • Nitro iAdmin: Fixed problem with saving ignored messages.
        • Nitro iAdmin: Fixed problem with subsystem list not scrolling.
        • Valence Portal: Fixed problem in Portal Admin where new categories would not be immediately seen in the launchpad.
        • Valence Portal: Adjusted VVCALL to ensure newly recompiled objects are always called in development instances (vs what may be in QRPLOBJ).
        • RPG Toolkit - vvOut: Adjusted execSQLtoJSON to accommodate program objects compiled to Valence 5.0 (backward compatibility).
        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

        Go to http://forums.cnxcorp.com/node/11825 for full release notes.
        Richard
        CNX Development Team
        richard.milone@cnxcorp.com

        Comment


        • #5
          Valence Framework 5.1.20170607.0 is now available. Changes in this build since the previous release are:
          • VVMIGRATE: Corrected issue that could result in missing column function options (MIN, MAX, COUNT, etc) in new instance
          • VVMIGRATE: Corrected issue that could result in environments not migrating from old instance to new instance
          • Nitro Query App Builder: Fixed visibility of buttons that exist at the application level in behaviors when the Appbar doesn't have a title.
          • Nitro Query App Builder: Fixed problem with widget filters not getting applied in popup window.
          • General: Uppercased RPG program names in UI code with the letter "i" in them for compatibility with Turkish CCSID 1026.
          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

          Go to http://forums.cnxcorp.com/node/11825 for full release notes.
          Richard
          CNX Development Team
          richard.milone@cnxcorp.com

          Comment


          • #6
            Valence Framework 5.1.20170621.0 is now available. Changes in this build since the previous release are:
            • Active Sessions app: Update image in list when the session is a webservice.
            • Nitro Query App Builder: Added logic to refresh data sources and widgets after an app is saved so the menu selections are correct.
            • Nitro Query App Builder: Fixed problem where in some cases when removing a widget from a query app it would cause an error after the save causing the query app to be broken.
            • Nitro Query App Builder: Fixed problem where in some cases calculated column lengths were not being derived properly.
            • Nitro Query App Builder: Fixed calculation field issue involving field names greater than 10 chars or aggregate functions in lower case
            • Nitro Query App Builder: Adjusted data source logic to ensure newly compiled validation programs are always called in development instances (vs QRPLOBJ)
            • Nitro Query App Builder: Corrected problem on import function that could cause loss of Group By clause in imported data sources
            • Nitro Query App Builder: Fix mobile grids that have a row tap and row menu action from behaviors. Previously was always issuing the row tap, even when user tapped explicitly on the row menu.
            • Nitro Query App Builder: Fixed SQL exception that would be triggered when doing a global search over a data source containing a count() column
            • Nitro Query App Builder: Fixed launching an application in mobile and sometimes not loading. Parameters were not being properly encoded.
            • Nitro Query App Builder: Add new data renderers for phone numbers in grid widgets.
            • Nitro Query App Builder: Fix double encoding of column descriptions.
            • Nitro Query App Builder: Removing widgets while building an app is not destroying the app rows properly thus leaving blank sections.
            • Nitro Query App Builder: edit grid validation program now has the ability to retrieve the RRN for each file.
            • Nitro Query App Builder: edit grid validation would error when calling in "POSTADD" and "POSTEDIT" modes.
            • Nitro Query App Builder: Show button text when creating a new row menu button in behaviors that launches an application.
            • Nitro Query App Builder: When using checkboxes for filtering don't force a value for checked or unchecked.
            • Nitro Source Editor: Fix bug when file is locked by another user.
            • Portal Admin - Settings: Added target release for Nitro Query exports (if left blank assumes *PRV)
            • Portal Admin - Apps: Enabled scrolling of groups list to accommodate Valence sites with very large numbers of groups
            • Portal Admin - Web Services: Fixed to avoid MSGW situation when deleting a web service associated with an active session ID
            • RPG Tookit - vvOut_initialize: Fixed character conversion problem when CCSID is 65535 and should be job default CCSID.
            • RPG Toolkit - vvIn_JSON: Ensure object name is upper cased to avoid problems in vvUtility_parse
            • RPG Toolkit - vvIn_timestamp: Expanded format parameter from 4A to 5A to accommodate *ISO0 value
            Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

            Go to http://forums.cnxcorp.com/node/11825 for full release notes.
            Richard
            CNX Development Team
            richard.milone@cnxcorp.com

            Comment


            • #7
              Valence Framework 5.1.20170714.0 is now available. Changes in this build since the previous release are:
              • Nitro Query App Builder: Remote DB functionality unlocked to general public (though still considered Beta)
              • Nitro Query App Builder: Added ability to download files via the behaviors button RPG call
              • Nitro Query App Builder: RPG button program template (EXQRYBTN) includes new GetFilterValue procedure
              • Nitro Query App Builder: Corrected issue where edit grid validation program errors if user passes down a line feed in any of the fields
              • Nitro Query App Builder: Edit grid add/update was passing down "null" for empty fields; Now passes down an empty string.
              • Nitro Query App Builder: Edit grid add/update was passing down blanks for any dates not included in the form; Now passes "0001-01-01"
              • Nitro Query App Builder: Edit grid will now refresh all of its data after successfully editing a record
              • Nitro Query App Builder: Corrected issue where the save of a grid would occasionally error out while creating the parameters to post
              • Nitro Query App Builder: Corrected issue when saving a grid where some selected columns would not be saved if the column list is filtered
              • Nitro Query App Builder: Applied UI fix for any widget with a title and buttons.
              • Nitro Query App Builder: Corrected issue where incorrect filter information from a filter behavior would sometimes be passed to the backend RPG program
              • Nitro Query App Builder - Modern/Mobile: Corrected problem where changes made to checkboxes in an edit grid would not update the record
              • Nitro Query App Builder: When importing a query that launches other apps, import function now attempts to adjust app IDs to matching apps on destination instance based on app name/description
              • Nitro Query App Builder: Fixed scrolling issue that would occur when running an app containing more than one widget on a mobile device
              • Nitro Query App Builder: Adjusted to ensure filters on an underlying data source are applied to Excel downloads
              • Nitro Query App Builder: Added support for multiple widget filtering against a row/marker/chart click
              • Nitro Query App Builder: button template program (EXQRYBTN) procedure GetSqlStatement did not pull in any group by information
              • Nitro File Editor: Saved views now support multiple filter values (previously would only accept one filter record)
              • RPG Toolkit - vvOut_execSQLtoJSON: Functionality for pulling data from remote DB connections unlocked (Beta)
              • VVMIGRATE: Corrected problem on migration of VVQRY300 from 5.0 instances
              • Portal Admin - Settings: When an error in a field is detected, the page now scrolls to first field in error
              • Desktop Portal - IBM i Access for Web: Fixed issue with sessions/applications not closing automatically
              • Desktop Portal - IBM i Access for Web: Fixed issue with sessions/applications not working when same application is launched more than once
              • Desktop Portal: Corrected issue where a missing custom login image would cause the Portal load to stop, thus not allowing any login
              • Desktop Portal: Document classes are now available for theming via overrides.css.
              • Desktop Portal: Reincorporated change password functionality
              Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

              Go to http://forums.cnxcorp.com/node/11825 for full release notes.
              Richard
              CNX Development Team
              richard.milone@cnxcorp.com

              Comment


              • #8
                Valence Framework 5.1.20170808.0 is now available. Changes in this build since the previous release are:
                • Nitro Query App Builder: Display form can now have fields laid out horizontally
                • Nitro Query App Builder: Updated UI of mobile edit grid form so read-only fields are obvious
                • Nitro Query App Builder: Will now auto-scroll/highlight/select the last added or edited datasource/widget/app
                • Nitro Query App Builder: Query button attached to RPG program does not make call in some circumstances due to front-end error (getExtraParams of null)
                • Nitro Query App Builder: application level buttons that call RPG programs are not working
                • Nitro Query App Builder: SQL parser/regenerator for datasource has been updated to handle complex statements and ensure parentheses are placed where they originally existed.
                • Nitro Query App Builder: SQL based datasource now has searching within the statement.
                • Nitro Query App Builder: Fix bug in Edit Grid widget where it would validate fields that were flagged as read-only. Now only validates fields that are not marked as read-only.
                • Nitro Query App Builder: SQL based datasources now accept fetch first, just not on the main select clause since that constraint will be applied to the widget.
                • Nitro Query App Builder: Feature, SQL editor flags ambiguous columns that need to be prefixed and files that are not found.
                • Nitro Query App Builder: Feature, SQL editor now has the ability to look up a file and add it to the statement.
                • Nitro Query App Builder: Feature, SQL editor now displays the files in the from clause and selected columns in a list. Selecting/deselecting fields in the list will dynamically update the SQL statement. The list displays all the fields in the file and each fields length, text and if it's a key.
                • Nitro Query App Builder: Feature, Edit Grid widget that has a data source with multiple files now has the ability to be configured to remove a record only in specific file(s).
                • Nitro Query App Builder: improved searching of widgets.
                • Nitro Query App Builder: Expanded maximum capacity of fields in a data source from 99 to 999
                • Nitro Query App Builder: Now supports multilingual, by default it has access to all Valence literals and custom literals can be added to the instances resources/Query/locale/language javascript file. Literals are defined within brackets. Example "[userid]", you can prompt within Nitro Query App Builder to get the available literals by hitting F4.
                • Nitro Query App Builder: SQL based datasources now will default sort grids if an order by exists on the statement.
                • Nitro Query App Builder: Allow for overriding the search text on grids.
                • Valence package ajax error handling: add support for binary requests
                • Spool File Viewer: For Japan only, download spool files to .xlsx instead of .pdf
                • Portal Admin > Remote Databases: Will now auto-update Java CLASSPATH setting if necessary whenever a remote DB connection is created or saved
                • Portal Admin > Remote Databases: Will now only show the default port number when adding a new remote DB connection
                • FileValidator (used by Nitro Query App Builder, Auto Code, and File Editor): In some cases the "Snackbar" error messaging was outputting encoded text.
                • FileValidator (used by Nitro Query App Builder, Auto Code, and File Editor): Adjusted to no longer lock the Schema combo box. This allows multiple libraries/schemas to be specified for files/tables on remote DB data sources.
                • FileValidator (used by Nitro Query App Builder, Auto Code, and File Editor): Add *LIBL as library option for remote IBM i connection
                • RPG Toolkit - VVPDF: In addTableFromSQL, any value other than "1" or "Y" will now result in the column being included in the PDF table
                • RPG Toolkit - VVOUT: in execSQLtoJSON, treat maxResults setting of zero as no limit on remote database calls
                • RPG Toolkit - VVOUT: in out_File, added explicit content-type accommodation for .xlsx extensions
                • Desktop Portal: Ensure "Forgot Password" function is controlled by setting in Portal Admin
                • Desktop Portal: Ability for users to change password is now controlled by new setting in Portal Admin
                Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

                Go to http://forums.cnxcorp.com/node/11825 for full release notes.
                Richard
                CNX Development Team
                richard.milone@cnxcorp.com

                Comment


                • #9
                  Valence Framework 5.1.20170822.0 is now available. Changes in this build since the previous release are:
                  • Nitro Query App Builder: SQL parser/regenerator add support for the key word CONCAT and join row value expression
                  • Nitro Query App Builder: Fix SQL error that would occur in Edit Grid app when adding records and first field in file is omitted from the add form
                  • Nitro Query App Builder: Corrected problem that would cause Remote DB to fail when an Order By clause was included on the data source
                  • Nitro Query App Builder: New feature on grid/edit grid widget to remember column order if the user is allowed to move columns and moves them around
                  • Nitro Query App Builder: New feature allows users to change the sort of the grid/edit grid widget on multiple columns.
                  • Nitro Query App Builder: In some cases the "Add Widget" window was missing available widgets.
                  • Nitro Query App Builder: Grid widgets that have a download will now only have the columns that are visible in the excel document.
                  • Nitro Query App Builder: SQL parser/regenerator add support for where clauses that have column list in etc. Example "where (fld1, fld2) in (select xFld1, xFld2 from FILEB)"
                  • Nitro Query App Builder: Include the ability to remove any existing behavior filters before showing a widget
                  • Nitro Query App Builder: Fixed problem with creating a data source with more than 99 fields
                  • Nitro File Editor: Fixed editing problem when file is multi-member
                  • Nitro File Editor: Fixed problem with length check on O type fields
                  • Nitro File Editor: Fixed problem where Valence could terminate in some cases when opening large data files
                  • Nitro AutoCode: Fixed problem where RPG would not compile when Japanese char used in the COLHDG
                  • Nitro iAdmin: Fix problem when set to ignore MSGW for certain users was not actually ignoring them in all cases
                  • Portal Admin > Categories: Fixed problem where category name could not be edited in Japanese
                  • Spool File Viewer: Fix problem when downloading spool files with x'41' replacement character
                  • Valence RPG Toolkit: Fixed problem with large data responses with mixed SBCS and DBCS
                  Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

                  Go to http://forums.cnxcorp.com/node/11825 for full release notes.
                  Richard
                  CNX Development Team
                  richard.milone@cnxcorp.com

                  Comment


                  • #10
                    Valence Framework 5.1.20170911.0 is now available. Changes in this build since the previous release are:
                    • Nitro Query App Builder: added support in the SQL parser/regenerator for date/time calculations
                    • Nitro Query App Builder: fixed issue that could cause an invalid JSON response when saving a remote DB data source
                    • Nitro Query App Builder: ability to set custom renderers to bar/column/pie charts.
                    • Nitro Query App Builder: New Widget: "Single KPI"
                    • Nitro Query App Builder: line and area charts break in preview if a label field is not specified
                    • Nitro Query App Builder: vertical container widget now allows height/width adjustments
                    • Nitro Query App Builder: fix where sometimes the grid column header text would get double decoded "strange characters"
                    • Nitro Query App Builder: on pivot grids over very large data sets, corrected issue where filter would be dropped after initial page of data loaded
                    • Valence Portal: When logging in with a Valence profile tied to a different IBM i user, ensure Valence profile disabled through invalid password attempts is not automatically re-enabled on subsequent login attempt due to "Mirror user status" setting.
                    • Portal Admin - Users: When setting a password on a Valence-specific profile, the password expiration was being reset. Adjusted to ensure expiration date is retained.
                    • Nitro iAdmin: Added new MSGW and subsystem monitoring features (sends emails to appropriate users)
                    • RPG Toolkit - VVOUT: Adjusted buffer logic to avoid potential memory pointer error
                    • VVMIGRATE: Stop migration if active sessions exist in target instance (sessions must be ended first)
                    Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

                    Go to http://forums.cnxcorp.com/node/11825 for full release notes.
                    Richard
                    CNX Development Team
                    richard.milone@cnxcorp.com

                    Comment

                    Working...
                    X