Announcement

Collapse
No announcement yet.

Valence 5.1 (All Builds)

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

  • Valence 5.1 (All Builds)

    Versions:

    5.1.20180512.0, released on May 12, 2018
    5.1.20180316.0, released on March 16, 2018
    5.1.20180221.0, released on February 21, 2018
    5.1.20180118.0, released on January 18, 2018
    5.1.20171202.0, released on December 2, 2017
    5.1.20171103.0, released on November 3, 2017
    5.1.20171006.0, released on October 6, 2017
    5.1.20170911.0, released on September 11, 2017
    5.1.20170822.0, released on August 22, 2017
    5.1.20170808.1, released on August 8, 2017
    5.1.20170714.0, released on July 14, 2017
    5.1.20170621.0, released on June 21, 2017
    5.1.20170607.0, released on June 7, 2017
    5.1.20170530.0, released on May 30, 2017
    5.1.20170515.0, released on May 15, 2017
    5.1.20170508.0, released on May 8, 2017

    About Release Notes:

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

    Licensing:

    By obtaining and using the Valence Framework, it is your responsibility to ensure that you and your company are following the proper licensing terms of the product. Be sure to review the licensing options on the Valence Editions and Pricing page and also review the Licensing and Support FAQs page before downloading and using the Valence Framework.

    Installing This Release:
    • Go to the downloads page to see what releases are available. If this release is superseded by another release it may no longer be available.
    • If this release is available for download then click the link to the download installation file. Be sure to download the correct version of the installer for your PC operating system and for your IBM i OS (V6R1 or V7R1+).
    • It is highly recommend that you perform the installation from a PC or Mac that is on the same internal network as your IBM i. Performing the installation through a slow WAN connection or via a VPN connection may work but can take many hours to install.
    • The download is a zip file. To launch the installer extract the zip file and double click on the ValenceInstall.exe file on your Windows PC, or launch the ValenceInstall.app file on your Mac. Follow the prompts to install Valence Framework 5.1 onto your IBM i. Note that you may need administrative rights on your PC or Mac to launch the installer.
    • It is highly recommended that you use QSECOFR to perform the installation to avoid permissions issues.
    • This release will install to library VALENCE51 and ifs path /valence-5.1. It will also install an Apache server instance named VALENCE51.
    • If you have Valence Framework versions 5.0 and prior installed on your system you may install this release without affecting those earlier versions.
    • Once installed you can access the Valence Portal with the link http://xxx.xxx.xxx.xxx:7051 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7051 is the default installation port for Valence Framework 5.1. You can use Advanced Settings to change the port number at installation time.
    • The default user for administrative login to the portal after installation is vvadmin with password vvadmin. However you may also log in with any valid IBM i profile.
    • If using the vvadmin profile, it is highly recommended that you go into the Portal Admin app in the Valence Portal and add an IBM i user cross reference to vvadmin with security officer authority (like QSECOFR) so you will not have permissions issues.

    Changed in Valence 5.1.20180512.0:
    • Valence Portal for Android: Updated to support the latest version of Valence Portal app available on Google Play which now supports Android Oreo and greater.
    • RemoteDB: Fix bug which could cause connection failure under certain conditions.

    Changed in Valence 5.1.20180316.0:
    • Portal: Don't bother to pull in session security token passed as cookie if session does not have a token associated with it (i.e., due to browsers with cookies disabled)
    • Portal: Avoid unnecessary "no Session ID" security warnings in Errors log, which stem from internal calls to perform session cleanup
    • Portal: Fixed problem with temporary password functionality not working properly when using the "Valence" login method (works fine for "IBM i" method)
    • Portal: Adjusted so use of backspace key does not present portal launchpad to user when app launched via URL with &portal=false
    • Portal: Adjusted mechanism VVLOGIN uses to derive host system info. This may speed up login page rendering on some systems.
    • Remote DB: Adjusted remote database connection logic to support systems running Java version/JRE 1.5 (previously had to be 1.6 or greater)
    Changed in Valence 5.1.20180221.0:
    • Nitro Query App Builder: Added error logging for Query "button" based RPG programs
    • Nitro Query App Builder: Fixed issue where the application was failing when changing the decimal separator on edit grids
    • Nitro Query App Builder: Added ability to change the order of the tabs in the application
    • Nitro Query App Builder: Fix bug where filtering by grid column was broken if the column was boolean
    • Nitro Query App Builder: Fix bug that would cause the application to issue an error if a grid widget has multi sorters and placed on the first tab of an application
    • Nitro Query App Builder: Fix bug that would cause the application to issue an error when moving down a vertical container system widget
    • Nitro Query App Builder: Fix bug on map widget that was causing it to not display missing locations in the list
    • Nitro Query App Builder: Fix bug that would cause an application setup with tabs to lose the current tabs when removing a single tab
    • Nitro Query App Builder: Fix bug that would cause duplicate entries in the data source/widget listing when filtering by widget type
    • Nitro Query App Builder: Fix bug that was hiding fields already used to filter a data source when editing the data source
    • Nitro Query App Builder: Adjusted SQL data sources to support statements that have a with clause containing a compound statement
    • Nitro Query App Builder: Improved small display device rendering for Query apps containing multiple widgets, tabs, sections or behaviors
    • Nitro Query App Builder: Corrected issue in which WHERE clause on an SQL data source would not be applied in a widget's summary function
    • Nitro File Editor: Corrected issue where integer fields would show in field list as 4A instead of 10,0
    • Instance Manager: Corrected issue where sessions with no active session records would show active session count of prior listed instance
    • Portal: Added failsafe to vvSecure_killSession to prevent record lock condition that could occur when two users log in at almost precisely same time
    • VVLOGIN: Corrected problem that would cause *CUSTOM sid generation calls to fail when attempted outside of CGI environment

    Changed in Valence 5.1.20180118.0:

    Important Note: If you have any Nitro Query apps with buttons calling RPG programs you must recompile those programs after installing this build. Failure to do so will cause unexpected results.
    • Nitro Query App Builder: Added support for long calculations in join clause (previously only supported calculations of up to 50 chars)
    • Nitro Query App Builder: Fixed issue with Pivot Grid and infinite scrolling grids linked to data sources with an RPG prep program. The RPG prep program was called for each pre-fetch which resulted in incorrect data.
    • Nitro Query App Builder: Fixed issue with the Pivot Grid not rendering when placed in any tab other than the first one
    • Nitro Query App Builder: Added right-click option to grid widgets so user can reset the column state to default values
    • Nitro Query App Builder: Added ability to specify widths per app section
    • Nitro Query App Builder: Fix - when initially creating an edit grid widget the "Allow Remove" was not displaying in the configuration
    • Nitro Query App Builder: Added warning when a data source is going to be updated in such a way that associated edit grids can no longer add/edit/delete records
    • Nitro Query App Builder: Added ability to set a specific width of a filter field instead of it dynamically setting it based off the field length/type
    • Nitro Query App Builder: Added ability to specify a fixed height on a widget
    • Nitro Query App Builder: Adjusted import routine to apply Default Group ID (from Portal Admin/Settings) on Query Apps imported for the first time
    • Nitro Query App Builder: Adjusted edit grid to accommodate data sources with up to 999 fields (previously could only accommodate up to 127)
    • Nitro Query App Builder: When a grid is configured to neither page nor use infinite scroll, the number of results has been increased to 5000 (previously 500)
    • Nitro Query App Builder: Fixed issue in which EXQRYBTN-derived programs (RPG programs called from a button click) would crash if a large number of records were selected in the attached grid
    • Nitro Query App Builder: Added new "Post" section when configuring grids (see tip-of-the-month blog post)
    • RPG Toolkit - vvUtility_qShell: Adjusted logic so that QSH commands run in remote job do not require an Enterprise license to execute
    • RPG Toolkit - vvUtility_qShell/VVRMTDB: Adjusted to support QSH commands being executed outside of Valence CGI job (i.e., calling vvOut_execSQLtoSS from an interactive green screen session). Previously was deleting data queues unexpectedly.
    • RPG Toolkit - vvUtility_getFieldInfo: Adjusted logic to accommodate files where field descriptions and column headings are encoded to CCSID 65535, resulting in no field descriptions showing in Nitro Query data sources, File Editor, etc.
    • RPG Toolkit - vvUtility_getFieldInfo: Adjusted to explicitly identify integer fields as numeric (type "I") rather than binary (type "B")
    • RPG Toolkit - vvUtility_getCurrentUser: Avoid MSGW condition when *omit is passed for email parm and firstName and/or lastName parm is passed
    • Nitro File Editor: Always Load the first page when a filter is applied to the results
    • Nitro File Editor: Now allows filtering on the same field multiple times
    • Instance Manager: Now shows the number of active sessions and last activity date for each instance
    • Installer: Corrected problem with new values in VVFILEXT not being propagated into updated instances
    • Portal Admin: Fix - when saving an app, if the "Groups" store is filtered it will no longer omit any of those filtered out groups when saving the app
    • Portal Admin: Group names were being double encoded when selected to be added to an app or user
    • Portal Admin: Environment name was double encoded when selected to be added to a user
    • Portal: In some cases the environment name was showing invalid characters due to double encoding issue
    Changed in Valence 5.1.20171202.0:
    • Nitro Query App Builder: Ignore SQL0012 (Correlation without qualification) warnings when creating an SQL-based data source
    • Nitro Query App Builder: Corrected issue with application-level buttons not retaining the order specified in Behaviors
    • Nitro Query App Builder: New feature added to allow conversion of a standard wizard-based data source into an SQL-based data source
    • Nitro Query App Builder: Add support for exception joins in SQL-based data sources.
    • Nitro Query App Builder: Add support for order by allowing for the columns index instead of the column name/alias in a SQL-based data source.
    • Nitro Query App Builder: Adjust logic when a widget is set to automatically refresh to only perform the refresh if no windows are currently visible.
    • Nitro Query App Builder: If a widget has filters with default values only autoload the widget with those values if the widget Auto Load property is checked "true"
    • Nitro Query App Builder: Corrected issue where a grid filter using "Contains" or "Starts with" along with an initial value would cause an SQL error
    • Nitro Query App Builder: Data source pre-execution program name being double encoded.
    • Nitro Query App Builder: SQL-based data source added "exists" support.
    • Nitro AutoCode: Fixed problem with popup windows not centering correctly.
    • Nitro iAdmin - VVSYSMON: Adjusted email subject for notification of severe messages not needing a reply (to differentiate from MSGW notifications)
    • Spool File Viewer: Spool files are now limited to the current user by default; You can switch to listing all users by unchecking the "user XXXX only" checkbox.
    • Portal: Adjusted to trigger call to exit program for password change when temporary password is used to log in
    • Portal: Do not attempt to initiate any Portal tours if "portal=false" is specified in the url
    • RPG Toolkit - vvUtility_isLocked: Ensure session corresponding to locked record is still active before treating as bonafide lock
    • RPG Toolkit - vvUtility_qShell: New procedure for executing QSH commands. Can be set to run in separate job so as to not interfere with Apache.
    • Installer: Corrected issue in JAVA_CLASSPATH setting that could cause first-time Valence installs to have problems using email functionality

    Changed in Valence 5.1.20171103.0:
    • Nitro Query App Builder: Allow "force uppercase" setting to apply to graphic fields on edit grids
    • Nitro Query App Builder: Adjusted global searches on grids to skip any calculated columns containing aggregating functions (SUM, MAX, etc), as SQL does not support this
    • Nitro Query App Builder: Adjusted SQL parser/regenerator in Data Sources to recognize the LEFT JOIN clause (synonymous with LEFT OUTER JOIN)
    • Nitro Query App Builder: Adjusted widget filter date fields to ensure they show the complete date (avoid truncation of the date value).
    • Nitro Query App Builder: When using "select * from ..." on an SQL-based data source and multiple tables are specified, fixed issue where the parser would sometimes not pull in all the columns for the tables
    • Nitro Query App Builder: Added "Starts with" and "Contains" as filter field options for widgets
    • Nitro Query App Builder: Added support for filtering on calculated columns
    • Nitro Query App Builder: Hitting ENTER key while inside a filter field now automatically applies the filter value(s) to underlying widget
    • Nitro Query App Builder: Fix filter field width being too small in certian conditions.
    • Nitro Query App Builder: Fix buttons added directly to pivot grids not performing actions in desktop/mobile.
    • Nitro Query App Builder: Added support for including calculated columns on a join via the data source wizard (go back to step 2 after creating calculated field(s) in step 3)
    • Nitro iAdmin: Added support for multiple email addresses (separated by comma) in MSGW and Subsystem monitor settings
    • Nitro iAdmin: Added option to send notification of *SYSOPR messages not requiring a reply (subject to new minimum severity threshold in Portal Admin > Settings)
    • Nitro iAdmin: Phone version incorrectly showing "Ignore" option when viewing a held job.
    • Nitro iAdmin: When moving a spool file, the list of available output queues does not scroll.
    • Nitro iAdmin: Error occurs when releasing/holding/deleting a spooled file.
    • RPG Toolkit - vvMail: Added option to send mail using TLS authentication to an external SMTP server
    • RPG Toolkit - vvOut: Added SRTSEQ=*LANGIDSHR to SQL options to ensure searches on character fields are case-insensitive
    • RPG Toolkit - vvSecure: When calling an exit program on logout, ensure record lock on session record (VVSESSDATA) is reestablished after call
    • RPG Toolkit - vvUtility: Adjusted parse routine to accommodate missing elements in individual JSON array records (i.e., via vvIn_JSON)
    • RPG Toolkit - vvUtility: Corrected issue that would cause _getFieldInfo to go into MSGW if a field had 10 or more decimal positions
    • VVMIGRATE: Corrected issue that would cause custom app records in specific older 5.0 builds to not copy over to 5.1
    • Portal - Make sure if the user is searching for an auto start application in user settings to not hide the search field.

    Changed in Valence 5.1.20171006.0:
    • Nitro Query App Builder: Ensure "autoload" setting is always observed on grid apps
    • Nitro Query App Builder: On back-end RPG processing of button calls, corrected MSGW condition that could occur when a global filter is applied to grid
    • Nitro Query App Builder: Adjusted available columns in widget maintenance to match the order specified in the underlying data source
    • Nitro Query App Builder: Corrected issue that could cause optional parms from other app records to "bleed" into newly created app records
    • Nitro Query App Builder: Ensure spreadsheets downloaded from remote DB-based queries pull data from appropriate remote server
    • Nitro Query App Builder: Adjusted to prohibit creating edit grids over remote data sources. JDBC does not support updating records by RRN.
    • Nitro Query App Builder: Corrected edit grid issue where numeric fields that are cleared out by user triggers an SQL error (no value assigned)
    • Nitro Query App Builder: Corrected scrolling problem on edit grids -- was jumping back to page 1 after editing a record on page 2+
    • Nitro AutoCode: Removed library from file prompt, as files are always assumed to be in the current environment library list
    • Nitro iAdmin: Added wildcard support to message ignores (so CPF10* would ignore any error beginning with "CPF10")
    • Desktop Portal: Corrected problem where exit program for login process was not overriding library list or passing session info
    • Remote DB: Corrected issue where some numeric fields would show as character on remote JDE files
    • VVMIGRATE: Ensure max open apps for mobile/touch (VVAPPS/VVMAXOPNT) is migrated from older instance when it exists
    • Nitro Query App Builder - Data Source SQL parser: Added support for WITH compound statements and fetch first row only/fetch first X rows only on those compound statements
    • RPG Toolkit - VVOUT: on _execSQLtoJSON, truncate data and terminate routine when response size reaches 16MB (instead of going MSGW). Exception messages are logged into Errors app when this occurs.
    • RPG Toolkit - VVUTILITY: on _getLiteral, defer to English literal when desired non-English literal does not exist
    • RPG Toolkit - VVUTILITY: on _getFieldDefs, added automatic storage of file/field definitions into VVOBJDEF to improve performance (will use data in file rather than re-calling API when applicable)
    • RPG Toolkit - VVUTILITY: added optional 4th parm to _saveSessVar to control behavior when session variable already exists (A=Abort; R=Replace)
    • IBM i Access for Web: Adjusted to ensure a 5250 app does not launch if another just-launched 5250 app has not yet completed, as 5250 app launches must be processed serially (not in parallel) within each session
    • Installer: Ensure new values in VVFILEXT are propagated into updated instances. A new XLSX entry in that file helps address an issue on systems where downloaded .xlsx files appear to getting "renamed" to vvcall.pgm.
    • Installer: Corrected problem with Mac version of installer where zip file appears to be corrupted when running on newer Mac OS X levels

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

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

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

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

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

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

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

    Comment


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

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

      Comment


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

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

        Comment


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

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

          Comment


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

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

            Comment


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

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

              Comment


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

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

                Comment


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

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

                  Comment


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

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

                    Comment


                    • #11
                      Valence Framework 5.1.20171006.0 is now available. Changes in this build since the previous release are:
                      • Nitro Query App Builder: Ensure "autoload" setting is always observed on grid apps
                      • Nitro Query App Builder: On back-end RPG processing of button calls, corrected MSGW condition that could occur when a global filter is applied to grid
                      • Nitro Query App Builder: Adjusted available columns in widget maintenance to match the order specified in the underlying data source
                      • Nitro Query App Builder: Corrected issue that could cause optional parms from other app records to "bleed" into newly created app records
                      • Nitro Query App Builder: Ensure spreadsheets downloaded from remote DB-based queries pull data from appropriate remote server
                      • Nitro Query App Builder: Adjusted to prohibit creating edit grids over remote data sources. JDBC does not support updating records by RRN.
                      • Nitro Query App Builder: Corrected edit grid issue where numeric fields that are cleared out by user triggers an SQL error (no value assigned)
                      • Nitro Query App Builder: Corrected scrolling problem on edit grids -- was jumping back to page 1 after editing a record on page 2+
                      • Nitro AutoCode: Removed library from file prompt, as files are always assumed to be in the current environment library list
                      • Nitro iAdmin: Added wildcard support to message ignores (so CPF10* would ignore any error beginning with "CPF10")
                      • Desktop Portal: Corrected problem where exit program for login process was not overriding library list or passing session info
                      • Remote DB: Corrected issue where some numeric fields would show as character on remote JDE files
                      • VVMIGRATE: Ensure max open apps for mobile/touch (VVAPPS/VVMAXOPNT) is migrated from older instance when it exists
                      • Nitro Query App Builder - Data Source SQL parser: Added support for WITH compound statements and fetch first row only/fetch first X rows only on those compound statements
                      • RPG Toolkit - VVOUT: on _execSQLtoJSON, truncate data and terminate routine when response size reaches 16MB (instead of going MSGW). Exception messages are logged into Errors app when this occurs.
                      • RPG Toolkit - VVUTILITY: on _getLiteral, defer to English literal when desired non-English literal does not exist
                      • RPG Toolkit - VVUTILITY: on _getFieldDefs, added automatic storage of file/field definitions into VVOBJDEF to improve performance (will use data in file rather than re-calling API when applicable)
                      • RPG Toolkit - VVUTILITY: added optional 4th parm to _saveSessVar to control behavior when session variable already exists (A=Abort; R=Replace)
                      • IBM i Access for Web: Adjusted to ensure a 5250 app does not launch if another just-launched 5250 app has not yet completed, as 5250 app launches must be processed serially (not in parallel) within each session
                      • Installer: Ensure new values in VVFILEXT are propagated into updated instances. A new XLSX entry in that file helps address an issue on systems where downloaded .xlsx files appear to getting "renamed" to vvcall.pgm.
                      • Installer: Corrected problem with Mac version of installer where zip file appears to be corrupted when running on newer Mac OS X levels
                      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

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

                      Comment


                      • #12
                        Valence Framework 5.1.20171103.0 is now available. Changes in this build since the previous release are:
                        • Nitro Query App Builder: Allow "force uppercase" setting to apply to graphic fields on edit grids
                        • Nitro Query App Builder: Adjusted global searches on grids to skip any calculated columns containing aggregating functions (SUM, MAX, etc), as SQL does not support this
                        • Nitro Query App Builder: Adjusted SQL parser/regenerator in Data Sources to recognize the LEFT JOIN clause (synonymous with LEFT OUTER JOIN)
                        • Nitro Query App Builder: Adjusted widget filter date fields to ensure they show the complete date (avoid truncation of the date value).
                        • Nitro Query App Builder: When using "select * from ..." on an SQL-based data source and multiple tables are specified, fixed issue where the parser would sometimes not pull in all the columns for the tables
                        • Nitro Query App Builder: Added "Starts with" and "Contains" as filter field options for widgets
                        • Nitro Query App Builder: Added support for filtering on calculated columns
                        • Nitro Query App Builder: Hitting ENTER key while inside a filter field now automatically applies the filter value(s) to underlying widget
                        • Nitro Query App Builder: Fix filter field width being too small in certian conditions.
                        • Nitro Query App Builder: Fix buttons added directly to pivot grids not performing actions in desktop/mobile.
                        • Nitro Query App Builder: Added support for including calculated columns on a join through the data source wizard (go back to step 2 after creating calculated field(s) in step 3)
                        • Nitro iAdmin: Added support for multiple email addresses (separated by comma) in MSGW and Subsystem monitor settings
                        • Nitro iAdmin: Added option to send notification of *SYSOPR messages not requiring a reply (subject to new minimum severity threshold in Portal Admin > Settings)
                        • RPG Toolkit - vvMail: Added option to send mail using TLS authentication to an external SMTP server
                        • RPG Toolkit - vvOut: Added SRTSEQ=*LANGIDSHR to SQL options to ensure searches on character fields are case-insensitive
                        • RPG Toolkit - vvSecure: When calling an exit program on logout, ensure record lock on session record (VVSESSDATA) is reestablished after call
                        • RPG Toolkit - vvUtility: Adjusted parse routine to accommodate missing elements in individual JSON array records (i.e., via vvIn_JSON)
                        • RPG Toolkit - vvUtility: Corrected issue that would cause _getFieldInfo to go into MSGW if a field had 10 or more decimal positions
                        • VVMIGRATE: Corrected issue that would cause custom app records in 5.0 to not copy over to 5.1
                        • Portal - Make sure if the user is searching for an auto start application in user settings to not hide the search field.
                        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

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

                        Comment


                        • #13
                          Valence Framework 5.1.20171202.0 is now available. Changes in this build since the previous release are:
                          • Nitro Query App Builder: Ignore SQL0012 (Correlation without qualification) warnings when creating an SQL-based data source
                          • Nitro Query App Builder: Corrected issue with application-level buttons not retaining the order specified in Behaviors
                          • Nitro Query App Builder: New feature added to allow conversion of a standard wizard-based data source into an SQL-based data source
                          • Nitro Query App Builder: Add support for exception joins in SQL-based data sources.
                          • Nitro Query App Builder: Add support for order by allowing for the columns index instead of the column name/alias in a SQL-based data source.
                          • Nitro Query App Builder: Adjust logic when a widget is set to automatically refresh to only perform the refresh if no windows are currently visible.
                          • Nitro Query App Builder: If a widget has filters with default values only autoload the widget with those values if the widget Auto Load property is checked "true".
                          • Nitro Query App Builder: Data source pre-execution program name being double encoded.
                          • Nitro Query App Builder: SQL-based data source added "exists" support.
                          • Nitro AutoCode: Fixed problem with popup windows not centering correctly.
                          • Nitro iAdmin - VVSYSMON: Adjusted email subject for notification of severe messages not needing a reply (to differentiate from MSGW notifications)
                          • Spool File Viewer: Spool files are now limited to the current user by default; You can switch to listing all users by unchecking the "user XXXX only" checkbox.
                          • Portal: Adjusted to trigger call to exit program for password change when temporary password is used to log in
                          • Portal: Do not attempt to initiate any Portal tours if "portal=false" is specified in the url
                          • RPG Toolkit - vvUtility_isLocked: Ensure session corresponding to locked record is still active before treating as bonafide lock
                          • RPG Toolkit - vvUtility_qShell: New procedure for executing QSH commands. Can be set to run in separate job so as to not interfere with Apache.
                          • Installer: Corrected issue in JAVA_CLASSPATH setting that could cause first-time Valence installs to have problems using email functionality
                          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

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

                          Comment


                          • #14
                            Valence Framework 5.1.20180118.0 is now available. Changes in this build since the previous release are:

                            Important Note: If you have any Nitro Query apps with buttons calling RPG programs you must recompile those programs after installing this build. Failure to do so will cause unexpected results.
                            • Nitro Query App Builder: Added support for long calculations in join clause (previously only supported calculations of up to 50 chars)
                            • Nitro Query App Builder: Fixed issue with Pivot Grid and infinite scrolling grids linked to data sources with an RPG prep program. The RPG prep program was called for each pre-fetch which resulted in incorrect data.
                            • Nitro Query App Builder: Fixed issue with the Pivot Grid not rendering when placed in any tab other than the first one
                            • Nitro Query App Builder: Added right-click option to grid widgets so user can reset the column state to default values
                            • Nitro Query App Builder: Added ability to specify widths per app section
                            • Nitro Query App Builder: Fix - when initially creating an edit grid widget the "Allow Remove" was not displaying in the configuration
                            • Nitro Query App Builder: Added warning when a data source is going to be updated in such a way that associated edit grids can no longer add/edit/delete records
                            • Nitro Query App Builder: Added ability to set a specific width of a filter field instead of it dynamically setting it based off the field length/type
                            • Nitro Query App Builder: Added ability to specify a fixed height on a widget
                            • Nitro Query App Builder: Adjusted import routine to apply Default Group ID (from Portal Admin/Settings) on Query Apps imported for the first time
                            • Nitro Query App Builder: Adjusted edit grid to accommodate data sources with up to 999 fields (previously could only accommodate up to 127)
                            • Nitro Query App Builder: When a grid is configured to neither page nor use infinite scroll, the number of results has been increased to 5000 (previously 500)
                            • Nitro Query App Builder: Fixed issue in which EXQRYBTN-derived programs (RPG programs called from a button click) would crash if a large number of records were selected in the attached grid
                            • Nitro Query App Builder: Added new "Post" section when configuring grids (see tip-of-the-month blog post)
                            • RPG Toolkit - vvUtility_qShell: Adjusted logic so that QSH commands run in remote job do not require an Enterprise license to execute
                            • RPG Toolkit - vvUtility_qShell/VVRMTDB: Adjusted to support QSH commands being executed outside of Valence CGI job (i.e., calling vvOut_execSQLtoSS from an interactive green screen session). Previously was deleting data queues unexpectedly.
                            • RPG Toolkit - vvUtility_getFieldInfo: Adjusted logic to accommodate files where field descriptions and column headings are encoded to CCSID 65535, resulting in no field descriptions showing in Nitro Query data sources, File Editor, etc.
                            • RPG Toolkit - vvUtility_getFieldInfo: Adjusted to explicitly identify integer fields as numeric (type "I") rather than binary (type "B")
                            • RPG Toolkit - vvUtility_getCurrentUser: Avoid MSGW condition when *omit is passed for email parm and firstName and/or lastName parm is passed
                            • Nitro File Editor: Always Load the first page when a filter is applied to the results
                            • Nitro File Editor: Now allows filtering on the same field multiple times
                            • Instance Manager: Now shows the number of active sessions and last activity date for each instance
                            • Installer: Corrected problem with new values in VVFILEXT not being propagated into updated instances
                            • Portal Admin: Fix - when saving an app, if the "Groups" store is filtered it will no longer omit any of those filtered out groups when saving the app
                            • Portal Admin: Group names were being double encoded when selected to be added to an app or user
                            • Portal Admin: Environment name was double encoded when selected to be added to a user
                            • Portal: In some cases the environment name was showing invalid characters due to double encoding issue
                            Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

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

                            Comment


                            • #15
                              Valence Framework 5.1.20180221.0 is now available. Changes in this build since the previous release are:
                              • Nitro Query App Builder: Added error logging for Query "button" based RPG programs
                              • Nitro Query App Builder: Fixed issue where the application was failing when changing the decimal separator on edit grids
                              • Nitro Query App Builder: Added ability to change the order of the tabs in the application
                              • Nitro Query App Builder: Fix bug where filtering by grid column was broken if the column was boolean
                              • Nitro Query App Builder: Fix bug that would cause the application to issue an error if a grid widget has multi sorters and placed on the first tab of an application
                              • Nitro Query App Builder: Fix bug that would cause the application to issue an error when moving down a vertical container system widget
                              • Nitro Query App Builder: Fix bug on map widget that was causing it to not display missing locations in the list
                              • Nitro Query App Builder: Fix bug that would cause an application setup with tabs to lose the current tabs when removing a single tab
                              • Nitro Query App Builder: Fix bug that would cause duplicate entries in the data source/widget listing when filtering by widget type
                              • Nitro Query App Builder: Fix bug that was hiding fields already used to filter a data source when editing the data source
                              • Nitro Query App Builder: Adjusted SQL data sources to support statements that have a with clause containing a compound statement
                              • Nitro Query App Builder: Improved small display device rendering for Query apps containing multiple widgets, tabs, sections or behaviors
                              • Nitro Query App Builder: Corrected issue in which WHERE clause on an SQL data source would not be applied in a widget's summary function
                              • Nitro File Editor: Corrected issue where integer fields would show in field list as 4A instead of 10,0
                              • Instance Manager: Corrected issue where sessions with no active session records would show active session count of prior listed instance
                              • Portal: Added failsafe to vvSecure_killSession to prevent record lock condition that could occur when two users log in at almost precisely same time
                              • VVLOGIN: Corrected problem that would cause *CUSTOM sid generation calls to fail when attempted outside of CGI environment
                              Go to https://secure.cnxcorp.com/downloads to download this release of Valence 5.1.

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

                              Comment

                              Working...
                              X