Announcement

Collapse
No announcement yet.

Valence 6.1 (All Builds)

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

  • Valence 6.1 (All Builds)

    Versions:

    6.1.20220706, released on July 6, 2022
    6.1.20220518, released on May 18, 2022
    6.1.20220425, released on April 25, 2022
    6.1.20220405, released on April 5, 2022
    6.1.20220316, released on March 16, 2022


    Licensing:

    If you are updating a Valence 6.0 instance to 6.1 and you already have a valid 6.0 license key installed, your key should update automatically for Valence 6.1 upon installation. However, in some circumstances you may need to obtain a new 6.1 key from CNX. Be sure to have a valid Valence 6.1 key applied prior to updating any production instances to Valence 6.1. Email support@cnxcorp.com to obtain a new license key if you need one.

    If you are installing Valence 6.X to an IBM i system or partition for the first time, Valence should operate automatically with a 30-day trial key. To have your trial key extended please email support@cnxcorp.com.

    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:
    • If you already have Valence 6.0 installed, the Valence 6.1 installer will automatically upgrade your Valence 6.0 base instance to Valence 6.1 in place. There is no need to run the VVMIGRATE utility as in prior major upgrades. Once your base instance is upgraded to Valence 6.1 you can then use the Instance Manager app in the base instance to update other instances as usual.
    • 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, click the link to download the installation app. Be sure to download the correct version of the installer for your PC operating system and for your IBM i OS (Valence 6.1 is compatible with 7.2, 7.3 and 7.4). For sites running on earlier operating systems you can see if older Valence versions are still available on the download. If you need assistance with finding a Valence installer compatible with your operating system contact CNX to discuss alternative installation options.
    • Follow the prompts to install Valence Framework 6.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.
    • If you are installing Valence 6.X for the first time, this release will create library VALENCE6 and ifs path /valence-6. It will also create an Apache server instance named VALENCE6. If you are updating a prior 6.X installation, then these resources will be updated accordingly.
    • If you have Valence Framework versions 5.2+ or prior installed on your system, installing this release will not affect those earlier versions.
    • Once Valence 6.1 is installed you can access the Valence Portal with the link http://xxx.xxx.xxx.xxx:7060 where xxx.xxx.xxx.xxx is the IP address of your IBM i. Port 7060 is the default installation port for all Valence 6.X versions.
    • It is recommended to log in with a security administrator IBM i user profile (like QSECOFR or a profile with similar authority) when first logging into Valence 6.1 to check operation. You can also access most administrative functions in Valence by logging in with user vvadmin, password vvadmin (this should be changed after installation). You may also try to 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.

    Features and Fixes pending for the next build:
    • NAB - Edit Grids: Adjusted to allow changing of labels on columns not included on main grid, thus allowing the edit window to show the adjusted labels
    • NAB - Edit Grids: Adjusted to eliminate the row editor if a helper program has disabled all editable columns
    • NAB - Edit Grids: Added option to conditionally allow data entry on select fields when editing or adding
    • NAB - Edit Grids: Corrected issue where "force upper case" option was disabled whenever a long table name was specified in underlying data source
    • NAB - Grids: Added BOM (byte order mark) support to CSV downloads, as some Microsoft products require it
    • NAB - Grids: Added a new app variable to enable/disable checkbox selection column
    • NAB - Grids: Added a condition to checkbox selection so checkbox can be disabled/enabled based on a value in the corresponding record
    • NAB - Grids: Adjusted styling so colored cells show through when the row is selected
    • NAB - Grids: Corrected issue causing column width calculation on PDF downloads to not work properly
    • NAB - Grids: Corrected issue in Designer where data for a newly created grid might be incorrectly deemed as non-editable even though editable fields exist
    • NAB - Forms: Added ability to set colors on labels for editable fields (previously could only be done on non-editable fields)
    • NAB - Forms: Adjusted so that buttons on the form configured to be disabled by front-end errors are now also disabled when a back-end validation program marks any field as being in error
    • NAB - Filters: Corrected issue where a prefixed data source field (i.e., F1.FieldName) may not be retrieved into a getFilter-based app variable as expected
    • NAB - Tiles: Corrected issue where a button configured to set an app variable would only work on the initial button click
    • NAB - Tiles (Mobile): Corrected issue where selected record on a tap might send incorrect record
    • NAB - Tiles (Mobile): Corrected issue where paging/scrolling might not function as expected
    • NAB - Forms: Corrected issue where, under certain circumstances, disabled field values were not being passed to any back-end programs
    • NAB - Column/Bar Charts: Adjusted so minimum bar size is 2 pixels, in order to better facilitate click actions
    • NAB - Column/Bar Charts: Adjusted so that when "display values" is activated and no max value is specified, a higher max value default will be applied to ensure displayed values are not running off the edge
    • NAB - Charts: Adjusted so that clicking on a displayed value (when activated) is equivalent to clicking on the bar/column
    • NAB - Charts: Added padding option explicitly for top/right/bottom/left sides, in addition to affecting all four sides equally
    • NAB - Charts: Corrected issue where special characters included in field names (such as #) would cause chart not to render
    • NAB - Behaviors: Features can now be activated/deactivated via app variables set to true/false. App variables are named nabFeaturexxxxxx, where xxxxxx is the assigned feature name.
    • NAB - Behaviors: Corrected issue where features assigned to row menus and icon columns could not be re-enabled once disabled by a startup program
    • NAB - Behaviors: Corrected issue where a button linked to an app variable could cause the application to not load
    • NAB - Behaviors: Corrected issue where a visible filtered widget in a popup window would cease being filtered under certain circumstances
    • NAB - Filters: Corrected issue where a "between" filter on a widget configured to remember last values would result in a console error
    • NAB - Filters (Mobile): Corrected issue where widgets configured to remember last values was only working in desktop mode
    • NAB - Data Sources: Adjusted SQL parser to accept a file field name of IN, an SQL reserved word
    • NAB - Exit Programs: Added new global indicator variable "gInNab" that will be set to *ON ('1') if the program has been called from within the NAB Designer (as opposed to from within a deployed app)
    • NAB - Exit Programs: Adjusted front-end to check for app variable changes made in a filter initial value program (EXNABIV-based programs)
    • NAB - Exit Programs: Removed inclusion of program status data structure (PSDS) in all back-end RPG logic so as not to conflict with custom needs
    • NAB - General: Applied various caching adjustments to improve performance at app launch time
    • NAB - General: To improve load performance, the Apps list in NAB Designer now shows contracted (apps only) on initial load; Nodes can then be expanded to see widgets and data sources
    • NAB - General: Corrected issue where a date/time picker over a timestamp was saving incorrect month
    • NAB - General: Corrected NAB Additional Resources to accommodate cache-busting on .css files
    • NAB - Mobile: Corrected issue where display would get corrupted when a widget in a pop-up window attempted to launch a widget in another pop-up window
    • NAB - Mobile: Corrected issue where calls to a back-end exit program responding with "refresh:true" could throw a console error
    • NAB - Export: Corrected issue where attempting to export a NAB object on a fresh install could cause a MSGW condition
    • Portal Admin - Settings: Added license expiration date as a tooltip where applicable
    • Portal Admin - General: Corrected UI issue where a filter applied to one entity could be applied unexpectedly to another entity
    • Instance Manager: Adjusted to automatically clear any cached NAB apps whenever an instance is updated. Not clearing the cache was causing changes to the Errors app to not reflect changes introduced on prior build.
    • Instance Manager: Adjusted to check QALWOBJRST value prior to proceeding with instance update or copy (must be set to *ALL or *ALWPGMADP)
    • Instance Manager: Corrected issue where a direct call from a CL program or command line to create a new instance would fail on CRTLIB attempt if 7th parameter ("instance note") was passed with less than 64 chars
    • Fusion 5250: Adjusted daemon logic to not submit a new proxy job until incoming socket communication data on specified Fusion port is confirmed to be complete
    • RPG Toolkit - vvOut_execSQLtoSS: Before attempting to create a spreadsheet file, verify user has authority to destination path
    • RPG Toolkit - vvOut_toJSON: Added logic to accommodate cases where long SQL name for a column is not supplied
    • RPG Toolkit - vvOut_toJSONpair: expanded size limit on individual name/value pairs from 5000 to 10000 characters
    • RPG Toolkit - vvIFS_pathExists: Added optional parameters to return read/write/execute authority for user
    • RPG Toolkit - vvUtility_lock: Adjusted so session ID parameter is now optional. If not passed (or set to *omit or blank) then session ID will be pulled from the current session.
    • Valence.js: Adjusted Valence.util.Helper.formatDate so that null dates (0001-01-01) are returned as blank

    New features and fixes in Valence 6.1.20220706:
    • Nitro App Builder (NAB) - Grids: Added new app variable to allow deactivation of multi-select functionality on grids that have it activated
    • NAB - Grids: Corrected issue where Excel column overrides were not functioning properly
    • NAB - Grids: Corrected issue where feature IDs assigned to icon columns or row menu buttons were not supporting an enable/disable action
    • NAB - Grids: Added support for colors and color rules on grouped columns
    • NAB - Grids: Adjusted to automatically move to page 1 when loading/reloading data
    • NAB - Grids: Corrected issue where feature activation/deactivation was not being applied to icon columns and row menus
    • NAB - Edit Grids: Corrected issue in cell-edit mode where if a back-end validation had marked a cell as invalid, and user subsequently restored cell to original value, it was not clearing the "invalid" flag (red background)
    • NAB - Data Sources: Adjusted SQL formatter to better render long CASE WHEN statements and to no longer line break on every AND/OR clause
    • NAB - Calendars: Added option to specify when week should start (i.e., Monday vs Sunday)
    • NAB - Calendars: Added option to indicate when a record should be treated as an all-day event
    • NAB - Timelines: Adjusted to apply system time zone adjustment to timezone fields, same way as handled in Calendar widget. Your IBM i timezone system setting (QTIMZON) must be set correctly to use this widget.
    • NAB - Maps: Adjusted so marker titles set to display on hover will automatically disappear when mouse moves off of marker
    • NAB - Filters: Adjusted getFilter-linked App Variables to be initialized by any initial values set on the underlying widgets
    • NAB - Forms: Added ability to add a border to form field groups when group does not have a title
    • NAB - Forms (mobile): Corrected issue where if buttons were attached to a form field and the field was hidden then shown the field or buttons would not show again
    • NAB - Tiles: Added filters and formatting/custom formatting for fields, similar to what is already available for grids
    • NAB - Exit Programs: Added new exit program to be called when an app is closed or terminated, modeled after EXNABCLOSE. Program name is specified in Behaviors - Startup/Close section
    • NAB - Exit Programs: Added option to pass an "action" to all validation/filter/initial value/form helper/startup and close RPG programs. Value is auto-populated in a new global variable called "gAction"
    • NAB - Import: Adjusted so when perusing importable SAVF objects that are not in VVEXPORTS repository, skip over any SAVF objects to which user has insufficient authority
    • NAB - Import: Adjusted created and last imported dates to adhere to date format specified in Portal Admin > Settings
    • NAB - Import: Corrected issue where apps exported from instances prior to Valence 6.0 prior would not import into Valence 6.1
    • NAB - General: Corrected issue where image overrides specified in Hook.js could, under rare circumstances, not be applied
    • NAB - General: Added new email and URL formatters to grids and forms
    • NAB - General (mobile): corrected issue where combo boxes in filters and forms were not properly accommodating a "starts with" config
    • Portal Admin - Remote DB: Expanded name and IP address to 128 characters (formerly 64)
    • Portal - General: Added two new methods to Valence.util.App so an application can programmatically add or remove apps to a user's favorites (see forum post)
    • Portal - Launchpad: Corrected issue where "Show hidden categories in nav drawer" setting in Portal Admin was not working
    • Portal - Launchpad: Corrected issue where apps could show an incorrect app name in the menu bar when restoring from prior launch and user has one or more autostart apps configured
    • Fusion5250: Adjusted to better accommodate any communication failures that occur when establishing new session
    • Errors app: Added ability to filter exceptions by user
    • Errors app: Corrected issue where attempting to delete an exception record could sometimes result in a MSGW condition
    • Instance Manager: Corrected location of VVEXPORTS file object, which should only exist in the VVEXPORT library. The instance update process will correct this.
    • General: Updated Japanese translation text

    New features and fixes in Valence 6.1.20220518:
    • Nitro App Builder (NAB) - Grids: Added new column formatter to show decimal percentage (numbers between 0.00 and 1.00) as a progress bar in the cell
    • NAB - Grids: Added new app variables to optionally focus cursor on a particular row index or RRN
    • NAB - Grids: Adjusted non-legacy Excel downloads to support column containers (aka "Super Column Headings") on generated spreadsheets
    • NAB - Grids: Added ability to override grid column colors at the app level, including via app variables
    • NAB - Grids: Added ability to conditionally set icon colors
    • NAB - Tree Grids: Corrected issue on custom renderers where grid component (fifth parameter) was not being passed
    • NAB - Charts: Corrected issue where setting a column chart to multi-series, with its own axis on the right, would cause chart to crash in Designer
    • NAB - Forms: Adjusted so fields in error that are in a hidden state still call the Form Helper program (EXNABFHLP-based programs)
    • NAB - Filter exit program: Added ability to set app variables and enable/disable filters from EXNABFLT-based programs
    • NAB - Filter exit program: Added logic for getValue to return a comma-separated list when pulling from a filter that supports multiple values (EXNABFLT-based programs)
    • NAB - Horizontal containers: Corrected issue where slider to adjust component widths was not showing in Designer
    • NAB - Tiles: Added ability to conditionally set tile button colors
    • NAB - General: Added a subtitle option to all widgets. Subtitle text may be changed via a new app variable.
    • NAB - General: Added ability to pull (get) user filter values for any widget via app variables
    • NAB - General: Corrected issue where an app variable linked to a URL parameter that was set to hide a button could hide more buttons than intended
    • NAB - General: Corrected issue where moving widgets around in the Designer, with vertical scrolling enabled, could cause display errors
    • NAB - General: Corrected issue where filters over integer columns were limiting user input to approximately half the maximum digits allowed (based on bytes rather than numeric precision)
    • Fusion5250: Added support for programs using graphical Subfile Choice Control (DDS keyword SFLCHCCTL)
    • Instance Manager: Added logic to trap attempts to upgrade any instance from an instance that is at a version below the base instance
    • File Editor: Adjusted filter function to accommodate strings with single quotes
    • Portal Admin - Users: Added paging functionality
    • Portal Admin - Apps: Added "enabled" column to apps grid
    • Portal - Login: Adjusted to allow login via email address (must be activated via new setting in Portal Admin > Settings > Login Method)

    New features and fixes in Valence 6.1.20220425:
    • Nitro App Builder (NAB) - Grids: Added ability to specify action of download/open/print on PDF downloads
    • NAB - Grids: Corrected issue where saved state could inadvertently override the autoload setting
    • NAB - Tree Grids: Adjusted to auto-expand any levels that contain a positive match on a local-search filter
    • NAB - Mobile: Expanded field widths where necessary to accommodate clear icon
    • NAB - Mobile: Corrected issue where apps were not honoring the "Initially Hidden" setting on buttons
    • NAB - Filters: Added ability to reload a user filter combobox via an app variable
    • NAB - Filters: Corrected issue where vvIn_Virtual fields in an underlying data source would not always appear as a filterable column in the widget
    • NAB - Filters: Corrected issue where default value on the "to" side of a Between filter was not always being applied
    • NAB - Filters: Corrected issue where a user filter linked to a vvIn_virtual clause would continue to "stick" after being cleared/blanked by the user
    • NAB - Behaviors: Corrected issue where Enter key listener was not functioning when calling an RPG program and prompting user for additional info
    • NAB - General: Added new "clearAllData" property on widget link to app variables, causing all widget data to be cleared when set to 'true'
    • NAB - General: Corrected issue in Designer where removing a calendar widget in a popup was leaving associated behaviors in the app
    • NAB - General: Corrected issue where saving larger apps, particularly ones with multiple pop-ups, could cause app config to become corrupted
    • NAB - Import: Corrected issue where changes to app icons, colors, etc were not overriding existing apps on import
    • NAB - Exit Programs: Corrected issue where EXNABFLT-based programs were not properly handling "contains" type filters if overriding the filter string
    • Portal Admin - Environments: Corrected issue where adjustments to tags would not appear to save
    • Portal Admin - Users: Improved rendering of users with multiple tags
    • Portal Admin - General: Adjusted back-end to accommodate earlier TRs of IBM i 7.2 and 7.3 that do not support the "listAgg" SQL function
    • Remote DB: Adjusted VVBATCH routine to not leave any open file locks, which could interfere with the update process in Instance Manager

    New features and fixes in Valence 6.1.20220405:
    • Nitro App Builder (NAB): New Calendar widget added to Designer - works with any data source containing a timestamp column. Your IBM i timezone system setting (QTIMZON) must be set correctly to use this widget.
    • NAB - Grids: Added new "HTML encode" column renderer
    • NAB - Grids: Adjusted so row background changes when user hovers over the row
    • NAB - Grids: Adjusted Excel/PDF download to recognize hyperlinks (i.e., defined as "<a href="https://cnxcorp.com">Link</a>") and render them as conventional links in the document
    • NAB - Grids: Improved auto column width calculation for PDF downloads
    • NAB - Grids: Corrected issue where checkboxes were not showing on grids with "Checkbox Row Selections" enabled
    • NAB - Grids: Corrected issue in Designer where "Checkbox Row Selections" options are not visible unless you save and go back in to edit
    • NAB - Grids (Mobile): Corrected issue where if paging and grouping were both activated, paging would not work properly
    • NAB - URL Widget: Fixed issue where close behaviors and buttons were not saving in Designer
    • NAB - Forms: Adjusted so when a tooltip is assigned to a field, a visual indicator now shows in the label so users know the tooltip exists
    • NAB - Behaviors: Corrected issue in Designer where hide/show behaviors could not be deleted
    • NAB - Filters: Corrected issue where an app variable linked to a filter field on an SQL-based data source, that had been previously converted from wizard-based, was not setting properly
    • NAB - Export/Import: Corrected issue where some widgets could be unintentionally excluded on an app export
    • NAB - General: Added exit program option on app close
    • NAB - General: Added support for timestamp(0) on renderers, calendar/timeline widgets and editable form widget fields (.1 build)
    • NAB - General (Mobile): Corrected issue where force uppercase wasn't being applied correctly (.1 build)
    • NAB Import App: Adjusted to work properly with Valence 6.1 (.1 build)
    • Portal Admin - Logs: Minor improvement to SQL statement rendering on "Log Data" tab - formerly truncated lines are now wrapping (.1 build)
    • Portal Admin - Apps: Corrected issue where filtering app list on a category would cause the category to not be available when editing app record
    • File Editor: Adjusted VVUTILITY to reset dependent logical file object definitions whenever the parent physical file is changed. This addresses issue where new fields added to a physical file were being ignored when looking at the logical.
    • VVMIGRATE: Corrected issue that was causing migration process to crash prior to completion


    New features in Valence 6.1.20220316 since final Valence 6.0 build:
    • Nitro App Builder (NAB) - Tree Grids: New widget introduced, acts as a hybrid of both a tree and a grid, fed by multiple data sources
    • NAB - Grids: Added "super column headers" (aka containers) so you can now configure headings that span across the top of multiple columns
    • NAB - Grids: Added app variables for grouped grids so rows can now be expanded/contracted by a back-end RPG program
    • NAB - Grids: In addition to saving a user's column width and arrangement overrides, stored state now also includes the grid's sort sequence
    • NAB - Grids: Moved "Reset Columns" right-click user action to column heading row; Right-clicks on data rows reverts to standard browser behavior
    • NAB - Edit Grids: Fields in the edit window can now be arranged in a sequence that is independent of the main grid columns
    • NAB - Edit Grids: Adjusted styling so selected rows stand out more clearly
    • NAB - Edit Grids: Adjusted row editor so that icon columns are not disabled while fields are open for data editing
    • NAB - User Filters: Added option to "remember" (make stateful) filter entries, so users don't have to re-key filter values on subsequent launch of app
    • NAB - Forms: Added ability to add tool tips to editable fields
    • NAB - Forms: Added ability to specify height on a text area field
    • NAB - Forms: Adjusted popup windows to allow access to all fields in underlying data source, instead of just the ones used in the form widget
    • NAB - Charts: Added a secondary axis option for transformed fields on column charts
    • NAB - Charts: Added series-specific behavior events for multi-series charts
    • NAB - Themes: Added more color options to better align with app icon color choices
    • NAB - Data Sources: Added a new back-end template for pre-execution programs (EXNABDS) that includes a mechanism for pulling in app variables
    • NAB - Data Sources: Free-form SQL parser now supports in-line table definitions in the "from" clause
    • NAB - Data Sources: Any fields in the main SELECT clause that come from WITH clauses (CTEs) can now be referenced on filters
    • NAB - Renderers: Added various time format renderers for grid columns, form fields, etc.
    • NAB - Export/Import: NAB now maintains a repository for all export save files with pertinent export info such as instance name, date, user, notes, etc.
    • NAB - Export/Import: Group membership and in-app authorities are now included on initial import of app
    • NAB - General: Security section functions have been moved to Behaviors, thereby providing a more complete picture of the app's functionality
    • NAB - General: Behavior section (formerly Security) now applies feature names to each widget/section affected by Hide/Show directives, allowing for more refined control
    • NAB - General: Added horizontal container utility widget (similar to existing vertical container), allowing for more intricate widget arrangements
    • NAB - General: Added new runtime app variables (booleans): isDesktop, isMobile, isPhone, isTablet
    • NAB - General: When listing apps, tag filter now applies only to the app-level; All underlying widgets and data sources for an included app are now listed regardless of tag
    • NAB - General: Applied numerous aesthetic improvements in the NAB Designer for widget selection, saving, etc.
    • Fusion5250: Added ability for sessions to detect a communications failure and gracefully attempt to reconnect without restarting the app
    • Spool File Viewer (also iAdmin): Added option to display spool files as PDFs, including support for AFPDS files
    • Portal Admin - Settings: Added password expiration interval for Valence-specific (non-IBM i) users
    • Portal Admin - Settings: Added option to show user's current Valence environment name in Portal header
    • Portal Admin - Apps: Added tag support, mimicking functionality already in place for apps listed in NAB Designer
    • Portal Admin - Apps: Added ability to filter apps by category
    • Portal Admin - Users: Added tags and tag/group/environment filtering
    • Portal Admin - Environments: Added tags and tag filtering
    • Portal Admin - Groups: Added tags and tag/app/user filtering
    • Portal Admin - Web Services: Added tags and tag filtering
    • Portal Admin - Logs: Added a "Log Data" tab to list any log file data for each call, so executed SQL statements will show here when they're being logged. Also improved the formatting of the Post and Response tabs.
    • Portal - Login: Added "eyeball" toggle button in password field so users can optionally see the characters they're typing
    • Portal - General: Added support for IBM i virtual serial numbers
    • Test RPG Call: Added highlighting to the JSON tab for improved readability on RPG program responses
    • Instance Manager: Added ability to make a back-end batch call to VVINSTMGR to update any instance to the latest build
    • 6.1.20220316.1: Problem with Google Maps api key used when Valence is in the trial period fixed

    Fixes applied to 6.1.20220316 since final Valence 6.0 build:
    • Nitro App Builder (NAB) - Behaviors: Corrected issue where Call RPG Program was not working with an event listener
    • NAB - Grids: Corrected issue where sorting over locked columns would not function as expected when multi-sort configuration was activated
    • NAB - Edit Grids (mobile): Miscellaneous pop-up window sizing adjustments and removal of animations from lookup field
    • NAB - Forms: Corrected issue where disabled checkbox fields were not honoring true/false overrides when passed to the back-end
    • NAB - Forms (mobile): Corrected issue where HTML markup was sometimes showing in display fields
    • NAB - Forms (mobile): Corrected issue causing checkboxes to not accept taps
    • NAB - Tiles (mobile): Corrected issue causing scrolling to not function properly
    • NAB - General (mobile): Corrected issue where date picker was not working
    • NAB - General (mobile): Adjusted so that any specified filter width is honored provided it's less than the device's display width
    • Mobile portal - Pop-ups: Corrected issue causing pop-up windows to not render after the first time displayed
    • NAB - General: Fixed issue with date picker
    • NAB - Timeline Widget: Fixed issue where widget would break if you set a group text value from a data source column
    • NAB - General: Fixed issued where in certain cases the relationships between data sources and widgets was not being displayed properly
    • RPG ToolKit - vvOut_execSQLtoJSON: Corrected issue where SQL order by clauses containing special characters would get enclosed in hard brackets. This should only occur when accessing remote databases.
    • RPG ToolKit - vvOut_execSQLtoSS: Corrected issue that would cause an overflow error on larger "legacy" Excel downloads exceeding 999,999 rows
    • Fusion5250: Adjusted to accommodate scenario in which a user's profile becomes disabled/expired after logging into Valence but prior to initiating a Fusion session. This was triggering a MSGW condition.
    • File Editor: Corrected issue where saving a view with more than 99 columns would trigger a MSGW overflow condition
    Last edited by robert.swanson; Today, 10:21 AM.

  • #2
    Valence Framework 6.1.20220405 is now available. Changes in this build since the previous release are:
    • Nitro App Builder (NAB): New Calendar widget added to Designer - works with any data source containing a timestamp column. Your IBM i timezone system setting (QTIMZON) must be set correctly to use this widget.
    • NAB - Grids: Added new "HTML encode" column renderer
    • NAB - Grids: Adjusted so row background changes when user hovers over the row
    • NAB - Grids: Adjusted Excel/PDF download to recognize hyperlinks (i.e., defined as "<a href="https://cnxcorp.com">Link</a>") and render them as conventional links in the document
    • NAB - Grids: Improved auto column width calculation for PDF downloads
    • NAB - Grids: Corrected issue where checkboxes were not showing on grids with "Checkbox Row Selections" enabled
    • NAB - Grids: Corrected issue in Designer where "Checkbox Row Selections" options are not visible unless you save and go back in to edit
    • NAB - Grids (Mobile): Corrected issue where if paging and grouping were both activated, paging would not work properly
    • NAB - URL Widget: Fixed issue where close behaviors and buttons were not saving in Designer
    • NAB - Forms: Adjusted so when a tooltip is assigned to a field, a visual indicator now shows in the label so users know the tooltip exists
    • NAB - Behaviors: Corrected issue in Designer where hide/show behaviors could not be deleted
    • NAB - Filters: Corrected issue where an app variable linked to a filter field on an SQL-based data source, that had been previously converted from wizard-based, was not setting properly
    • NAB - Export/Import: Corrected issue where some widgets could be unintentionally excluded on an app export
    • NAB - General: Added exit program option on app close
    • NAB - General: Added support for timestamp(0) on renderers, calendar/timeline widgets and editable form widget fields (.1 build)
    • NAB - General (Mobile): Corrected issue where force uppercase wasn't being applied correctly (.1 build)
    • NAB Import App: Adjusted to work properly with Valence 6.1 (.1 build)
    • Portal Admin - Logs: Minor improvement to SQL statement rendering on "Log Data" tab - formerly truncated lines are now wrapping (.1 build)
    • Portal Admin - Apps: Corrected issue where filtering app list on a category would cause the category to not be available when editing app record
    • File Editor: Adjusted VVUTILITY to reset dependent logical file object definitions whenever the parent physical file is changed. This addresses issue where new fields added to a physical file were being ignored when looking at the logical.
    • VVMIGRATE: Corrected issue that was causing migration process to crash prior to completion
    Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

    Go to http://forums.cnxcorp.com/node/14769 for full release notes.
    Last edited by robert.swanson; 04-06-2022, 07:19 PM.

    Comment


    • #3
      Valence Framework 6.1.20220425 is now available. Changes in this build since the previous release are:
      • Nitro App Builder (NAB) - Grids: Added ability to specify action of download/open/print on PDF downloads
      • NAB - Grids: Corrected issue where saved state could inadvertently override the autoload setting
      • NAB - Tree Grids: Adjusted to auto-expand any levels that contain a positive match on a local-search filter
      • NAB - Mobile: Expanded field widths where necessary to accommodate clear icon
      • NAB - Mobile: Corrected issue where apps were not honoring the "Initially Hidden" setting on buttons
      • NAB - Filters: Added ability to reload a user filter combobox via an app variable
      • NAB - Filters: Corrected issue where vvIn_Virtual fields in an underlying data source would not always appear as a filterable column in the widget
      • NAB - Filters: Corrected issue where default value on the "to" side of a Between filter was not always being applied
      • NAB - Filters: Corrected issue where a user filter linked to a vvIn_virtual clause would continue to "stick" after being cleared/blanked by the user
      • NAB - Behaviors: Corrected issue where Enter key listener was not functioning when calling an RPG program and prompting user for additional info
      • NAB - General: Added new "clearAllData" property on widget link to app variables, causing all widget data to be cleared when set to 'true'
      • NAB - General: Corrected issue in Designer where removing a calendar widget in a popup was leaving associated behaviors in the app
      • NAB - General: Corrected issue where saving larger apps, particularly ones with multiple pop-ups, could cause app config to become corrupted
      • NAB - Import: Corrected issue where changes to app icons, colors, etc were not overriding existing apps on import
      • NAB - Exit Programs: Corrected issue where EXNABFLT-based programs were not properly handling "contains" type filters if overriding the filter string
      • Portal Admin - Environments: Corrected issue where adjustments to tags would not appear to save
      • Portal Admin - Users: Improved rendering of users with multiple tags
      • Portal Admin - General: Adjusted back-end to accommodate earlier TRs of IBM i 7.2 and 7.3 that do not support the "listAgg" SQL function
      • Remote DB: Adjusted VVBATCH routine to not leave any open file locks, which could interfere with the update process in Instance Manager
      Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

      Comment


      • #4

        Valence Framework 6.1.20220518 is now available. Changes in this build since the previous release are:
        • Nitro App Builder (NAB) - Grids: Added new column formatter to show decimal percentage (numbers between 0.00 and 1.00) as a progress bar in the cell
        • NAB - Grids: Added new app variables to optionally focus cursor on a particular row index or RRN
        • NAB - Grids: Adjusted non-legacy Excel downloads to support column containers (aka "Super Column Headings") on generated spreadsheets
        • NAB - Grids: Added ability to override grid column colors at the app level, including via app variables
        • NAB - Grids: Added ability to conditionally set icon colors
        • NAB - Tree Grids: Corrected issue on custom renderers where grid component (fifth parameter) was not being passed
        • NAB - Charts: Corrected issue where setting a column chart to multi-series, with its own axis on the right, would cause chart to crash in Designer
        • NAB - Forms: Adjusted so fields in error that are in a hidden state still call the Form Helper program (EXNABFHLP-based programs)
        • NAB - Filter exit program: Added ability to set app variables and enable/disable filters from EXNABFLT-based programs
        • NAB - Filter exit program: Added logic for getValue to return a comma-separated list when pulling from a filter that supports multiple values (EXNABFLT-based programs)
        • NAB - Horizontal containers: Corrected issue where slider to adjust component widths was not showing in Designer
        • NAB - Tiles: Added ability to conditionally set tile button colors
        • NAB - General: Added a subtitle option to all widgets. Subtitle text may be changed via a new app variable.
        • NAB - General: Added ability to pull (get) user filter values for any widget via app variables
        • NAB - General: Corrected issue where an app variable linked to a URL parameter that was set to hide a button could hide more buttons than intended
        • NAB - General: Corrected issue where moving widgets around in the Designer, with vertical scrolling enabled, could cause display errors
        • NAB - General: Corrected issue where filters over integer columns were limiting user input to approximately half the maximum digits allowed (based on bytes rather than numeric precision)
        • Fusion5250: Added support for programs using graphical Subfile Choice Control (DDS keyword SFLCHCCTL)
        • Instance Manager: Added logic to trap attempts to upgrade any instance from an instance that is at a version below the base instance
        • File Editor: Adjusted filter function to accommodate strings with single quotes
        • Portal Admin - Users: Added paging functionality
        • Portal Admin - Apps: Added "enabled" column to apps grid
        • Portal - Login: Adjusted to allow login via email address (must be activated via new setting in Portal Admin > Settings > Login Method)
        Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

        Comment


        • #5
          Valence Framework 6.1.20220706 is now available. Changes in this build since the previous release are:
          • Nitro App Builder (NAB) - Grids: Added new app variable to allow deactivation of multi-select functionality on grids that have it activated
          • NAB - Grids: Corrected issue where Excel column overrides were not functioning properly
          • NAB - Grids: Corrected issue where feature IDs assigned to icon columns or row menu buttons were not supporting an enable/disable action
          • NAB - Grids: Added support for colors and color rules on grouped columns
          • NAB - Grids: Adjusted to automatically move to page 1 when loading/reloading data
          • NAB - Grids: Corrected issue where feature activation/deactivation was not being applied to icon columns and row menus
          • NAB - Edit Grids: Corrected issue in cell-edit mode where if a back-end validation had marked a cell as invalid, and user subsequently restored cell to original value, it was not clearing the "invalid" flag (red background)
          • NAB - Data Sources: Adjusted SQL formatter to better render long CASE WHEN statements and to no longer line break on every AND/OR clause
          • NAB - Calendars: Added option to specify when week should start (i.e., Monday vs Sunday)
          • NAB - Calendars: Added option to indicate when a record should be treated as an all-day event
          • NAB - Timelines: Adjusted to apply system time zone adjustment to timezone fields, same way as handled in Calendar widget
          • NAB - Maps: Adjusted so marker titles set to display on hover will automatically disappear when mouse moves off of marker
          • NAB - Filters: Adjusted getFilter-linked App Variables to be initialized by any initial values set on the underlying widgets
          • NAB - Forms: Added ability to add a border to form field groups when group does not have a title
          • NAB - Forms (mobile): Corrected issue where if buttons were attached to a form field and the field was hidden then shown the field or buttons would not show again
          • NAB - Tiles: Added filters and formatting/custom formatting for fields, similar to what is already available for grids
          • NAB - Exit Programs: Added new exit program to be called when an app is closed or terminated, modeled after EXNABCLOSE. Program name is specified in Behaviors - Startup/Close section
          • NAB - Exit Programs: Added option to pass an "action" to all validation/filter/initial value/form helper/startup and close RPG programs. Value is auto-populated in a new global variable called "gAction"
          • NAB - Import: Adjusted so when perusing importable SAVF objects that are not in VVEXPORTS repository, skip over any SAVF objects to which user has insufficient authority
          • NAB - Import: Adjusted created and last imported dates to adhere to date format specified in Portal Admin > Settings
          • NAB - Import: Corrected issue where apps exported from instances prior to Valence 6.0 prior would not import into Valence 6.1
          • NAB - General: Corrected issue where image overrides specified in Hook.js could, under rare circumstances, not be applied
          • NAB - General: Added new email and URL formatters to grids and forms
          • NAB - General (mobile): corrected issue where combo boxes in filters and forms were not properly accommodating a "starts with" config
          • Portal Admin - Remote DB: Expanded name and IP address to 128 characters (formerly 64)
          • Portal - General: Added two new methods to Valence.util.App so an application can programmatically add or remove apps to a user's favorites (see forum post)
          • Portal - Launchpad: Corrected issue where "Show hidden categories in nav drawer" setting in Portal Admin was not working
          • Portal - Launchpad: Corrected issue where apps could show an incorrect app name in the menu bar when restoring from prior launch and user has one or more autostart apps configured
          • Fusion5250: Adjusted to better accommodate any communication failures that occur when establishing new session
          • Errors app: Added ability to filter exceptions by user
          • Errors app: Corrected issue where attempting to delete an exception record could sometimes result in a MSGW condition
          • Instance Manager: Corrected location of VVEXPORTS file object, which should only exist in the VVEXPORT library. The instance update process will correct this.
          • General: Updated Japanese translation text
          Go to https://secure.cnxcorp.com/downloads to download this release of Valence 6.

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

          Comment

          Working...
          X