• If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

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.20190424.0, released on April 24, 2019
    5.2.20190307.0, released on March 7, 2019
    5.2.20190218.1, released on February 18, 2019
    5.2.20190125.0, released on January 25, 2019
    5.2.20181215.2, released on December 15, 2018
    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.

    Changed in Valence 5.2.20190424.0
    • Nitro App Builder - added ability to have columns in a grid widget that are initially hidden
    • Nitro App Builder - added ability to have a URL Widget inside a popup
    • Nitro App Builder - added new utility behavior "Reset & Primary" for form widgets. This will reset the form fields and mimic a click of the primary button.
    • Nitro App Builder - added vvIn_char and vvIn_num support within data sources
    • Nitro App Builder - adjusted to automatically focus available fields/components on launch/activate of the application in the desktop portal
    • Nitro App Builder - default filter field location is now Toolbar (previously Overlay)
    • Nitro App Builder - pivot grid default summary function is now Total (previously Count)
    • Nitro App Builder - search function inside NAB editor on filter tab now includes name column (previously only looked at description)
    • Nitro App Builder - added new "hover" option to pegs on map widget (previously only option was for users to click each peg to see label)
    • Nitro App Builder - download to Excel now supported on remote database
    • Nitro App Builder - corrected paging problem on grid widgets pulling from a remote database, specific to older versions of SQL Server (2008 and prior)
    • Nitro App Builder - usage count details
    • Nitro App Builder - user filter date field transformed to a combobox was not working
    • Nitro Source Editor - expanded folder capacity (previously limited to 4000)
    • Instance Manager - added a load mask that will show on app launch until all instance records are loaded and rendered
    • App Usage app - corrected bug where once the from date is selected forward it would not allow you to go backward
    • Portal - expanded environment library list capacity from 46 to 250 (VVSESSDATA.VVLIBLIST expanded from 500 to 2750)
    • Portal - expanded VVSETTINGS.VVVALUE from 1024 to 4096 to accommodate longer settings - such as Java Classpath - in Portal Admin>Settings
    NOTE: If you are using remote database functionality, you must go into Portal Admin > Remote Databases and re-save one of the remote DB connections (any one), in order to have the system properly update the Java Classpath. This is necessary to support new download-to-Excel functionality and prevent a MSGW condition.





    Changed in Valence 5.2.20190307.0
    • Nitro App Builder - Corrected issue where a view or table containing one or more null column labels would truncate the list of available filter fields on a grid widget
    • Nitro App Builder - Added two new parameters (column & grid) that will be sent to grid widget's column custom formatting method, allows for programmatically overriding column headers
    • Nitro App Builder - Corrected issue where a validation program specified on an edit grid would carry over as the default on a newly created edit grid
    • Nitro App Builder - Corrected issue where filtering data over a data source using "DISTINCT" would improperly include "DISTINCT" in the WHERE clause
    • Nitro App Builder - Default location can now be set directly on the map widget
    • Nitro App Builder - Added filters to widget data requests so that vvIn_parm() can access them in an SQL statement
    • Nitro App Builder - Added new Valence setting to globally override the data source Ajax/XHR request timeout value (default is 30 seconds)
    • Nitro File Editor - Added optional parameters so developers can alter the behavior of File Editor app (i.e., run in "view only" mode)
    • Nitro File Editor - Add download-to-PDF option
    • Nitro File Editor - Adjusted so a date field can be blanked out (results in 0001-01-01 for the field value)
    • Active Sessions: Now shows pertinent web service and dev token information in the detail panel
    • Portal Admin - Groups: Increased back-end array capacity to accommodate groups containing more than 999 users
    • RPG Toolkit - vvOut: Fixed issue where an attempt to download a spreadsheet with no sort fields would trigger an SQL error. This also applies to NAB grids with no "order by" clause in the underlying data source.
    • RPG Toolkit - vvUtility_getLiteral: Fixed issue where an attempt to retrieve a language literal on a web service or PHP call could result in a storage overflow / MSGW condition
    • Desktop Portal: Added ability to supply badges to app tiles on the launchpad
    Changed in Valence 5.2.20190218.1
    • Nitro App Builder: Corrected issue where grid widget in mobile was not resetting grid cell colors when paging results
    • Nitro App Builder: Re-engineered how front-end pulls and manages the PDF font package when the language is Japanese.
    • Nitro App Builder: Adjusted to accommodate SQL Aliases in place of file names
    • Nitro App Builder: Fixed issue where download PDF would break on an edit grid widget containing summary columns
    • Nitro App Builder: Adjusted grid widget so when user filters by a column and then sorts by that same column, the original column header color indicating the column is filtered is retained
    • Nitro App Builder: Adjusted user sort logic such that non-paging / load-all grids are resorted within the browser instead of reloading through a server call when a column is clicked
    • Nitro App Builder: Corrected issue where "initially hidden" buttons are switched back to "initially visible" after re-saving application
    • Nitro App Builder: Adjusted pivot grid to support RPG program calls on item clicks
    • Nitro App Builder: Fixed bug where map widget would sometimes show a completion status of over 100 percent when loading locations
    • Nitro App Builder: On line charts, corrected issue where "Smooth Lines" would show as checked upon edit after having been previously saved with it unchecked
    • Nitro App Builder: On bar/column/line/area charts, corrected issue where "Grid" would show as checked even after having previously been saved with it unchecked
    • Nitro App Builder: Fixed bug where the form widget wasn't auto-loaded/filtered with a URL param
    • Nitro App Builder: Ensure exported save files don't contain invalid shift-in/shift-out combinations in description due to text truncation
    • Nitro App Builder: On Windows, chart zoom only works the first time.
    • Nitro App Builder: Added new vvIn_parm SQL UDF to allow data sources to pull in URL parameters
    • Nitro iAdmin - Adjusted to prohibit entry of double-byte characters in the ignore message (Message Id, User, Job Name and When Logged In As).
    • Test RPG Call: Corrected issue where very large responses would cause app to become unresponsive
    Changed in Valence 5.2.20190125.0
    • Nitro App Builder: Now allows selection of additional columns to be made available in pivot grid user configuration
    • Nitro App Builder: The search empty text value was not being saved for edit grids
    • Nitro App Builder: Removed extraneous "Filtered" indicator that was using space atop grid widgets
    • Nitro App Builder: Corrected issue where initial filter values were not being applied on widgets launched through behavior functions
    • Nitro App Builder: Adjusted Pivot Grid to support more than 20 columns
    • Nitro App Builder: Corrected bug in remote database function - data responses exceeding 60K could cause a MSGW condition
    • Nitro App Builder: Re-engineered SQL parser in NAB data source editor to run more efficiently
    • Nitro App Builder: Added new configuration to Map widget to set the zoom level if the map is displaying only one marker "location"
    • Nitro App Builder: Added new configuration to the Map widget to set the default map type (Roadmap, Satellite, Hybrid or Terrain)
    • Nitro App Builder: Corrected issue where summary functions over grid columns would break on calculated columns containing summary functions
    • Nitro App Builder: Added FROM clause subquery support to SQL-based data sources
    • Nitro App Builder: When filter from a form, not all data source fields were being retrieved when performing the filter process
    • Nitro App Builder: Adjusted to avoid throwing unnecessary SQL0443 errors to job log on data sources containing calculated columns
    • Nitro App Builder: Adjusted form input fields to handle decimal precision properly (previously was rounding)
    • Nitro App Builder: Corrected issue where form widget (in mobile) would cause an error when an attempt to load data fails
    • Nitro App Builder: Added option on Grid PDF download to page break on group field data
    • Nitro App Builder: Updated SQL-based data source logic to support LEFT/RIGHT EXCEPTION JOIN syntax
    • Nitro App Builder: Adjusted grid download to excel to apply same sort as the grid
    • Nitro iAdmin: Expanded size of Notes field in message ignore list
    • Nitro iAdmin: Corrected issue where "Insufficient Authority" error message was not displaying when applicable
    • Spool File Viewer: Added hidden control to omit user spool file counts on OUTQs to improve performance on systems with huge collections of spool files
    • RPG Toolkit - vvOut_execSqlToJson: Corrected issue where sort sequence on remote DB connections was being ignored (also affects NAB data sources)
    • Portal Admin: Adjusted so that "Logs" section no longer throws console errors when encountering malformed or truncated URIs

    Changed in Valence 5.2.20181215.2
    • IBM i OS Support: Valence 5.2 builds for IBM i V5R4 and 6.1 are now available on the downloads page. Valence 5.2 for IBM i now supports the following IBM i operating systems: V5R4, 6.1, 7.1, 7.2 and 7.3.
    • Nitro App Builder: Corrected problem with form field formatting, which was not working in mobile version
    • Nitro App Builder: Improved app export function to include data sources and widgets that may be deeply nested inside filters, popups, etc.
    • Nitro App Builder: Adjusted to prohibit export of an application if any of its widgets have been updated later than the last save of the application (must re-save app, then export)
    • Nitro File Editor: Added CCSID to columns list
    • Instance Manager: Adjusted to ensure VVSQLFUNC source member references the library name of corresponding instance after updating to latest build
    • Instance Manager: Adjusted to ensure newly added demo apps are applied to updated instances
    • Portal Admin - Environments: Now waits for list of available libraries to load into combo box before allowing library entries
    • Portal: Adjusted to ensure 5250 programs launching a Valence app (following the EX5250INQ example) require an exact match on the app ID

    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_getFieldInfo: Added null flag (VVALWNULL) to response via data structure VVDSUTIL1
    • 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://support@cnxcorp.com or call CNX at (312) 477-7450.
    Last edited by robert.swanson; 06-09-2019, 09:17 AM.

  • #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, 03: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, 06: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


            • #7
              Valence Framework 5.2.20181215.2 is now available. This is a significant release with many new features and fixes. Changes in this build since the previous release are:
              • IBM i OS Support: Valence 5.2 builds for IBM i V5R4 and 6.1 are now available on the downloads page. Valence 5.2 for IBM i now supports the following IBM i operating systems: V5R4, 6.1, 7.1, 7.2 and 7.3.
              • Nitro App Builder: Corrected problem with form field formatting, which was not working in mobile version
              • Nitro App Builder: Improved app export function to include data sources and widgets that may be deeply nested inside filters, popups, etc.
              • Nitro App Builder: Adjusted to prohibit export of an application if any of its widgets have been updated later than the last save of the application (must re-save app, then export)
              • Nitro File Editor: Added CCSID to columns list
              • Instance Manager: Adjusted to ensure VVSQLFUNC source member references the library name of corresponding instance after updating to latest build
              • Instance Manager: Adjusted to ensure newly added demo apps are applied to updated instances
              • Portal Admin - Environments: Now waits for list of available libraries to load into combo box before allowing library entries
              • Portal: Adjusted to ensure 5250 programs launching a Valence app (following the EX5250INQ example) require an exact match on the app ID
              This build also formally includes the following features that were previously available only to certain customers for testing:
              • 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
              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 richard.milone; 12-19-2018, 01:04 AM.

              Comment


              • #8
                Valence Framework 5.2.20190125.0 is now available. Changes in this build since the previous release are:
                • Nitro App Builder: Now allows selection of additional columns to be made available in pivot grid user configuration
                • Nitro App Builder: The search empty text value was not being saved for edit grids
                • Nitro App Builder: Removed extraneous "Filtered" indicator that was using space atop grid widgets
                • Nitro App Builder: Corrected issue where initial filter values were not being applied on widgets launched through behavior functions
                • Nitro App Builder: Adjusted Pivot Grid to support more than 20 columns
                • Nitro App Builder: Corrected bug in remote database function - data responses exceeding 60K could cause a MSGW condition
                • Nitro App Builder: Re-engineered SQL parser in NAB data source editor to run more efficiently
                • Nitro App Builder: Added new configuration to Map widget to set the zoom level if the map is displaying only one marker "location"
                • Nitro App Builder: Added new configuration to the Map widget to set the default map type (Roadmap, Satellite, Hybrid or Terrain)
                • Nitro App Builder: Corrected issue where summary functions over grid columns would break on calculated columns containing summary functions
                • Nitro App Builder: Added FROM clause subquery support to SQL-based data sources
                • Nitro App Builder: When filter from a form, not all data source fields were being retrieved when performing the filter process
                • Nitro App Builder: Adjusted to avoid throwing unnecessary SQL0443 errors to job log on data sources containing calculated columns
                • Nitro App Builder: Adjusted form input fields to handle decimal precision properly (previously was rounding)
                • Nitro App Builder: Corrected issue where form widget (in mobile) would cause an error when an attempt to load data fails
                • Nitro App Builder: Added option on Grid PDF download to page break on group field data
                • Nitro App Builder: Updated SQL-based data source logic to support LEFT/RIGHT EXCEPTION JOIN syntax
                • Nitro App Builder: Adjusted grid download to excel to apply same sort as the grid
                • Nitro iAdmin: Expanded size of Notes field in message ignore list
                • Nitro iAdmin: Corrected issue where "Insufficient Authority" error message was not displaying when applicable
                • Spool File Viewer: Added hidden control to omit user spool file counts on OUTQs to improve performance on systems with huge collections of spool files
                • RPG Toolkit - vvOut_execSqlToJson: Corrected issue where sort sequence on remote DB connections was being ignored (also affects NAB data sources)
                • Portal Admin: Adjusted so that "Logs" section no longer throws console errors when encountering malformed or truncated URIs
                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


                • #9
                  Valence Framework 5.2.20190218.0 is now available. Changes in this build since the previous release are:
                  • Nitro App Builder: Corrected issue where grid widget in mobile was not resetting grid cell colors when paging results
                  • Nitro App Builder: Re-engineered how front-end pulls and manages the PDF font package when the language is Japanese.
                  • Nitro App Builder: Adjusted to accommodate SQL Aliases in place of file names
                  • Nitro App Builder: Fixed issue where download PDF would break on an edit grid widget containing summary columns
                  • Nitro App Builder: Adjusted grid widget so when user filters by a column and then sorts by that same column, the original column header color indicating the column is filtered is retained
                  • Nitro App Builder: Adjusted user sort logic such that non-paging / load-all grids are resorted within the browser instead of reloading through a server call when a column is clicked
                  • Nitro App Builder: Corrected issue where "initially hidden" buttons are switched back to "initially visible" after re-saving application
                  • Nitro App Builder: Adjusted pivot grid to support RPG program calls on item clicks
                  • Nitro App Builder: Fixed bug where map widget would sometimes show a completion status of over 100 percent when loading locations
                  • Nitro App Builder: On line charts, corrected issue where "Smooth Lines" would show as checked upon edit after having been previously saved with it unchecked
                  • Nitro App Builder: On bar/column/line/area charts, corrected issue where "Grid" would show as checked even after having previously been saved with it unchecked
                  • Nitro App Builder: Fixed bug where the form widget wasn't auto-loaded/filtered with a URL param
                  • Nitro App Builder: Ensure exported save files don't contain invalid shift-in/shift-out combinations in description due to text truncation
                  • Nitro App Builder: On Windows, chart zoom only works the first time.
                  • Nitro App Builder: Added new vvIn_parm SQL UDF to allow data sources to pull in URL parameters
                  • Nitro iAdmin - Adjusted to prohibit entry of double-byte characters in the ignore message (Message Id, User, Job Name and When Logged In As).
                  • Test RPG Call: Corrected issue where very large responses would cause app to become unresponsive
                  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


                  • #10

                    Valence Framework 5.2.20190307.0 is now available. Changes in this build since the previous release are:
                    • Nitro App Builder - Corrected issue where a view or table containing one or more null column labels would truncate the list of available filter fields on a grid widget
                    • Nitro App Builder - Added two new parameters (column & grid) that will be sent to grid widget's column custom formatting method, allows for programmatically overriding column headers
                    • Nitro App Builder - Corrected issue where a validation program specified on an edit grid would carry over as the default on a newly created edit grid
                    • Nitro App Builder - Corrected issue where filtering data over a data source using "DISTINCT" would improperly include "DISTINCT" in the WHERE clause
                    • Nitro App Builder - Default location can now be set directly on the map widget
                    • Nitro App Builder - Added filters to widget data requests so that vvIn_parm() can access them in an SQL statement
                    • Nitro App Builder - Added new Valence setting to globally override the data source Ajax/XHR request timeout value (default is 30 seconds)
                    • Nitro File Editor - Added optional parameters so developers can alter the behavior of File Editor app (i.e., run in "view only" mode)
                    • Nitro File Editor - Add download-to-PDF option
                    • Nitro File Editor - Adjusted so a date field can be blanked out (results in 0001-01-01 for the field value)
                    • Active Sessions: Now shows pertinent web service and dev token information in the detail panel
                    • Portal Admin - Groups: Increased back-end array capacity to accommodate groups containing more than 999 users
                    • RPG Toolkit - vvOut: Fixed issue where an attempt to download a spreadsheet with no sort fields would trigger an SQL error. This also applies to NAB grids with no "order by" clause in the underlying data source.
                    • RPG Toolkit - vvUtility_getLiteral: Fixed issue where an attempt to retrieve a language literal on a web service or PHP call could result in a storage overflow / MSGW condition
                    • Desktop Portal: Added ability to supply badges to app tiles on the launchpad
                    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 richard.milone; 03-07-2019, 07:25 PM.

                    Comment


                    • #11
                      Valence Framework 5.2.20190424.0 is now available. Changes in this build since the previous release are:
                      • Nitro App Builder - added ability to have columns in a grid widget that are initially hidden
                      • Nitro App Builder - added ability to have a URL Widget inside a popup
                      • Nitro App Builder - added new utility behavior "Reset & Primary" for form widgets. This will reset the form fields and mimic a click of the primary button.
                      • Nitro App Builder - added vvIn_char and vvIn_num support within data sources
                      • Nitro App Builder - adjusted to automatically focus available fields/components on launch/activate of the application in the desktop portal
                      • Nitro App Builder - default filter field location is now Toolbar (previously Overlay)
                      • Nitro App Builder - pivot grid default summary function is now Total (previously Count)
                      • Nitro App Builder - search function inside NAB editor on filter tab now includes name column (previously only looked at description)
                      • Nitro App Builder - added new "hover" option to pegs on map widget (previously only option was for users to click each peg to see label)
                      • Nitro App Builder - download to Excel now supported on remote database
                      • Nitro App Builder - corrected paging problem on grid widgets pulling from a remote database, specific to older versions of SQL Server (2008 and prior)
                      • Nitro App Builder - usage count details
                      • Nitro App Builder - user filter date field transformed to a combobox was not working
                      • Nitro Source Editor - expanded folder capacity (previously limited to 4000)
                      • Instance Manager - added a load mask that will show on app launch until all instance records are loaded and rendered
                      • App Usage app - corrected bug where once the from date is selected forward it would not allow you to go backward
                      • Portal - expanded environment library list capacity from 46 to 250
                      • Portal - expanded VVSETTINGS.VVVALUE from 1024 to 4096 to accommodate longer settings - such as Java Classpath - in Portal Admin>Settings
                      NOTE: If you are using remote database functionality, you must go into Portal Admin > Remote Databases and re-save one of the remote DB connections (any one), in order to have the system properly update the Java Classpath. This is necessary to support new download-to-Excel functionality and prevent a MSGW condition.

                      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; 05-03-2019, 01:10 PM.

                      Comment

                      Working...
                      X