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

Announcement

Collapse
No announcement yet.

Valence 6.1 (All Builds)

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

  • Valence 6.1 (All Builds)

    Versions:

    6.1.20230327, released on March 27, 2023
    6.1.20230224, released on February 24, 2023
    6.1.20230120, released on January 20, 2023
    6.1.20221219, released on December 19, 2022
    6.1.20221026, released on October 26, 2022
    6.1.20220912, released on September 12, 2022
    6.1.20220824, released on August 24, 2022
    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, 7.4 and 7.5). For sites running on earlier operating systems you can see if older Valence versions are still available on the download. To install to IBM i OS 7.5, please choose the installer for IBM i OS 7.4. 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:
    • *All changes have been rolled into Valence 6.2. No further updates will be made to Valence 6.1

    New features and fixes in Valence 6.1.20230327:
    • NAB - Grids: Corrected issue where icons columns were not handling app variable conditions under certain conditions
    • NAB - Grids: Added nabFeatureXxxxx app variables to icon column condition list (per forum post)
    • NAB - Grids: Corrected issue where app variable for overriding grouping settings was not working properly
    • NAB - Grids (mobile): Removed auto column-sizing logic; honor cell wrapping when specified
    • NAB - Grids (mobile): Corrected issue where specified font size was being ignored
    • NAB - Edit Grids: Adjusted to better handle rapid tabbing from one row to another - sometimes changed cells were not getting updated
    • NAB - Pivot Grids/Tree Grids: allow "Clear All Data" option against Pivot Grids and Tree Grids in Behaviors - Hide/Show Widgets
    • NAB - Forms: Adjusted to ensure the icon color is white for primary button
    • NAB - Forms: Corrected issue where a primary button set to medium size was not showing icon properly
    • NAB - General: Corrected issue in Designer with the "expand all" button in Behaviors list (bottom left) not working
    • NAB - General: In Designer, adjusted the app variables "where used" list to include button bindings (per forum post)
    • NAB - Exit Programs: Increased maximum size of setValue from 256 to 1024 characters (per forum post)
    • NAB - Import: Corrected issue where exporting an app directly to another instance was not clearing the cached app in the destination library

    New features and fixes in Valence 6.1.20230224:
    • Nitro App Builder (NAB) - Grids: On custom cell renderer function, added summary parameter to accommodate custom calculations in summary rows and allow regular rows to reference summary values (per forum post and tip-of-the-month blog post)
    • NAB - Grids: Added option to not include grouping on non-legacy Excel downloads
    • NAB - Grids: Corrected issue on XML downloads where special characters (like "&") were not being encoded properly
    • NAB - Grids: For PDF downloads, added option to exclude headers if grid is not grouped
    • NAB - Grids: Corrected issue where column-specific search would not work properly while inside Designer
    • NAB - Edit Grids: Corrected issue where tabbing out of the last column on a row being edited would cause cursor to return to first editable column of the same row, rather than advancing to the next row (per forum post)
    • NAB - Edit Grids: Corrected issue where "Auto Edit" setting was being ignored if a filter had been applied to the grid (per forum post)
    • NAB - Forms: Added an app variable link for resetting the form
    • NAB - Forms: Added ability to set max height of multi-select combo boxes (per forum post)
    • NAB - Forms: Corrected issue where a checkbox overridden to send specific values (i.e., Y/N or 1/0) was still sending the default true/false to back-end program
    • NAB - Spool File Viewer (utility widget): Added support for a spool file number value of *LAST or *ONLY
    • NAB - Filters: Corrected issue that could cause an app variable linked to a combo box filter field to not work properly under certain circumstances
    • NAB - Calendar: Added logic to auto-adjust for daylight savings time
    • NAB - Tiles: Added option to specify the number of tiles per row (per forum post)
    • NAB - Tab container/tab panel: Added new utility widget for creating tab panels (Beta feature*)
    • NAB - Behaviors: Added new "section hide/show" behaviors that can be executed whenever a section is hidden or shown (Beta feature*)
    • NAB - Behaviors: Added two new actions for easier navigation control: "Show section" and its corollary "Show previous section" (Beta feature*)
    • NAB - Behavior: Corrected issue where app would throw a console error if an event listener attempted to take an action against a pop-up window
    • NAB - Data Sources: Corrected issue that could cause the alias on a vvIn_virtual to be dropped when inside a WITH clause, causing an SQL error (per forum post)
    • NAB - Data Sources: Corrected issue where RRN() was being incorrectly injected into a statement that was applying an aggregate function (per forum post)
    • NAB - Exit Programs: Added new gWriteErrLog to control error logging. Set to *OFF ('0') to disable output to error log (i.e., when attempting to pull the value from a disabled field)
    • NAB - Import app: Adjusted logic to better support update of VVEXPORTS repository prior to listing save files available for import
    • NAB - Import: Dropped use of ALWOBJDIF(*ALL) on restore process when injecting SAVF records into VVEXPORTS repository
    • NAB - Import: Corrected issue where an app that listens for events coming from itself could wind up pointing to an incorrect app after import under certain circumstances
    • NAB - General: Adjusted Designer so any app listed after entering search filter text will always show the app's underlying widgets and data sources, regardless of whether those widgets/data sources match the filter text as well.
    • Portal: Added support for using page-up/page-down keys to scroll up/down the launchpad (per forum post)
    • Portal Admin - Settings: Corrected issue where expiring group license keys were not cleanly displaying the days remaining before expiration
    • File Editor: Corrected issue where entry fields would lose focus while typing into them if a filter has been applied (per forum post)
    • RPG Toolkit - vvOut: For Japanese DBCS data, Valence will now attempt to automatically fix malformed 0E/0F shift data
    • Fusion5250: add logic to position cursor and ENTER on mouse double-click
    • VVMIGRATE migration program: Corrected issue where program would migrate former "core" apps from prior Valence version, rather than deferring to new version
    * Note: Beta features must be activated in Portal Admin > Settings > Portal Administration, via the "Beta Features Enabled" checkbox. These are part of the forthcoming Valence 6.2 release










    New features and fixes in Valence 6.1.20230120:
    • Nitro App Builder (NAB) - Grids: Added support for excluding column headers on non-legacy Excel downloads (per forum post)
    • NAB - Grids: Added option for downloading rows into a JSON-formatted file
    • NAB - Grids: When inline editing is enabled, a double click now only invokes edit mode for the row or cell, instead of triggering a row click event defined in Behaviors
    • NAB - Grids: Corrected issue where a non-legacy Excel download on a grid with no column headings (or Excel override containing blank column headings) would cause the app to break
    • NAB - Grids: Added ability to specify maximum rows for CSV, XML and JSON downloads, matching function already available for Excel and PDF
    • NAB - Grids: Corrected issue where focusRow and focusRowRRN app variable links were not always functioning properly to reposition grid; Referenced rows now show as selected when applied
    • NAB - Grids (mobile): Corrected issue where attempting to set the focus row via an app variable would cause a hard halt to occur
    • NAB - Pivot Grids: Corrected issue where adjusting the column width/flex would cause a console error in Designer
    • NAB - Tree Grids: Adjusted so formatters (like Money) are only applied to cells containing a non-null value
    • NAB - Utility Widgets: Added accordion configuration option to Vertical Layout container
    • NAB - URL Widget: Corrected issue where the URL property derived from a linked app variable would not always work as expected
    • NAB - Forms: Added a checkbox option in Designer to have the widget call the RPG Helper program even when there are form fields in error (per forum post)
    • NAB - Forms: Adjusted "field change milliseconds" logic for call to RPG helper program so that it is disabled when a value of 0 is specified
    • NAB - Forms: Adjusted to ensure a form being populated by linked app variables rather than a data source record still applies field formatters
    • NAB - Forms: Corrected issue where the primary button on a form would sometimes not be found, so Enter key would not trigger it
    • NAB - Forms: Corrected issue where a field value linked to a "set value" app variable could cause other links against that field (like "read only", "disabled", etc) to stop working
    • NAB - Forms: Corrected issue where the form show event would not trigger a call to the backend RPG helper program under some conditions
    • NAB - Forms: Corrected issue where reloading a combo box dropdown from an RPG form helper program could fail if front end is filtering the corresponding form at the same time
    • NAB - Maps: Added auto load checkbox, matching other widgets
    • NAB - Calendar: Corrected issue where a EXNABBTN-based button program would trigger a console error if a calendar widget exists in the app but is not yet loaded
    • NAB - Spool File Viewer: Corrected issue where spool file viewer was not functioning properly when placed inside a popup window
    • NAB - Behaviors: Hide/show option on maps now includes option to clear all data
    • NAB - Behaviors: Hide/show widgets on vertical and horizontal layout containers no longer includes option to load data/keep data/etc.
    • NAB - App Variables: Designer will now show "where used" on an app variable when clicked, and prompts you with these dependencies before proceeding with the deletion of an app variable
    • NAB - App Variables: Corrected issue in Designer where a "nabFeatureXXXX" app variable would be listed multiple times in the app variable list
    • NAB - Data Sources: Added support to SQL parser for rolling averages, "unbounded" keyword and multiple order-by clauses inside average (per forum post)
    • NAB - Data Sources: Adjusted parser to recognize a singular "row" in "fetch first X row only" (previously only recognized "rows")
    • NAB - Data Sources: Corrected issue where a data source converted from wizard-based to SQL-based would become ineligible for edit grid
    • NAB - Exit Programs: Ensure any events fired from startup RPG program don't hit the front-end until after the application and all its widgets have been created
    • NAB - General: In Designer, while editing an App you can now hover over a widget and click "Link" to go directly to the Link to App Variables window
    • NAB - General: From within Designer, while editing an App you can now hover over a widget and click "Edit" to make widget adjustments
    • NAB - General: Updated Designer to be more WYSIWYG with button placement/size/color/etc.
    • NAB - General: Updated app save button in Designer to have a tooltip of "Save and Exit" and added a new button that appears above the original save button that will simply save the application without exiting the app (per forum post)
    • NAB - Import/Export: Lifted import restriction for exports that have no version info (typically pre-6.1)
    • NAB - Import/Export: Adjusted logic to accommodate remote database IDs that vary between instances. Import now aligns the ID based on matching IP address and port.
    • Portal Admin - Apps / Users: Adjust search filter to escape any single quotes specified (per forum post)
    • Portal: Two factor authentication settings can now be hidden to users via Portal Admin > Settings
    • Fusion5250: Corrected issue where graphical scrollbar could cause last character of a subfile row to be invisible
    • VVMIGRATE: Added iAdmin files used for subsystem observation and ignored messages to migrated data list

    New features and fixes in Valence 6.1.20221219:
    • Nitro App Builder (NAB) - Edit Grids: Added ability to link an existing form widget to an edit grid for a more refined edit/add window
    • NAB - Edit Grids: Added option to override text on Add button (default is "Add")
    • NAB - Edit Grids: Added ability to specify titles and subtitles for popup window when adding/editing a record
    • NAB - Edit Grids: Corrected issue where non-visible fields in the add record form were not being assigned values via app variables as expected
    • NAB - Edit Grids (mobile): Adjusted to force a reload on all widgets after adding/editing a record, thus matching desktop mode functionality
    • NAB - Grids: Added ability to use shift-arrow up/down for record selection when multi-select option is active (per forum post)
    • NAB - Grids: Added ability to condition row menu buttons based on an app variable (per forum post)
    • NAB - Grids: Added optional tool tip configuration to grid column headers (per forum post)
    • NAB - Grids: To better utilize screen real estate, whenever multi-sort columns is active, and paging is not active, the sort column tiles are now shown on same toolbar as download buttons (per forum post)
    • NAB - Grids: Added ability to reset column sort back to default via a right-click on any column header (per forum post)
    • NAB - Grids: Added ability to change the group-by column, or turn grouping off / back on, via an app variable. Grid must already be grouping (per forum post)
    • NAB - Grids: Added ability to override the standard "No results" text to a custom string when no data is being shown
    • NAB - Grids: Adjusted group headings to no longer show a solitary colon in front of the group value when the column text has been blanked out
    • NAB - Grids: Adjusted row body to not show if no data exists
    • NAB - Grids: Corrected issue where an Infinite Scroll grid would stop working due to certain stored state values (sort, group by, etc)
    • NAB - Grids: Corrected issue where row body was not applying custom formatters when set to expandable
    • NAB - Grids: Corrected issue where row body was not translating literals (per forum post)
    • NAB - Tree Grid: Corrected issue where global search field would remain visible after column-specific search was activated
    • NAB - Tree Grid: Corrected issue where "Encrypt NAB SQL Clause" setting was not being applied properly
    • NAB - Tree Grid: Corrected issue where, when auto-loading all levels, grid could show the expander arrow on rows where expansion doesn't apply
    • NAB - Tree Grid: Corrected issue where encrypted SQL clauses would break the grid - only impacted sites where "Encrypt NAB SQL clauses" was enabled in Portal Admin > Settings (.1 build)
    • NAB - Utility Widgets: Added new "Spool File Viewer"
    • NAB - Behaviors: Added ability to assign a tool tip to a button via an app variable (per forum post)
    • NAB - Behaviors: Added ability to create a new app variable "on the fly" while inside the Set App Variables section of Designer
    • NAB - Behaviors: Added refresh utility to row menu buttons (per forum post)
    • NAB - Behaviors: Launch App now includes an optional field to override the title of the app being launched, which can be set via an app variable, column value or hard-coded text (per forum post)
    • NAB - Behaviors: Added option to set the event name of a fired event to be derived from an app variable
    • NAB - Behaviors: For Call RPG Program action, prompt fields can now be designated as "read only" (per forum post)
    • NAB - Behaviors: For Call RPG Program action, the program now has access to a new global variable called gIsFormValid, which will be set to *off ('0') if any field in the current form widget is in error
    • NAB - Behaviors: Fire Event can now be designated as internal only or available to external apps (db change: VVQRY600.VVPUBLIC)
    • NAB - Behaviors: When adding an Event Listener, you can now choose between local events or events fired by other apps
    • NAB - Behaviors: Adjusted the "Launch URL" action to ensure any special characters included in the URL are properly encoded for interpretation by the browser
    • NAB - Behaviors: Corrected issue where using an app variable to override title or subtitle of a widget was not functioning properly (per forum post)
    • NAB - Behaviors: Corrected issue involving a multi-select combo box, in which an app variable was being used to retrieve the combo box value. The value now shows as an array of selections rather than a string.
    • NAB - Behaviors: Corrected issue where hiding or showing any element inside a popup window would cause the popup window to close
    • NAB - Behaviors: Corrected issue specific to Mobile where the Close App utility function was not working properly
    • NAB - Filters: Added new option for toolbar mode to show labels above the filter fields rather than to the left of the filter fields
    • NAB - Filters: Adjusted "Between" logic on date columns to treat a non-specified "to" value as equivalent to 9999-12-31
    • NAB - Filters: Adjusted logic to not include any hidden filter fields in the widget filter
    • NAB - Filters: Corrected issue where "Between" filter values set via app variables were not being applied properly (per forum post)
    • NAB - Forms: Added a new link-to-app variable option to reset a form field
    • NAB - Forms: Added a new "isInvalid" app variable (available in link-to-app variables window)
    • NAB - Forms: Adjusted so the change event of a field can be triggered based on an elapsed time since last keystroke, rather than when user tabs out of the field
    • NAB - Forms: Added "Is Empty" in link-to-app variables for determining when any field is not set to a value -- 'true' means field is empty; 'false' means field has been set to a value (excludes checkboxes)
    • NAB - Forms: Added option to control where error message for a field is displayed -- either underneath the field or as a tooltip
    • NAB - Forms: For time or timestamp fields, added ability to override the time increment of the selector via an app variable, as well as override the min/max time values (per forum post)
    • NAB - Forms: Corrected issue where any fields set to use Rich Text Editor in a form rendered as a popup would not show the RTE
    • NAB - Forms: Corrected issue where fields transformed into a lookup were not honoring the "suppress zeros" setting (per forum post)
    • NAB - Forms: Corrected issue where a field transformed to Rich Text Editor was not being affected by form reset in Behaviors
    • NAB - Form Helper Exit Program: Added new "formShow" mode
    • NAB - Form Helper Exit Program: Corrected issue where a field-level "change" mode call was being made when no change to the field had actually taken place
    • NAB - Charts: Corrected issue that would arise when transforming a series, in tandem with changing the axis, which would result in the chart not rendering
    • NAB - Button Exit Program: Adjusted so program will now receive detail info (filters, tocalCount, widget Id, etc) for all widget types. Previously was only receiving info from forms, tiles, grids, pivot grids and trees.
    • NAB - Import: Added "from instance" to save file import grid
    • NAB - Import: Corrected issue where save files imported from another system or partition running Valence 6.1 were not properly updating the repository
    • NAB - Import: Added logic to prohibit importing a NAB object created in a newer build, as the widget or app could become corrupted when opened in an older build
    • NAB - Tiles: Corrected issue where a tile list was ignoring paging configuration
    • NAB - General: Added global app variable for current user's email address (per forum post)
    • NAB - General: Added ability to adjust border radius on popup windows (per forum post)
    • NAB - General: Improved default focus for widgets contained in vertical or horizontal containers
    • NAB - General: For improved aesthetics, adjusted any screens in which a widget must be selected (such as Filter Widget, Execute Script, Link URL, etc) to show the widgets in a grid, rather than as tiles
    • NAB - General: Adjusted icon color of primary buttons to show as white so they stand out better
    • NAB - General: Corrected issue where in some cases widgets were not taking up the full width of the screen when they should be (per forum post)
    • NAB - General: In Link-to-App Variables, added ability to assign the display value of a combo box or lookup field to an app variable
    • NAB - General: Added three new globally available app variable constants: nabNullDate (0001-01-01), nabNullTimestamp (0001-01-01-00.00.00.000000) and nabNullTimestampShort (0001-01-01-00.00.00)
    • NAB - General: In Designer, pop up windows now show widget ID when viewing settings
    • NAB - General: In Designer, clicking on a remove section button now triggers a confirmation prompt before proceeding
    • NAB - General: Corrected issue where auto-created "nabFeatureXXX" app variables were only being automatically created for widgets or buttons. Now they are also being created for actions, startup, etc.
    • NAB Import App: Adjusted so that default tab is now "Apps" instead of "Data Sources"; All lists now sort by descending creation date; Added "from Instance" column to all lists
    • Portal Admin - Environments: Adjusted to prohibit deletion of any environment that is linked to one or more web services.
    • Portal Admin - Categories: Corrected issue where the category search function inside the "move" pop-up window (triggered by clicking on an app tile) was not always working properly
    • File Editor: Corrected issue where "hideHome" query parameter was not being obeyed
    • RPG Toolkit - vvOut_execSQLtoJSON: Adjusted logic to no longer trim blank space(s) from varying fields. This affects NAB data sources as well.
    • RPG Toolkit - vvOut_encode: Replace any occurrences of x1E (EBCDIC record separator) with a question mark since this hex code can not be JSON decoded in the browser
    • RPG Toolkit - vvIn_json: Corrected issue where empty graphic fields were not being properly initialized with blanks
    • RPG Toolkit - vvUtility_encode: Added hex 1E to the list of special characters that should be replaced
    • Errors App: Adjusted so grid is reloaded after "Remove All" button is clicked
    • Fusion5250: Fixed graphical scrollbar interference with popup windows
    • Fusion5250: Added support for page up and down with mouse scroll wheel
    • Fusion5250: added "END" and "+" keys to keymap selections

    New features and fixes in Valence 6.1.20221026:
    • Nitro App Builder (NAB) - Grids: Added row body field formatting option, matching what is available in the Tile widget
    • NAB - Grids: For checkbox selections, added new "Auto Select If" condition
    • NAB - Grids: For checkbox selections, "Enable If" condition now has access to app variables
    • NAB - Grids: Added a new property for max number of row selections, set via an app variable
    • NAB - Grids: For non-legacy Excel, added an option in the configuration to override the max number of rows (default is 50,000)
    • NAB - Grids: Corrected issue where legacy Excel downloads were not properly supporting any vvIn_virtual clauses in the data source
    • NAB - Edit Grids: Data sources containing Views or CTEs (WITH clauses) are now eligible for use in edit grids, however only columns coming from regular (non-View/non-CTE) files in the data source can be edited. Note: you must re-save any already existing data sources for this eligibility to be recognized.
    • NAB - Edit Grids: When using local data and a "Max Results" value is specified, add button is now automatically disabled when max rows has been reached
    • NAB - Edit Grids: Corrected issue where "Allow delete" checkbox was being ignored in Designer; Improved rendering when Settings form is expanded
    • NAB - Edit Grids: Corrected issue in Designer where nabFeatureXxxx app variable was not being automatically created when a feature was assigned to add/edit/delete function
    • NAB - Edit Grids: Corrected issue where nabFeatureXxxx app variables designated specifically for enabling/disabling the grid's add/edit/remove capability or cell editing were not working
    • NAB - Forms: Added new "read only" property that can be set via an app variable
    • NAB - Forms: Adjusted default focus logic to recognize disabled/read-only fields and skip past them
    • NAB - Forms: Corrected issue where on rare occasions a form was not being updated after being filtered
    • NAB - Forms: Corrected issue in Designer where sometimes field group height was too small to show all components
    • NAB - Forms: Corrected issue in Designer that was sometimes causing huge forms with dozens of fields to not save properly
    • NAB - Forms: Adjusted Designer to disable "Force uppercase" option if a column has been transformed to a combo box, lookup field, etc.
    • NAB - Data Sources: Adjusted to always replace vvIn_virtual with the default value in Designer in order to pass validation, as some SQL functions won't accept functions (like vvIn_virtual) as parameters
    • NAB - Data Sources: Corrected issue where a "between" filter added to a data source through the wizard would not function properly on graphic fields or character columns on remoteDB tables
    • NAB - Data Sources: Corrected issue where wizard-based data sources would not handle Between filters over graphic fields and remoteDB character fields
    • NAB - Buttons: Adjusted UI for button focus so it appears more prominent when a theme is applied
    • NAB - Charts: Corrected issue where a click on a chart containing labels could cause the click event to be fired twice
    • NAB - Call RPG / Prompt for More Info: Added ability to supply a message in addition to the title, and added a "password" field type in the prompt
    • NAB - Export/Import: Corrected issue where the category on an already existing app in a destination instance could be changed to an incorrect value upon import
    • NAB - Behaviors: Added ability to assign a front-end literal to an app variable
    • NAB - Behaviors: Corrected Designer issue where the load/clear/reset property was not always being saved properly
    • NAB - Behaviors: Corrected Designer issue where, under Hide/Show Widgets, "Reset/Clear All Fields" or "Clear All Data" actions would not save under certain circumstances
    • NAB - Behaviors: Corrected Designer issue where, in Filter Widget, an incomplete field mapping could be inadvertently saved
    • NAB - Behaviors: Corrected issue in Launch App where special characters (like "&") included in parameters were not being encoded
    • NAB - General: Added new globally available app variables for current date, current time and current timestamp
    • NAB - General: For better efficiency, adjusted Runner to not request total count when running SQL statements to load widget except when needed (i.e., grids with paging)
    • NAB - General: Adjusted Designer so that NAB objects can be deleted without confirmation by holding down the Shift key while clicking on "Remove" button
    • NAB - General: Corrected issue where an app with complex widgets inside popup windows, or multiple popup windows, could cause attempt to load the app in Designer to fail
    • NAB - Mobile: Corrected issue where an attempt within an app to launch another app was not working
    • NAB - Mobile: Adjusted to avoid long delays upon app launch when unable to reach internet
    • Portal - Environment Selector: Adjusted to properly accommodate typing values in the combo box selection
    • Test RPG Call: Adjusted font to ensure JSON responses are always rendered in monospace
    • RPG Toolkit - vvIfs_deleteFile: Added optional "ignore error" parameter to skip write to error log if file to be deleted does not exist or cannot be deleted
    • RPG Toolkit - vvOut_toSS: Adjusted internal subprocedure logic to ensure there is no data bleed between column data style and column header style specified within a passed data structure array
    • Test RPG Call: Adjusted back-end to ensure the Test RPG Call app ID is always logged when making a test call to a program (call log was sometimes showing a blank app)
    • Fusion5250: Added new timeout setting to Portal Admin to provide a grace period (in minutes - default 120) before a 5250 session is assumed to be disconnected and thus killed. This is to address Valence Portal users who switch to a different browser tab or application, causing the Fusion socket to temporarily cease communications with the IBM i server in some browsers.
    • Fusion5250: Added support for graphical scrollbars
    • Fusion5250: Fixed issue where write to error message line could cancel pending screen updates
    • Nitro File Editor: Corrected issue where &hideHome parameter specified on app launch was not being applied in all cases
    • VVSSSTYLES: Program updated to be compatible with Valence 6.1. See blog post for use instructions.

    New features and fixes in Valence 6.1.20220912:
    • NAB - Grids: Corrected issue where disabling a feature to hide a single icon column would cause all icon columns in the grid to become hidden
    • NAB - Grids: Corrected issue where the specified filename for an XML download was not working
    • NAB - Data Sources: Added setting to Portal Admin>Settings>Hidden Settings to indicate if SQL Editor (vs Wizard) is default data source creation mode
    • NAB - Data Sources: Adjusted to accommodate multiple columns in a Grouping Set
    • NAB - Forms: Corrected issue where back-end RPG program setting a form field in error could cause a console error under certain circumstances
    • NAB - Tree Grids: Added new "refreshLastSelectedNode" property so a selected portion of the tree grid may be refreshed via an app variable
    • NAB - Charts: Adjusted to accommodate field name containing special characters like "$" and "#"
    • NAB - Designer: Adjusted so that the "Usage Count" for a data source now updates immediately whenever a widget using the data source is deleted (previously required a refresh of the list)
    • NAB - Designer: Corrected issue where saving an app in latest 6.1 build could cause any "df" (disable feature) segment in the app's launch URL to be ignored
    • Fusion5250: Improved handling of front-end timeouts to eliminate orphaned sessions and avoid excessive launches of new proxy sessions
    • Portal - General: Corrected tablet-specific issues where attempting to log in using the standard Valence Desktop Portal (instead of the mobile app from App Store / Google Play) was not working properly
    • Portal - General: Improved portrait mode rendering for tablets when accessing Desktop portal

    New features and fixes in Valence 6.1.20220824:
    • Nitro App Builder (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 - Grids: Corrected issue where app variable specified for overriding spreadsheet filename was not being applied on non-legacy Excel downloads
    • NAB - Buttons: Corrected issue where tooltips would stop showing on any button that was disabled then re-enabled via an app variable change
    • 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 - Forms: Corrected issue where, under certain circumstances, disabled field values were not being passed to any back-end programs
    • 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: Corrected issue where checkbox formatter wasn't working
    • 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 - 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 - Calendars: Corrected issue where events taking place at midnight were not showing on month view
    • NAB - Calendars: Corrected issue where the end timestamp on a calendar event was being ignored under certain rare conditions
    • 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 - Behaviors: Corrected issue in Designer where close program name could be inadvertently blanked out
    • 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: Add data source button in Designer now launches SQL editor rather than the wizard tool
    • 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: Added optional timeout override and mask text for longer-running filter exit programs (EXNABFLT-based programs)
    • 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 - Exit Programs: Removed all *ENTRY C specs and replaced with D specs
    • 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 - General: Corrected issue where filter fields linked via app variables to reset or reload were not always working as expected
    • 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
    • Portal - General: Added new VVPRIORITY column to VVERRHNDLR table for more refined control over back-end error trapping (watch for a future blog post on this)
    • 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.
    • RPG Toolkit - vvPDF_addHTML: Updated itext .jar file to address problem with missing addHTMLToPDF method, which was causing any job calling this RPG toolkit procedure to go MSGW
    • 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 richard.milone; 04-27-2023, 12:10 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


          • #6
            Valence Framework 6.1.20220824 is now available. Changes in this build since the previous release are:
            • Nitro App Builder (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 - Grids: Corrected issue where app variable specified for overriding spreadsheet filename was not being applied on non-legacy Excel downloads
            • NAB - Buttons: Corrected issue where tooltips would stop showing on any button that was disabled then re-enabled via an app variable change
            • 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 - Forms: Corrected issue where, under certain circumstances, disabled field values were not being passed to any back-end programs
            • 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: Corrected issue where checkbox formatter wasn't working
            • 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 - 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 - Calendars: Corrected issue where events taking place at midnight were not showing on month view
            • NAB - Calendars: Corrected issue where the end timestamp on a calendar event was being ignored under certain rare conditions
            • 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 - Behaviors: Corrected issue in Designer where close program name could be inadvertently blanked out
            • 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: Add data source button in Designer now launches SQL editor rather than the wizard tool
            • 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: Added optional timeout override and mask text for longer-running filter exit programs (EXNABFLT-based programs)
            • 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 - Exit Programs: Removed all *ENTRY C specs and replaced with D specs
            • 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 - General: Corrected issue where filter fields linked via app variables to reset or reload were not always working as expected
            • 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
            • Portal - General: Added new VVPRIORITY column to VVERRHNDLR table for more refined control over back-end error trapping (watch for a future blog post on this)
            • 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.
            • RPG Toolkit - vvPDF_addHTML: Updated itext .jar file to address problem with missing addHTMLToPDF method, which was causing any job calling this RPG toolkit procedure to go MSGW
            • Valence.js: Adjusted Valence.util.Helper.formatDate so that null dates (0001-01-01) are returned as blank
            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


            • #7
              Valence Framework 6.1.20220912 is now available. Changes in this build since the previous release are:
              • NAB - Grids: Corrected issue where disabling a feature to hide a single icon column would cause all icon columns in the grid to become hidden
              • NAB - Grids: Corrected issue where the specified filename for an XML download was not working
              • NAB - Data Sources: Added setting to Portal Admin>Settings>Hidden Settings to indicate if SQL Editor (vs Wizard) is default data source creation mode
              • NAB - Data Sources: Adjusted to accommodate multiple columns in a Grouping Set
              • NAB - Forms: Corrected issue where back-end RPG program setting a form field in error could cause a console error under certain circumstances
              • NAB - Tree Grids: Added new "refreshLastSelectedNode" property so a selected portion of the tree grid may be refreshed via an app variable
              • NAB - Charts: Adjusted to accommodate field name containing special characters like "$" and "#"
              • NAB - Designer: Adjusted so that the "Usage Count" for a data source now updates immediately whenever a widget using the data source is deleted (previously required a refresh of the list)
              • NAB - Designer: Corrected issue where saving an app in latest 6.1 build could cause any "df" (disable feature) segment in the app's launch URL to be ignored
              • Fusion5250: Improved handling of front-end timeouts to eliminate orphaned sessions and avoid excessive launches of new proxy sessions
              • Portal - General: Corrected tablet-specific issues where attempting to log in using the standard Valence Desktop Portal (instead of the mobile app from App Store / Google Play) was not working properly
              • Portal - General: Improved portrait mode rendering for tablets when accessing Desktop portal
              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


              • #8
                Valence Framework 6.1.20221026 is now available. Changes in this build since the previous release are:
                • Nitro App Builder (NAB) - Grids: Added row body field formatting option, matching what is available in the Tile widget
                • NAB - Grids: For checkbox selections, added new "Auto Select If" condition
                • NAB - Grids: For checkbox selections, "Enable If" condition now has access to app variables
                • NAB - Grids: Added a new property for max number of row selections, set via an app variable
                • NAB - Grids: For non-legacy Excel, added an option in the configuration to override the max number of rows (default is 50,000)
                • NAB - Grids: Corrected issue where legacy Excel downloads were not properly supporting any vvIn_virtual clauses in the data source
                • NAB - Edit Grids: Data sources containing Views or CTEs (WITH clauses) are now eligible for use in edit grids, however only columns coming from regular (non-View/non-CTE) files in the data source can be edited. Note: you must re-save any already existing data sources for this eligibility to be recognized.
                • NAB - Edit Grids: When using local data and a "Max Results" value is specified, automatically disable add button when max rows has been reached
                • NAB - Edit Grids: Corrected issue where "Allow delete" checkbox was being ignored in Designer; Improved rendering when Settings form is expanded
                • NAB - Edit Grids: Corrected issue in Designer where nabFeatureXxxx app variable was not being automatically created when a feature was assigned to add/edit/delete function
                • NAB - Edit Grids: Corrected issue where nabFeatureXxxx app variables designated specifically for enabling/disabling the grid's add/edit/remove capability or cell editing were not working
                • NAB - Forms: Added new "read only" property that can be set via an app variable
                • NAB - Forms: Adjusted default focus logic to recognize disabled/read-only fields and skip past them
                • NAB - Forms: Corrected issue where on rare occasions a form was not being updated after being filtered
                • NAB - Forms: Corrected issue in Designer where sometimes field group height was too small to show all components
                • NAB - Forms: Corrected issue in Designer that was sometimes causing huge forms with dozens of fields to not save properly
                • NAB - Forms: Adjusted Designer to disable "Force uppercase" option if a column has been transformed to a combo box, lookup field, etc.
                • NAB - Data Sources: Adjusted to always replace vvIn_virtual with the default value in Designer in order to pass validation, as some SQL functions won't accept functions (like vvIn_virtual) as parameters
                • NAB - Data Sources: Corrected issue where a "between" filter added to a data source through the wizard would not function properly on graphic fields or character columns on remoteDB tables
                • NAB - Data Sources: Corrected issue where wizard-based data sources would not handle Between filters over graphic fields and remoteDB character fields
                • NAB - Buttons: Adjusted UI for button focus so it appears more prominent when a theme is applied
                • NAB - Charts: Corrected issue where a click on a chart containing labels could cause the click event to be fired twice
                • NAB - Call RPG / Prompt for More Info: Added ability to supply a message in addition to the title, and added a "password" field type in the prompt
                • NAB - Export/Import: Corrected issue where the category on an already existing app in a destination instance could be changed to an incorrect value upon import
                • NAB - Behaviors: Added ability to assign a front-end literal to an app variable
                • NAB - Behaviors: Corrected Designer issue where the load/clear/reset property was not always being saved properly
                • NAB - Behaviors: Corrected Designer issue where, under Hide/Show Widgets, "Reset/Clear All Fields" or "Clear All Data" actions would not save under certain circumstances
                • NAB - Behaviors: Corrected Designer issue where, in Filter Widget, an incomplete field mapping could be inadvertently saved
                • NAB - Behaviors: Corrected issue in Launch App where special characters (like "&") included in parameters were not being encoded
                • NAB - General: Added new globally available app variables for current date, current time and current timestamp
                • NAB - General: For better efficiency, adjusted Runner to not request total count when running SQL statements to load widget except when needed (i.e., grids with paging)
                • NAB - General: Adjusted Designer so that NAB objects can be deleted without confirmation by holding down the Shift key while clicking on "Remove" button
                • NAB - General: Corrected issue where an app with complex widgets inside popup windows, or multiple popup windows, could cause attempt to load the app in Designer to fail
                • NAB - Mobile: Corrected issue where an attempt within an app to launch another app was not working
                • NAB - Mobile: Adjusted to avoid long delays upon app launch when unable to reach internet
                • Portal - Environment Selector: Adjusted to properly accommodate typing values in the combo box selection
                • Test RPG Call: Adjusted font to ensure JSON responses are always rendered in monospace
                • RPG Toolkit - vvIfs_deleteFile: Added optional "ignore error" parameter to skip write to error log if file to be deleted does not exist or cannot be deleted
                • RPG Toolkit - vvOut_toSS: Adjusted internal subprocedure logic to ensure there is no data bleed between column data style and column header style specified within a passed data structure array
                • Test RPG Call: Adjusted back-end to ensure the Test RPG Call app ID is always logged when making a test call to a program (call log was sometimes showing a blank app)
                • Fusion5250: Added new timeout setting to Portal Admin to provide a grace period (in minutes - default 120) before a 5250 session is assumed to be disconnected and thus killed. This is to address Valence Portal users who switch to a different browser tab or application, causing the Fusion socket to temporarily cease communications with the IBM i server in some browsers.
                • Fusion5250: Added support for graphical scrollbars
                • Fusion5250: Fixed issue where write to error message line could cancel pending screen updates
                • Nitro File Editor: Corrected issue where &hideHome parameter specified on app launch was not being applied in all cases
                • VVSSSTYLES: Program updated to be compatible with Valence 6.1. See blog post for use instructions.
                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; 10-27-2022, 12:51 PM.

                Comment


                • #9
                  Valence Framework 6.1.20221219 is now available. Changes in this build since the previous release are:
                  • Nitro App Builder (NAB) - Edit Grids: Added ability to link an existing form widget to an edit grid for a more refined edit/add window
                  • NAB - Edit Grids: Added option to override text on Add button (default is "Add")
                  • NAB - Edit Grids: Added ability to specify titles and subtitles for popup window when adding/editing a record
                  • NAB - Edit Grids: Corrected issue where non-visible fields in the add record form were not being assigned values via app variables as expected
                  • NAB - Edit Grids (mobile): Adjusted to force a reload on all widgets after adding/editing a record, thus matching desktop mode functionality
                  • NAB - Grids: Added ability to use shift-arrow up/down for record selection when multi-select option is active (per forum post)
                  • NAB - Grids: Added ability to condition row menu buttons based on an app variable (per forum post)
                  • NAB - Grids: Added optional tool tip configuration to grid column headers (per forum post)
                  • NAB - Grids: To better utilize screen real estate, whenever multi-sort columns is active, and paging is not active, the sort column tiles are now shown on same toolbar as download buttons (per forum post)
                  • NAB - Grids: Added ability to reset column sort back to default via a right-click on any column header (per forum post)
                  • NAB - Grids: Added ability to change the group-by column, or turn grouping off / back on, via an app variable. Grid must already be grouping (per forum post)
                  • NAB - Grids: Added ability to override the standard "No results" text to a custom string when no data is being shown
                  • NAB - Grids: Adjusted group headings to no longer show a solitary colon in front of the group value when the column text has been blanked out
                  • NAB - Grids: Adjusted row body to not show if no data exists
                  • NAB - Grids: Corrected issue where an Infinite Scroll grid would stop working due to certain stored state values (sort, group by, etc)
                  • NAB - Grids: Corrected issue where row body was not applying custom formatters when set to expandable
                  • NAB - Grids: Corrected issue where row body was not translating literals (per forum post)
                  • NAB - Tree Grid: Corrected issue where global search field would remain visible after column-specific search was activated
                  • NAB - Tree Grid: Corrected issue where "Encrypt NAB SQL Clause" setting was not being applied properly
                  • NAB - Tree Grid: Corrected issue where, when auto-loading all levels, grid could show the expander arrow on rows where expansion doesn't apply
                  • NAB - Utility Widgets: Added new "Spool File Viewer"
                  • NAB - Behaviors: Added ability to assign a tool tip to a button via an app variable (per forum post)
                  • NAB - Behaviors: Added ability to create a new app variable "on the fly" while inside the Set App Variables section of Designer
                  • NAB - Behaviors: Added refresh utility to row menu buttons (per forum post)
                  • NAB - Behaviors: Launch App now includes an optional field to override the title of the app being launched, which can be set via an app variable, column value or hard-coded text (per forum post)
                  • NAB - Behaviors: Added option to set the event name of a fired event to be derived from an app variable
                  • NAB - Behaviors: For Call RPG Program action, prompt fields can now be designated as "read only" (per forum post)
                  • NAB - Behaviors: For Call RPG Program action, the program now has access to a new global variable called gIsFormValid, which will be set to *off ('0') if any field in the current form widget is in error
                  • NAB - Behaviors: Fire Event can now be designated as internal only or available to external apps (db change: VVQRY600.VVPUBLIC)
                  • NAB - Behaviors: When adding an Event Listener, you can now choose between local events or events fired by other apps
                  • NAB - Behaviors: Adjusted the "Launch URL" action to ensure any special characters included in the URL are properly encoded for interpretation by the browser
                  • NAB - Behaviors: Corrected issue where using an app variable to override title or subtitle of a widget was not functioning properly (per forum post)
                  • NAB - Behaviors: Corrected issue involving a multi-select combo box, in which an app variable was being used to retrieve the combo box value. The value now shows as an array of selections rather than a string.
                  • NAB - Behaviors: Corrected issue where hiding or showing any element inside a popup window would cause the popup window to close
                  • NAB - Behaviors: Corrected issue specific to Mobile where the Close App utility function was not working properly
                  • NAB - Filters: Added new option for toolbar mode to show labels above the filter fields rather than to the left of the filter fields
                  • NAB - Filters: Adjusted "Between" logic on date columns to treat a non-specified "to" value as equivalent to 9999-12-31
                  • NAB - Filters: Adjusted logic to not include any hidden filter fields in the widget filter
                  • NAB - Filters: Corrected issue where "Between" filter values set via app variables were not being applied properly (per forum post)
                  • NAB - Forms: Added a new link-to-app variable option to reset a form field
                  • NAB - Forms: Added a new "isInvalid" app variable (available in link-to-app variables window)
                  • NAB - Forms: Adjusted so the change event of a field can be triggered based on an elapsed time since last keystroke, rather than when user tabs out of the field
                  • NAB - Forms: Added "Is Empty" in link-to-app variables for determining when any field is not set to a value -- 'true' means field is empty; 'false' means field has been set to a value (excludes checkboxes)
                  • NAB - Forms: Added option to control where error message for a field is displayed -- either underneath the field or as a tooltip
                  • NAB - Forms: For time or timestamp fields, added ability to override the time increment of the selector via an app variable, as well as override the min/max time values (per forum post)
                  • NAB - Forms: Corrected issue where any fields set to use Rich Text Editor in a form rendered as a popup would not show the RTE
                  • NAB - Forms: Corrected issue where fields transformed into a lookup were not honoring the "suppress zeros" setting (per forum post)
                  • NAB - Forms: Corrected issue where a field transformed to Rich Text Editor was not being affected by form reset in Behaviors
                  • NAB - Form Helper Exit Program: Added new "formShow" mode
                  • NAB - Form Helper Exit Program: Corrected issue where a field-level "change" mode call was being made when no change to the field had actually taken place
                  • NAB - Charts: Corrected issue that would arise when transforming a series, in tandem with changing the axis, which would result in the chart not rendering
                  • NAB - Button Exit Program: Adjusted so program will now receive detail info (filters, tocalCount, widget Id, etc) for all widget types. Previously was only receiving info from forms, tiles, grids, pivot grids and trees.
                  • NAB - Import: Added "from instance" to save file import grid
                  • NAB - Import: Corrected issue where save files imported from another system or partition running Valence 6.1 were not properly updating the repository
                  • NAB - Import: Added logic to prohibit importing a NAB object created in a newer build, as the widget or app could become corrupted when opened in an older build
                  • NAB - Tiles: Corrected issue where a tile list was ignoring paging configuration
                  • NAB - General: Added global app variable for current user's email address (per forum post)
                  • NAB - General: Added ability to adjust border radius on popup windows (per forum post)
                  • NAB - General: Improved default focus for widgets contained in vertical or horizontal containers
                  • NAB - General: For improved aesthetics, adjusted any screens in which a widget must be selected (such as Filter Widget, Execute Script, Link URL, etc) to show the widgets in a grid, rather than as tiles
                  • NAB - General: Adjusted icon color of primary buttons to show as white so they stand out better
                  • NAB - General: Corrected issue where in some cases widgets were not taking up the full width of the screen when they should be (per forum post)
                  • NAB - General: In Link-to-App Variables, added ability to assign the display value of a combo box or lookup field to an app variable
                  • NAB - General: Added three new globally available app variable constants: nabNullDate (0001-01-01), nabNullTimestamp (0001-01-01-00.00.00.000000) and nabNullTimestampShort (0001-01-01-00.00.00)
                  • NAB - General: In Designer, pop up windows now show widget ID when viewing settings
                  • NAB - General: In Designer, clicking on a remove section button now triggers a confirmation prompt before proceeding
                  • NAB - General: Corrected issue where auto-created "nabFeatureXXX" app variables were only being automatically created for widgets or buttons. Now they are also being created for actions, startup, etc.
                  • NAB Import App: Adjusted so that default tab is now "Apps" instead of "Data Sources"; All lists now sort by descending creation date; Added "from Instance" column to all lists
                  • Portal Admin - Environments: Adjusted to prohibit deletion of any environment that is linked to one or more web services.
                  • Portal Admin - Categories: Corrected issue where the category search function inside the "move" pop-up window (triggered by clicking on an app tile) was not always working properly
                  • File Editor: Corrected issue where "hideHome" query parameter was not being obeyed
                  • RPG Toolkit - vvOut_execSQLtoJSON: Adjusted logic to no longer trim blank space(s) from varying fields. This affects NAB data sources as well.
                  • RPG Toolkit - vvOut_encode: Replace any occurrences of x1E (EBCDIC record separator) with a question mark since this hex code can not be JSON decoded in the browser
                  • RPG Toolkit - vvIn_json: Corrected issue where empty graphic fields were not being properly initialized with blanks
                  • RPG Toolkit - vvUtility_encode: Added hex 1E to the list of special characters that should be replaced
                  • Errors App: Adjusted so grid is reloaded after "Remove All" button is clicked
                  • Fusion5250: Fixed graphical scrollbar interference with popup windows
                  • Fusion5250: Added support for page up and down with mouse scroll wheel
                  • Fusion5250: added "END" and "+" keys to keymap selections
                  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


                  • #10
                    Valence Framework 6.1.20230120 is now available. Changes in this build since the previous release are:
                    • Nitro App Builder (NAB) - Grids: Added support for excluding column headers on non-legacy Excel downloads (per forum post)
                    • NAB - Grids: Added option for downloading rows into a JSON-formatted file
                    • NAB - Grids: When inline editing is enabled, a double click now only invokes edit mode for the row or cell, instead of triggering a row click event defined in Behaviors
                    • NAB - Grids: Corrected issue where a non-legacy Excel download on a grid with no column headings (or Excel override containing blank column headings) would cause the app to break
                    • NAB - Grids: Added ability to specify maximum rows for CSV, XML and JSON downloads, matching function already available for Excel and PDF
                    • NAB - Grids: Corrected issue where focusRow and focusRowRRN app variable links were not always functioning properly to reposition grid; Referenced rows now show as selected when applied
                    • NAB - Grids (mobile): Corrected issue where attempting to set the focus row via an app variable would cause a hard halt to occur
                    • NAB - Pivot Grids: Corrected issue where adjusting the column width/flex would cause a console error in Designer
                    • NAB - Tree Grids: Adjusted so formatters (like Money) are only applied to cells containing a non-null value
                    • NAB - Utility Widgets: Added accordion configuration option to Vertical Layout container
                    • NAB - URL Widget: Corrected issue where the URL property derived from a linked app variable would not always work as expected
                    • NAB - Forms: Added a checkbox option in Designer to have the widget call the RPG Helper program even when there are form fields in error (per forum post)
                    • NAB - Forms: Adjusted "field change milliseconds" logic for call to RPG helper program so that it is disabled when a value of 0 is specified
                    • NAB - Forms: Adjusted to ensure a form being populated by linked app variables rather than a data source record still applies field formatters
                    • NAB - Forms: Corrected issue where the primary button on a form would sometimes not be found, so Enter key would not trigger it
                    • NAB - Forms: Corrected issue where a field value linked to a "set value" app variable could cause other links against that field (like "read only", "disabled", etc) to stop working
                    • NAB - Forms: Corrected issue where the form show event would not trigger a call to the backend RPG helper program under some conditions
                    • NAB - Forms: Corrected issue where reloading a combo box dropdown from an RPG form helper program could fail if front end is filtering the corresponding form at the same time
                    • NAB - Maps: Added auto load checkbox, matching other widgets
                    • NAB - Calendar: Corrected issue where a EXNABBTN-based button program would trigger a console error if a calendar widget exists in the app but is not yet loaded
                    • NAB - Spool File Viewer: Corrected issue where spool file viewer was not functioning properly when placed inside a popup window
                    • NAB - Behaviors: Hide/show option on maps now includes option to clear all data
                    • NAB - Behaviors: Hide/show widgets on vertical and horizontal layout containers no longer includes option to load data/keep data/etc.
                    • NAB - App Variables: Designer will now show "where used" on an app variable when clicked, and prompts you with these dependencies before proceeding with the deletion of an app variable
                    • NAB - App Variables: Corrected issue in Designer where a "nabFeatureXXXX" app variable would be listed multiple times in the app variable list
                    • NAB - Data Sources: Added support to SQL parser for rolling averages, "unbounded" keyword and multiple order-by clauses inside average (per forum post)
                    • NAB - Data Sources: Adjusted parser to recognize a singular "row" in "fetch first X row only" (previously only recognized "rows")
                    • NAB - Data Sources: Corrected issue where a data source converted from wizard-based to SQL-based would become ineligible for edit grid
                    • NAB - Exit Programs: Ensure any events fired from startup RPG program don't hit the front-end until after the application and all its widgets have been created
                    • NAB - General: In Designer, while editing an App you can now hover over a widget and click "Link" to go directly to the Link to App Variables window
                    • NAB - General: From within Designer, while editing an App you can now hover over a widget and click "Edit" to make widget adjustments
                    • NAB - General: Updated Designer to be more WYSIWYG with button placement/size/color/etc.
                    • NAB - General: Updated app save button in Designer to have a tooltip of "Save and Exit" and added a new button that appears above the original save button that will simply save the application without exiting the app (per forum post)
                    • NAB - Import/Export: Lifted import restriction for exports that have no version info (typically pre-6.1)
                    • NAB - Import/Export: Adjusted logic to accommodate remote database IDs that vary between instances. Import now aligns the ID based on matching IP address and port.
                    • Portal Admin - Apps / Users: Adjust search filter to escape any single quotes specified (per forum post)
                    • Portal: Two factor authentication settings can now be hidden to users via Portal Admin > Settings
                    • Fusion5250: Corrected issue where graphical scrollbar could cause last character of a subfile row to be invisible
                    • VVMIGRATE: Added iAdmin files used for subsystem observation and ignored messages to migrated data list
                    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; 01-23-2023, 07:26 AM.

                    Comment


                    • #11
                      Valence Framework 6.1.20230224 is now available. Changes in this build since the previous release are:
                      • Nitro App Builder (NAB) - Grids: On custom cell renderer function, added summary parameter to accommodate custom calculations in summary rows and allow regular rows to reference summary values (per forum post and tip-of-the-month blog post)
                      • NAB - Grids: Added option to not include grouping on non-legacy Excel downloads
                      • NAB - Grids: Corrected issue on XML downloads where special characters (like "&") were not being encoded properly
                      • NAB - Grids: For PDF downloads, added option to exclude headers if grid is not grouped
                      • NAB - Grids: Corrected issue where column-specific search would not work properly while inside Designer
                      • NAB - Edit Grids: Corrected issue where tabbing out of the last column on a row being edited would cause cursor to return to first editable column of the same row, rather than advancing to the next row (per forum post)
                      • NAB - Edit Grids: Corrected issue where "Auto Edit" setting was being ignored if a filter had been applied to the grid (per forum post)
                      • NAB - Forms: Added an app variable link for resetting the form
                      • NAB - Forms: Added ability to set max height of multi-select combo boxes (per forum post)
                      • NAB - Forms: Corrected issue where a checkbox overridden to send specific values (i.e., Y/N or 1/0) was still sending the default true/false to back-end program
                      • NAB - Spool File Viewer (utility widget): Added support for a spool file number value of *LAST or *ONLY
                      • NAB - Filters: Corrected issue that could cause an app variable linked to a combo box filter field to not work properly under certain circumstances
                      • NAB - Calendar: Added logic to auto-adjust for daylight savings time
                      • NAB - Tiles: Added option to specify the number of tiles per row (per forum post)
                      • NAB - Tab container/tab panel: Added new utility widget for creating tab panels (Beta feature*)
                      • NAB - Behaviors: Added new "section hide/show" behaviors that can be executed whenever a section is hidden or shown (Beta feature*)
                      • NAB - Behaviors: Added two new actions for easier navigation control: "Show section" and its corollary "Show previous section" (Beta feature*)
                      • NAB - Behavior: Corrected issue where app would throw a console error if an event listener attempted to take an action against a pop-up window
                      • NAB - Data Sources: Corrected issue that could cause the alias on a vvIn_virtual to be dropped when inside a WITH clause, causing an SQL error (per forum post)
                      • NAB - Data Sources: Corrected issue where RRN() was being incorrectly injected into a statement that was applying an aggregate function (per forum post)
                      • NAB - Exit Programs: Added new gWriteErrLog to control error logging. Set to *OFF ('0') to disable output to error log (i.e., when attempting to pull the value from a disabled field)
                      • NAB - Import app: Adjusted logic to better support update of VVEXPORTS repository prior to listing save files available for import
                      • NAB - Import: Dropped use of ALWOBJDIF(*ALL) on restore process when injecting SAVF records into VVEXPORTS repository
                      • NAB - Import: Corrected issue where an app that listens for events coming from itself could wind up pointing to an incorrect app after import under certain circumstances
                      • NAB - General: Adjusted Designer so any app listed after entering search filter text will always show the app's underlying widgets and data sources, regardless of whether those widgets/data sources match the filter text as well.
                      • Portal: Added support for using page-up/page-down keys to scroll up/down the launchpad (per forum post)
                      • Portal Admin - Settings: Corrected issue where expiring group license keys were not cleanly displaying the days remaining before expiration
                      • File Editor: Corrected issue where entry fields would lose focus while typing into them if a filter has been applied (per forum post)
                      • RPG Toolkit - vvOut: For Japanese DBCS data, Valence will now attempt to automatically fix malformed 0E/0F shift data
                      • Fusion5250: add logic to position cursor and ENTER on mouse double-click
                      • VVMIGRATE migration program: Corrected issue where program would migrate former "core" apps from prior Valence version, rather than deferring to new version
                      * Note: Beta features must be activated in Portal Admin > Settings > Portal Administration, via the "Beta Features Enabled" checkbox. These are part of the forthcoming Valence 6.2 release

                      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


                      • #12
                        Valence Framework 6.1.20230327 is now available. Changes in this build since the previous release are:
                        • NAB - Grids: Corrected issue where icons columns were not handling app variable conditions under certain conditions
                        • NAB - Grids: Added nabFeatureXxxxx app variables to icon column condition list (per forum post)
                        • NAB - Grids: Corrected issue where app variable for overriding grouping settings was not working properly
                        • NAB - Grids (mobile): Removed auto column-sizing logic; honor cell wrapping when specified
                        • NAB - Grids (mobile): Corrected issue where specified font size was being ignored
                        • NAB - Edit Grids: Adjusted to better handle rapid tabbing from one row to another - sometimes changed cells were not getting updated
                        • NAB - Pivot Grids/Tree Grids: allow "Clear All Data" option against Pivot Grids and Tree Grids in Behaviors - Hide/Show Widgets
                        • NAB - Forms: Adjusted to ensure the icon color is white for primary button
                        • NAB - Forms: Corrected issue where a primary button set to medium size was not showing icon properly
                        • NAB - General: Corrected issue in Designer with the "expand all" button in Behaviors list (bottom left) not working
                        • NAB - General: In Designer, adjusted the app variables "where used" list to include button bindings (per forum post)
                        • NAB - Exit Programs: Increased maximum size of setValue from 256 to 1024 characters (per forum post)
                        • NAB - Import: Corrected issue where exporting an app directly to another instance was not clearing the cached app in the destination library
                        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