Announcement

Collapse
No announcement yet.

Valence 5.2 (All Builds)

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

  • Valence 5.2 (All Builds)

    Versions:

    5.2.20181130.0, released on November 30, 2018
    5.2.20180920.0, released on September 20, 2018
    5.2.20180817.0, released on August 17, 2018
    5.2.20180706.0, released on July 6, 2018
    5.2.20180629.1, released on June 29, 2018
    5.2.20180518.0, released on May 18, 2018

    About Release Notes:

    These release notes are intended to document what has been added, changed and fixed in Valence Framework 5.2 since the last 5.1 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 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 (V7R1, V7R2 or V7R3).
    • 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.2 onto your IBM i. Note that you may need administrative rights on your PC or Mac to launch the installer.
    • It is highly recommended that you use QSECOFR to perform the installation to avoid permissions issues.
    • This release will install to library VALENCE52 and ifs path /valence-5.2. It will also install an Apache server instance named VALENCE52.
    • If you have Valence Framework versions 5.1 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:7052 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7052 is the default installation port for Valence Framework 5.2. 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.2 build:
    • Nitro App Builder: corrected problem with form field formatting, which was not working in mobile version
    • Nitro App Builder: no longer allow export of an application if any of its widgets have been updated later than the last save of the application
    • Nitro File Editor: Added CCSID to columns list
    • Instance Manager: Ensure VVSQLFUNC source member references library name of corresponding instance after updating to latest build
    • Instance Manager: Adjusted to ensure newly added demo apps are applied to updated instances


    Changed in Valence 5.2.20181130.0
    • Nitro App Builder: Data Sources now prompts for confirmation before performing "Add All" operation
    • Nitro App Builder: Corrected issue where editing an existing data source may cause the ORDER BY sequence to change under some circumstances
    • Nitro App Builder: Corrected issue when editing a form widget where field group sequencing would not display properly
    • Nitro App Builder: Updated SQL-based data source logic to support FULL OUTER JOIN syntax
    • Nitro App Builder: Corrected multilingual/F4 prompt functionality on edit grids
    • Nitro App Builder: Corrected issue where selecting and/or applying filtering in preview mode was causing a console error
    • Nitro App Builder: Added support for CCSID on CAST in SQL-based data sources
    • Nitro App Builder: Added support for parsing columns from a defined CTE in SQL-based data sources
    • Nitro App Builder: Corrected issue calling RPG program with forms that have hard-coded combo values
    • Nitro App Builder: Added support for calling RPG program from charts, maps, and KPI widgets
    • Nitro App Builder: Added copy feature to the edit grid widget
    • Nitro App Builder: Corrected export/import issue that would cause drop-downs to fail after importing to an earlier Valence build
    • Nitro App Builder: Adjusted to apply any URL filters to the grid download
    • Nitro App Builder: Adjusted to only apply filters on values that are not empty
    • Nitro App Builder: Added ability to conditionally disable/enable row menu buttons
    • Nitro App Builder: Added ERR_ADD, ERR_EDIT and ERR_DELETE logic to validation program
    • Nitro App Builder: Added ability to specify colors for all chart widgets.
    • Nitro App Builder: Added ability to specify legend text for each chart series.
    • Nitro App Builder: Corrected issue where a KPI widget value was not always formatted as expected in mobile version
    • Nitro App Builder: Added PDF generation/download on the grid & edit grid widgets
    • Nitro App Builder: Added field mapping rules so a form widget may be used to drive searches across multiple widgets
    • Nitro App Builder: When a form has a "primary" button, pressing ENTER will now act as click of the button
    • Nitro App Builder: Added option to print/download or display document sent from RPG call. This is only available for users not using Microsoft IE/Edge otherwise they will get the usual open or download request from the browser.
    • Nitro App Builder: Corrected import issue that could cause widget references to be corrupted on more elaborate NAB apps
    • Nitro App Builder: Behaviors now may be set against a "close" event of a widget
    • Nitro App Builder: Adjusted wizard-based data source to allow cross joins
    • Nitro App Builder: Corrected issue where lookup fields configuration was not remembering previously saved values
    • Nitro App Builder: Corrected issue where "Between" filters over a numeric field were not pulling the second field value if the first field value was a zero
    • Nitro App Builder: Corrected issue where grids that are set to not autoload were sometimes auto-loading in mobile
    • Nitro App Builder: Fixed mobile popups to handle behaviors
    • Nitro App Builder: Stop encoding data source filter values on Japanese characters
    • Nitro App Builder: Added support for XMLSERIALIZE, XMLAGG & XMLELEMENT on SQL-based data sources.
    • Nitro App Builder: Added new utility behavior to provide a way to reset form fields
    • Nitro App Builder: Added "Set To Previous Title" option when specifying an app bar title in behaviors
    • Nitro App Builder: Added ability to "transform" a grid into an edit grid.
    • Nitro App Builder: Corrected issue with filters sometimes not displaying properly on mobile devices
    • Nitro App Builder: Corrected issue where popups would lose their close button when a widget was filtered
    • Nitro App Builder: Corrected issue with filters where original operator was set as "Between" with an initial value, then changed to a different operator
    • Nitro App Builder: Added support for UCS-2 graphic string constants in SQL-based data sources
    • Nitro App Builder: Added support for DBCS columns as widget filters
    • Nitro App Builder: Ensure RPG calls from buttons or filters always encode graphic columns before passing the data to the backend
    • Nitro App Builder: Adjusted grid widgets so when cell has custom formatting that could make the cell larger than the default, accommodate the possible larger height so cell values are not cut off
    • Nitro App Builder: Adjusted Mobile UI so that if a grid widget column has a color for background then the whole cell is filled with the color
    • Nitro App Builder: Adjusted Mobile UI for small devices - if grid columns have flex instead of defined widths, ensure the column are wide enough to render the content
    • Nitro App Builder: Adjusted Mobile UI so that form label align-right behaves just same as desktop
    • Nitro App Builder: Adjusted RPG call logic from form button such that fields from the data source that are not on the form are still passed so the backend program has access to all pertinent fields
    • Nitro App Builder: Added validation for Z & T fields in form and edit grid widgets
    • Nitro App Builder: Adjusted SQL based data sources to always wrap WHERE clause in parentheses so that filters are applied correctly. Bug Report
    • Nitro Apps (General): Adjusted logic to ensure any changes made to user-defined locale/literal files will always pick up latest changes
    • Nitro iAdmin: Added new "Location" setting in Portal Admin > Settings, included in subject line of MSGW notification emails when specified
    • Nitro iAdmin: Fixed bug where the IPL ability wasn't showing on mobile when that setting was turned on via Portal Admin Settings
    • Nitro File Editor: Added validation for Z & T fields
    • RPG Toolkit - vvUtility_getFieldInfo: Adjusted to avoid throwing CPF4328 commitment control messages into the job log
    • RPG Toolkit - vvUtility_getObjectList: Expanded max size to 32K (formerly 9999)
    • RPG Toolkit - vvMail_send: Will now encode subject in base64, based on new setting in Portal Admin > Settings > Hidden Settings
    • RPG Toolkit: Created new program VVCRTWRKF to create work files based on a printer file record format (for use in converting PRTF output into a NAB data source)
    • RPG Toolkit: Added logic to remoteDB to ignore delayed responses from JDBC that are received after initial call has timed out
    • Portal: Substitution values are now allowed in an app's optional parameters (previously only supported in app path)
    • Portal Admin - Fixed bug where apps and or users would be lost if apps or users were filtered when saving the group
    • Portal Admin - Fixed bug where sometimes after successfully saving a user an error would occur in the latest version of Firefox
    • App Usage app - Applied a number of general UI updates
    • App Usage app - Adjusted to not allow users to select dates where no data exists
    • Examples: Added physical files DEMOSTATES (US States) and DEMOCNTRYS (Global Countries) for use in NAB data sources
    • Examples: Added EXPRINT program to demonstrate how to adjust an existing RPG program that produces PRTF output to feed a NAB data source

    Changed in Valence 5.2.20180920.0:
    • Nitro App Builder: Adjusted export routine to accommodate portal environments where QTEMP is ahead of Valence library
    • Nitro App Builder: Corrected issue where an SQL-filtered data source linked to a filtered widget could cause an SQL error (double WHERE clause) when downloading to Excel
    • Nitro App Builder: Added support for searching on character columns that are in a different CCSID than the job (activated in Portal Admin>Settings)
    • Nitro App Builder: Buttons attached to forms were not properly passing record data as a parameter when configured to "Launch App"
    • Nitro App Builder: Added support for functions in ORDER BY clause of SQL-based data structures
    • Nitro File Editor: Added support for searching on character columns that are in a different CCSID than the job (activated in Portal Admin>Settings)
    • Nitro AutoCode: Added support for searching on character columns that are in a different CCSID than the job (activated in Portal Admin>Settings)
    • Portal Admin - Settings: Added new SQL_UNICODE_FILTER to accommodate unicode-based searching on character columns that are in a different CCSID than the job (activated by default for Japanese sites)
    • Portal Admin - Web Services: Added option to support partial match of web service URL
    • RPG Toolkit - vvUtility: Replaced hard-coded backslash with special BS constant to avoid conversion issues in certain CCSIDs
    • RPG Toolkit - vvIn: Added new global control to skip conversion of POST to GET when processing web service calls (allows use of HTTP_METHOD with vvIn_Body)
    • RPG Toolkit - vvSecure: Added support for partial match of web service URL (your program must check REQUEST_URI environment value to determine appropriate action)
    • Test RPG Call - corrected issue that could cause environment ID associated with devToken session to be overridden to the environment ID associated with the Portal session

    Changed in Valence 5.2.20180817.1:
    • Nitro File Editor: Adjusted maximum value/maximum length on numeric fields to take into consideration negative sign and decimal point
    • Nitro File Editor: Now traps attempts to place invalid characters into graphic fields with non-standard CCSIDs (i.e., CCSID 300)
    • Nitro App Builder: Map widget now allows for markers to display the index number of the data
    • Nitro App Builder: Map widget can now draw a contiguous path between markers.
    • Nitro App Builder: Added pivot grid option to lock the left axis columns (only valid if running on a desktop)
    • Nitro App Builder: Adjusted pivot grid to only show prefix/suffix text when value is not null/undefined
    • Nitro App Builder: Fixed pivot grid user configuration so it shows the top axis field labels correctly; Configuration section is now collapsed on startup
    • Nitro App Builder: Corrected issue where lookup fields in forms and filters were not showing the correct value in some circumstances
    • Nitro App Builder: Corrected issue where combo box validation logic was enforcing the maximum value on the display field instead of the value field
    • Nitro App Builder: Corrected issue where form field descriptions could incorrectly show certain character combinations as a single double byte character
    • Nitro App Builder: SQL data source parser no longer squeezes out or adds blank spaces inside strings
    • Nitro App Builder: SQL data source parser now supports table function clause syntax
    • Nitro App Builder: SQL data source parser now supports NCHAR shorthand cast syntax
    • Nitro App Builder: SQL data source parser now allows "fetch first xx rows" inside sub query clauses
    • Nitro App Builder: SQL data source parser now accommodates WITH clauses that name the result columns -- i.e., with X (AAA,BBB,CCC) as ...
    • Nitro AutoCode: Added configuration for program name prefix in Portal Admin > Settings > AutoCode section
    • Portal Admin - Environments: added option to associate an ASP device name with specific environments (must first activate Independent ASP support in Settings)
    • RPG Toolkit - vvUtility: added optional ASP parm to getObjectList and objectExists procedures
    • RPG Toolkit - vvUtility: added optional maxColumns parameter to parseIntoCharArray procedures
    • RPG Toolkit - vvUpload: fixed issue where a file name containing double byte characters could result in a corrupted file after upload
    • Installer/Updater: Adjusted to replace any changed or newly created example Nitro Apps (data sources, widgets, apps)
    • Portal Database - VVDEVS: added new field VVASP
    Changed in Valence 5.2.20180706.0:
    • Nitro App Builder: Added authority settings for data sources, widgets and apps, controlled through new "NAB Authority" tab in Portal Admin - Users
    • Nitro App Builder: Corrected issue with removing behaviors throwing a console error
    • Nitro App Builder: Adjusted to retain order of buttons as laid out in Behaviors
    • Nitro App Builder: Adjusted to auto-switch to active tab when filtering a widget
    • Nitro App Builder: Multi column sorting and column search can now work together
    • Nitro App Builder: Eliminated unnecessary widget preview creations.
    • Nitro App Builder: RPG responses can now send booleans as text.
    • Nitro App Builder: Fix issue where the Pivot grid would sometimes not show data within preview.
    • Admin - Allow copy of data from log detail listing.
    • RPG Toolkit - vvUtility: Reinstated logic to pull VVLOGINID into data structure using deprecated vvUtility_getSessVar(VVSESSVAR) approach (recommend using vvUtility_getCurrentUser instead)
    Changed in Valence 5.2.20180629.0:
    • Nitro App Builder: Now supports longer data source and widget names
    • Nitro App Builder: Allow entry of filename for Excel downloads on edit grids (previously only allowed on regular grids)
    • Nitro App Builder: Corrected issue where a data source could be erroneously detected as non-edit grid compatible due to sub-select
    • Nitro App Builder: Corrected issue where filtered wizard-based data sources applied to grids that also contain a filter would cause Excel download to fail
    • Nitro App Builder: Doubled max size of calculated field repository in non-SQL-based data sources (formerly 1024 chars, now 2048)
    • Nitro App Builder: Fixed Pivot Grids autoloading when hidden on initial application load.
    • Nitro App Builder: Fixed Grid color rules when evaluating field to field expression.
    • Nitro App Builder: Now hiding row number when a grid is using "allow copy of row data".
    • Nitro App Builder: Fixed issue where a form wouldn't load in App Builder designer because a field was dropped from the underlying data source.
    • Nitro App Builder: Added ability to set a title on the map widget.
    • Nitro App Builder: Added empty text option to filter fields, form fields and edit grid fields.
    • Nitro App Builder: Fixed issue where widget was automatically showing filters when not set to auto load, within a popup and being filtered already by a behavior.
    • Nitro App Builder: Added ability to default a value when adding a record via the edit grid widget
    • Nitro App Builder: Fixed Mobile date value not showing in a widget filter when it has an initial value and a date value that does not show in the edit window of an edit grid
    • Nitro App Builder: Grid widgets now update preview when column labels are changed
    • Nitro App Builder: Made "Link URL" functionality available on button and menu clicks
    • Nitro App Builder: Infinite scroll paging is no longer disabled on edit grids when global search is active
    • Nitro App Builder: Corrected issue where a console error would be thrown when using infinite scroll in conjunction with graphic fields
    • Instance Manager: Now retains defined web services on copied instances (previously was clearing them)
    • VVMIGRATE: Corrected issue that could cause some portal categories to show multiple times on launchpad after database migration to 5.2
    • VVMIGRATE: Corrected issue that could change certain app icons during migration process
    • Portal Admin - Users: Changing a user's password no longer auto-enables their profile (defers to the "enabled" checkbox instead)
    • Portal: Corrected issue where logging into portal as VVADMIN could fail when VVADMIN already exists as an IBM i profile
    • RPG Toolkit: Introduced new VVBLOB program for easy incorporation of BLOB-based images into Valence apps (watch for blog post on this concept)
    • 5250-to-Valence link (VVRMTCALL): Added support for SSL-encrypted sites ("https" prefix on URL). See blog post for example of how this concept works.
    • Nitro iAdmin: Corrected issue that could cause MSGW when "beautifying" 2nd level message text on *SYSOPR messages
    • General: Added support for Hebrew characters (CCSID 424)
    • Order Entry Example Nitro App: Corrected RPG code to support adding lines to an existing order (avoid duplicate record SQL error)
    New Features in Valence 5.2 (initial build):
    • Key New Feature: Prior versions of Valence required Ext JS to participate in portal security and session management. With Valence 5.2, apps written in any language or framework can now participate in portal security and session management. Simply include the new valence.js script in your index.html file to write apps in Ext JS, React, Angular and others.
    • Key New Feature: Introducing valence-connect: use this package when developing Valence apps with Node.js to replace or supplement RPG. https://www.npmjs.com/package/valence-connect for more info.
    • Key New Feature: Significantly improved Nitro App Builder UI to be more intuitive and have a larger widget preview area
    • Key New Feature: Introducing Valence Universal. Although we continue to believe and invest in the unique power of IBM i, Valence Universal provides a pathway to other platforms to accommodate changing business requirements. Your apps developed with Node.js for Valence on IBM i can also run on Linux, Windows or OS X through Valence Universal. Existing customers can request a test copy of Valence Universal by emailing support@cnxcorp.com.
    • Nitro App Builder: this feature of Valence is renamed from Nitro Query App Builder in Valence 5.1; use of the word "Query" is dropped because Nitro App Builder is now suited for developing all types of apps beyond just "queries"
    • Nitro App Builder: added new data caching feature for slow-loading data sources
    • Nitro App Builder: Added ability to apply one or more "tags" to data sources, widgets and apps for easier filtering
    • Nitro App Builder: Added ability to have dynamically changing app bar titles
    • Nitro App Builder: Added ability to make RPG calls from any behavior
    • Nitro App Builder: Added ability to perform app actions based on response of RPG calls
    • Nitro App Builder: Added ability to trigger multiple actions from a single behavior
    • Nitro App Builder: Significantly enhanced the forms widget to include input and better layout
    • Nitro App Builder: Popup widgets now have same behavior capabilities as other widgets
    • Nitro App Builder: Added ability to choose icons for buttons
    • Nitro App Builder: Added ability to copy a widget
    • Nitro App Builder: Added ability to create carousel to move between sections (can be set to rotate automatically for kiosk mode)
    • Nitro App Builder: Added ability for user to configure pivot grid options
    • Nitro App Builder: Added serveral example Nitro Apps to demonstrate features
    • Nitro App Builder: Color rules can now reference one or more data source columns
    • Valence Portal: Now updates last signon date/time of IBM i user profile
    • Valence Portal (desktop): Added true full-screen capability
    • Portal Admin: Added section for analyzing call logs
    • Portal Admin-->Settings: Added new settings for purging log entries
    • Errors App: changed to use system timestamp to calculate time durations
    • Examples App: Enhanced the source view
    • Examples App: Added Valence examples written in React, Angular and Vue JS
    • iAdmin: Various searching fixes
    • Test Call: Changed to handled response based on type; if csv, xls or xlsx automatically download, if pdf show inline
    System Requirements:
    • Any hardware running the IBM i operating system V7R1 or higher. For installation of Valence Framework 5.2 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.
    • To use Valence on iOS devices, install the Valence Portal from the Apple App Store
    • To use Valence on Android devices, install the Valence Portal from the Google Play Store
    Uninstalling Valence Framework 5.2:
    • 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 VALENCE52 Apache server instance with command "ENDTCPSVR SERVER(*HTTP) HTTPSVR(VALENCE52)".
    • Before continuing, be certain there are no users and/or developers with a lock on the VALENCE52 library with command "WRKOBJLCK OBJ(VALENCE52) OBJTYPE(*LIB)". If there are any jobs listed, cancel them or ask the users/developers to exit.
    • Delete the VALENCE52 library with command "DLTLIB LIB(VALENCE52)".
    • Delete the IFS folder named /valence-5.2 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.2 folder.
    • Delete the VALENCE52 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 VALENCE52 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; 12-07-2018, 06:00 PM.

  • #2
    Valence for IBM i 5.2 is now available for download. It includes great new features like a slick low-code app builder, Node.js integration and support for all JavaScript UI frameworks. Click here for the full release notes.

    Comment


    • #3
      Valence Framework 5.2.20180629.1 is now available. Changes in this build since the previous release are:
      • Nitro App Builder: Now supports longer data source and widget names
      • Nitro App Builder: Allow entry of filename for Excel downloads on edit grids (previously only allowed on regular grids)
      • Nitro App Builder: Corrected issue where a data source could be erroneously detected as non-edit grid compatible due to sub-select
      • Nitro App Builder: Corrected issue where filtered wizard-based data sources applied to grids that also contain a filter would cause Excel download to fail
      • Nitro App Builder: Doubled max size of calculated field repository in non-SQL-based data sources (formerly 1024 chars, now 2048)
      • Nitro App Builder: Fixed Pivot Grids autoloading when hidden on initial application load.
      • Nitro App Builder: Fixed Grid color rules when evaluating field to field expression.
      • Nitro App Builder: Now hiding row number when a grid is using "allow copy of row data".
      • Nitro App Builder: Fixed issue where a form wouldn't load in App Builder designer because a field was dropped from the underlying data source.
      • Nitro App Builder: Added ability to set a title on the map widget.
      • Nitro App Builder: Added empty text option to filter fields, form fields and edit grid fields.
      • Nitro App Builder: Fixed issue where widget was automatically showing filters when not set to auto load, within a popup and being filtered already by a behavior.
      • Nitro App Builder: Added ability to default a value when adding a record via the edit grid widget
      • Nitro App Builder: Fixed Mobile date value not showing in a widget filter when it has an initial value and a date value that does not show in the edit window of an edit grid
      • Nitro App Builder: Grid widgets now update preview when column labels are changed
      • Nitro App Builder: Made "Link URL" functionality available on button and menu clicks
      • Nitro App Builder: Infinite scroll paging is no longer disabled on edit grids when global search is active
      • Nitro App Builder: Corrected issue where a console error would be thrown when using infinite scroll in conjunction with graphic fields
      • Instance Manager: Now retains defined web services on copied instances (previously was clearing them)
      • VVMIGRATE: Corrected issue that could cause some portal categories to show multiple times on launchpad after database migration to 5.2
      • VVMIGRATE: Corrected issue that could change certain app icons during migration process
      • Portal Admin - Users: Changing a user's password no longer auto-enables their profile (defers to the "enabled" checkbox instead)
      • Portal: Corrected issue where logging into portal as VVADMIN could fail when VVADMIN already exists as an IBM i profile
      • RPG Toolkit: Introduced new VVBLOB program for easy incorporation of BLOB-based images into Valence apps (watch for blog post on this concept)
      • 5250-to-Valence link (VVRMTCALL): Added support for SSL-encrypted sites ("https" prefix on URL). See blog post for example of how this concept works.
      • Nitro iAdmin: Corrected issue that could cause MSGW when "beautifying" 2nd level message text on *SYSOPR messages
      • General: Added support for Hebrew characters (CCSID 424)
      • Order Entry Example Nitro App: Corrected RPG code to support adding lines to an existing order (avoid duplicate record SQL error)
      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2.

      Go to http://forums.cnxcorp.com/node/12179 for full release notes.
      Last edited by robert.swanson; 07-05-2018, 04:13 PM.

      Comment


      • #4
        Valence Framework 5.2.20180706.0 is now available. Changes in this build since the previous release are:
        • Nitro App Builder: Added authority settings for data sources, widgets and apps, controlled through new "NAB Authority" tab in Portal Admin - Users
        • Nitro App Builder: Corrected issue with removing behaviors throwing a console error
        • Nitro App Builder: Adjusted to retain order of buttons as laid out in Behaviors
        • Nitro App Builder: Adjusted to auto-switch to active tab when filtering a widget
        • Nitro App Builder: Multi column sorting and column search can now work together
        • Nitro App Builder: Eliminated unnecessary widget preview creations.
        • Nitro App Builder: RPG responses can now send booleans as text.
        • Nitro App Builder: Fix issue where the Pivot grid would sometimes not show data within preview.
        • Admin - Allow copy of data from log detail listing.
        • RPG Toolkit - vvUtility: Reinstated logic to pull VVLOGINID into data structure using deprecated vvUtility_getSessVar(VVSESSVAR) approach (recommend using vvUtility_getCurrentUser instead)
        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2.

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

        Comment


        • #5
          Valence Framework 5.2.20180817.1 is now available (originally released as .0). Changes in this build since the previous release are:
          • Nitro File Editor: Adjusted maximum value/maximum length on numeric fields to take into consideration negative sign and decimal point
          • Nitro File Editor: Now traps attempts to place invalid characters into graphic fields with non-standard CCSIDs (i.e., CCSID 300)
          • Nitro App Builder: Map widget now allows for markers to display the index number of the data
          • Nitro App Builder: Map widget can now draw a contiguous path between markers.
          • Nitro App Builder: Added pivot grid option to lock the left axis columns (only valid if running on a desktop)
          • Nitro App Builder: Adjusted pivot grid to only show prefix/suffix text when value is not null/undefined
          • Nitro App Builder: Fixed pivot grid user configuration so it shows the top axis field labels correctly; Configuration section is now collapsed on startup
          • Nitro App Builder: Corrected issue where lookup fields in forms and filters were not showing the correct value in some circumstances
          • Nitro App Builder: Corrected issue where combo box validation logic was enforcing the maximum value on the display field instead of the value field
          • Nitro App Builder: Corrected issue where form field descriptions could incorrectly show certain character combinations as a single double byte character
          • Nitro App Builder: SQL data source parser no longer squeezes out or adds blank spaces inside strings
          • Nitro App Builder: SQL data source parser now supports table function clause syntax
          • Nitro App Builder: SQL data source parser now supports NCHAR shorthand cast syntax
          • Nitro App Builder: SQL data source parser now allows "fetch first xx rows" inside sub query clauses
          • Nitro App Builder: SQL data source parser now accommodates WITH clauses that name the result columns -- i.e., with X (AAA,BBB,CCC) as ...
          • Nitro AutoCode: Added configuration for program name prefix in Portal Admin > Settings > AutoCode section
          • Portal Admin > Environments: added option to associate an ASP device name with specific environments (must first activate Independent ASP support in Settings)
          • RPG Toolkit - vvUtility: added optional ASP parm to getObjectList and objectExists procedures
          • RPG Toolkit - vvUtility: added optional maxColumns parameter to parseIntoCharArray procedures
          • RPG Toolkit - vvUpload: fixed issue where a file name containing double byte characters could result in a corrupted file after upload
          • Installer/Updater: Adjusted to replace any changed or newly created example Nitro Apps (data sources, widgets, apps)
          • Portal Database - VVDEVS: added new field VVASP
          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2.

          Go to http://forums.cnxcorp.com/node/12179 for full release notes.
          Last edited by robert.swanson; 08-21-2018, 07:46 PM.

          Comment


          • #6
            Valence Framework 5.2.20180920.0 is now available. Changes in this build since the previous release are:
            • Nitro App Builder: Adjusted export routine to accommodate portal environments where QTEMP is ahead of Valence library
            • Nitro App Builder: Corrected issue where an SQL-filtered data source linked to a filtered widget could cause an SQL error (double WHERE clause) when downloading to Excel
            • Nitro App Builder: Added support for searching on character columns that are in a different CCSID than the job (activated in Portal Admin>Settings)
            • Nitro App Builder: Buttons attached to forms were not properly passing record data as a parameter when configured to "Launch App"
            • Nitro App Builder: Added support for functions in ORDER BY clause of SQL-based data structures
            • Nitro File Editor: Added support for searching on character columns that are in a different CCSID than the job (activated in Portal Admin>Settings)
            • Nitro AutoCode: Added support for searching on character columns that are in a different CCSID than the job (activated in Portal Admin>Settings)
            • Portal Admin - Settings: Added new SQL_UNICODE_FILTER to accommodate unicode-based searching on character columns that are in a different CCSID than the job (activated by default for Japanese sites)
            • Portal Admin - Web Services: Added option to support partial match of web service URL
            • RPG Toolkit - vvUtility: Replaced hard-coded backslash with special BS constant to avoid conversion issues in certain CCSIDs
            • RPG Toolkit - vvIn: Added new global control to skip conversion of POST to GET when processing web service calls (allows use of HTTP_METHOD with vvIn_Body)
            • RPG Toolkit - vvSecure: Added support for partial match of web service URL (your program must check REQUEST_URI environment value to determine appropriate action)
            • Test RPG Call - corrected issue that could cause environment ID associated with devToken session to be overridden to the environment ID associated with the Portal session
            Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.2.

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

            Comment

            Working...
            X