Valence 6.3 (All Builds)

richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#1

Valence 6.3 (All Builds)

05-28-2024, 08:25 PM

Versions:

6.3.20260622, released on June 22, 2026
6.3.20260615, released on June 15, 2026
6.3.20260605, released on June 5, 2026
6.3.20260421, released on April 21, 2026
6.3.20260407, released on April 7, 2026
6.3.20260319, released on March 19, 2026
6.3.20260306, released on March 6, 2026
6.3.20251222, released on December 22, 2025
6.3.20251117, released on November 18, 2025
6.3.20251030, released on October 30, 2025
6.3.20250923, released on September 23, 2025
6.3.20250910, released on September 10, 2025
6.3.20250821, released on August 21, 2025
6.3.20250708, released on July 8, 2025
6.3.20250516, released on May 16, 2025
6.3.20250325, released on March 25, 2025
6.3.20250207, released on February 7, 2025
6.3.20250108, released on January 8, 2025 (.1 on January 13)
6.3.20241120, released on November 20, 2024
6.3.20241025, released on October 25, 2024
6.3.20240821, released on August 21, 2024
6.3.20240724, released on July 24, 2024
6.3.20240627, released on June 27, 2024
6.3.20240529, released on May 29, 2024

Licensing:

Existing Valence customers on version 6.2.x or earlier will need to obtain a new license key from CNX to use this version. Keys will be provided at no cost for existing licensed systems if current on maintenance. Be sure to obtain a valid Valence 6.3 key prior to installing this version. Email support@cnxcorp.com to obtain a new license key.

The new Valence Assistant AI service introduced in this version is provided by CNX to licensed customers with active maintenance. CNX reserves the right to set reasonable access limits on this service.

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.

Installing This Release:
If you already have an earlier version of Valence 6.X installed, the Valence 6.3 installer will automatically upgrade your Valence 6.X base instance to Valence 6.3 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.3 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.3 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 page. 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 6.3 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.3 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.3 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 in Valence 6.3.20260824:
Nitro App Builder (NAB) - Grids: Adjusted summary row logic so that cell color rules are applied the same as regular rows, provided the cell is not dependent on values from other columns

NAB - Grids: Corrected issue where, on a grid with multi-select activated and a row click behavior configured to make a back-end call, only the clicked row would be passed instead of all the selected rows (per forum post)

NAB - Grids: Corrected issue on Excel downloads where filters, including those adjusted by app variables, were not always being applied (per forum post)

NAB - Grids: Corrected issue on Excel downloads where double byte columns could incorrectly show as hex characters

NAB - Edit Grids: Corrected issue where a linked form that had undergone changes was not showing correctly when editing the grid

NAB - Tree Grids: Corrected issue where sub-levels would fail to load under certain circumstances

NAB - Pivot Grids: Corrected issue where, if a pivot grid was filtering another widget on click, it would not perform behavior actions if the filter was using an app variable instead of a field from the record (per forum post)

NAB - Pivot Grids: Corrected issue where column headings overridden via an app variable could be lost under certain conditions, causing the headings to revert to their original values (per forum post)

NAB - Filters: Corrected issue where a filter field transformed into a dropdown-grid was not applying additional filter conditions supplied by an app variable on the link widget property (per forum post)

NAB - Forms: Adjusted rendering logic to always apply configured colors to forms, even when no data source record has been loaded

NAB - Forms: Corrected issue where "Set Field" links were not working for a popup form

NAB - Forms: Corrected issue where bind property value on "All Fields Read Only" was not being taken into account when inverted

NAB - Charts: Corrected issue where a custom renderer in one chart could affect other charts

NAB - Info Widget: Corrected issue where content was not scrolling when necessary

NAB - Behaviors: Corrected issue where a row click's "set app variable" widget linkage was not always properly set

NAB - Popup Windows: Added a new link widget property so window's closable property can be turned on or off via an app variable

NAB - Exit Programs: Corrected issue where the app close program was not consistently being called.

NAB - Exit Programs (form): Corrected issue where a Form Helper program performing a filter clear would not always function properly due to timing issues with the data load

NAB - General: Corrected issue in Designer where the widget list could come up empty if "Add App" or "Edit App" is clicked prior to the widget list being loaded (per forum post)

NAB - Git: Corrected issue where an app could inadvertently include unrelated widgets on rollback

Portal - General: Adjusted so when portal is launched with "app=xxx&portal=false" directive, and the app is subsequently closed via the NAB Close App utility, it will now not just close the app and return the user to the launch pad, but close the application and log them out.

?

Features and fixes in Valence 6.3.20260622:
Nitro App Builder (NAB) - forms: Corrected issue where fieldset/fieldgroup were showing even though all fields within it were set to hidden (per forum post)

NAB - Import: Corrected rare issue where widget fields could become corrupted on import

Portal - Documentation: Moved 6.3 documentation into a downloadable PDF

Features and fixes in Valence 6.3.20260615:
Nitro App Builder (NAB) - Import/Export: Corrected issue with data sources linked to drop downs sometimes being omitted on export

NAB - Forms (Mobile): Corrected issue where form would not render properly under certain conditions

RPG Toolkit - vvIn: Corrected issuewhere a mix of get and post parameters would cause vvIn_xxx to not see some of the parameters

Features and fixes in Valence 6.3.20260605:
Nitro App Builder (NAB) - Edit Grids: Corrected issue on fields transformed to a dropdown where the value on the dropdown would not display if display & value field were the same

NAB - Edit Grids: Corrected issue in row editor where fields set as read-only via the widget configuration were being displayed as editable

NAB - Grids: Corrected issue where grids with locked columns would sometimes cause a hard error and/or fail to show rows correctly after hiding/showing widgets in the same section

NAB - Forms: Corrected issue in Designer where adding a button next to a field would result in an empty drop-down

NAB - URL Widget: Corrected issue in Designer where link to widget properties window would not pop up when clicked (per forum post)

NAB - Maps: Added ability to add/delete markers via new configurations on the widget, similar to how local data updates are handled in grids

NAB - Buttons: Enhanced color processing in Helper utility for button elements. Refactored logic to improve handling of color classes based on button state and element availability.

NAB - Tiles: Corrected issue where button conditions (enable or show) were not working with app variables (per forum post)

NAB - Filters: Corrected issue where "required" property was not being applied to fields based on calculated columns

NAB - General: Corrected issue where the clearAllData app variable linkage would not clear summary results (per forum post)

NAB - General: Corrected issue in Designer where clicking on the "fullscreen" icon on a popup could cause the application to crash (per forum post)

NAB - General: Corrected issue where a form widget would not save off another data source dependency, thereby causing the dependent data source to be excluded on an export/import

RPG Toolkit - vvIn: Expanded vvIn.filename from 128 to 256 characters for more flexibility in uploads
IMPORTANT: To avoid errors you must recompile any RPG programs that use vvIn_File to perform uploads

RPG Toolkit - vvOut: Adjusted to accommodate ST_POINT column types so as to avoid a MSGW condition

Portal Admin - Settings: Adjusted to not force uppercase in java classpath entries

Features and fixes in Valence 6.3.20260421:
Nitro App Builder (NAB) - Behaviors: Corrected issue in the RPG Call Prompt where "Auto Select First Result" for dropdown fields was not working properly (per forum post)

NAB - Forms: Corrected issue where, under rare circumstances, the form could break upon save

NAB - Export/Import: Corrected issue where data sources or widgets within imported forms would not update the NAB ID properly

NAB - Export/Import: Corrected issue where batch calls to VVIMPORT (as opposed to running the import within the portal) could miss nested components

Portal Admin - Apps: Corrected issue where the initial default group was still appearing in the Available Groups list

Portal Admin - Logs: Corrected issue where the "Apps" drop-down filter was not working properly

Features and fixes in Valence 6.3.20260407:
Nitro App Builder (NAB) - General: Corrected issue where an app could fail upon launch if app variables were linked to enable/disable feature on buttons

NAB - Remote DB: Corrected issue that was causing an SQL error when three or more tables were joined

Features and fixes in Valence 6.3.20260319:
Nitro App Builder (NAB) - Forms: Refactored form field enable/disable/hide/show logic to handle cases where both enable/disable or hide/show are passed simultaneously

NAB - Behaviors: Corrected issue where in some cases where an app variable's initial value was not set, it would send an empty string as the initial value

Features and fixes in Valence 6.3.20260306:
Nitro App Builder (NAB) - Grids: Added option to align filters to the right when the global grid search is activated and set to align left

NAB - Grids: Corrected issue where Summary Values widget property wasn’t working on grids using local data

NAB - Grids: Corrected issue with custom formatters where, in some cases, a column would get the incorrect custom formatter, particularly on Excel/PDF downloads (per forum post)

NAB - Grids/Forms: Added a new base formatter that displays an image of a checked or unchecked checkbox based on the value. Similar to the Miscellaneous > Checkmark, but with a box surrounding the check or blank space.

NAB - Edit Grids: In cell-editing mode and the edit is set to single-click, then clicking on a cell whose underlying editor is a checkbox will automatically check or uncheck it based on its current value. Previously the user would have to click once to enter edit mode, then click again to alter the cell value.

NAB - Edit Grids: Added optional conditions to row delete/copy so action can be disabled or hidden based on the row’s data

NAB - Edit Grids: Added new widget property "Add Defaults" where default values can be set on any field on the data source, allowing for values to be set on non-editable or non-showing fields when adding a record

NAB - Edit Grids: Added new widget property "autoEditFirstAvailable" to automatically place first editable record/cell into edit mode, to accommodate cases where initial row(s) may not be editable

NAB - Edit Grids: Added new widget properties "Remove Selected Rows" and "Remove Selected Rows Confirm Message" for local data grids. When set to true, all selected rows will be removed from the grid. A non-blank value in the Confirm Message will prompt the user with the specified text prior to proceeding, with option to cancel.

NAB - Edit Grids: Adjusted logic so when Auto Edit widget property is set while the widget has not yet rendered or the store has zero records, the grid now listens for the next store load

NAB - Edit Grids: Adjusted defaulting of new row values for transformed columns. Previously when adding a new row with local data, numeric columns were defaulted to zero. This caused required dropdown columns to appear valid (not marked invalid) because they the default value of 0 was treated as non-empty. Now default to zero only applies to non-transformed numeric columns, ensuring required columns that have been transformed are properly validated as empty/invalid when newly added.

NAB - Edit Grids: Adjusted update record logic on data sources with left joins to automatically add records to the secondary table(s) when needed (per forum post)

NAB - Edit Grids: Added support for Week of Year in editable fields, matching the logic available to form widgets

NAB - Edit Grids: Added new fireEventOnEnter widget property for cell editing with local data. If set, it will fire a local event whenever the Enter key is pressed while editing a cell (per forum post)

NAB - Edit Grids: Added a new “Add Selected Rows” widget property that lists all edit grids using local data in the application to allow adding selected rows from the current grid/edit grid to that edit grid. Fields are mapped from one grid to the other edit grid’s fields. One or more fields must be mapped, and “Add Selected Rows” must be set to true to add the selected records.

NAB - Edit Grids: When using local data and adding a record, adjusted the logic to check for an initial value set on a field (matching the behavior already used when not using local data)

NAB - Edit Grids: Corrected issue where numeric fields with decimals would show a comma decimal separator, despite being set up to use a period separator?

NAB - Edit Grids: Corrected issue in Designer where clicking the Initial Value column for a field would sometimes result in an empty dialog window instead of showing the input to enter the initial value

NAB - Edit Grids: Corrected issue on edit grids linked to a form widget where, in rare cases, the form would become not visible

NAB - Edit Grids: Corrected issue where, if edit condition(s) were set on a column of the grid and another edit grid in the application had the same column name, it would also receive that edit condition

NAB - Edit Grids: Adjusted Designer to allow decimals in the min/max settings for editable number fields

NAB - Edit Grids: Adjusted Designer for local data to only show a single "delete" checkbox and not a dropdown for number of files for the delete, since that would not apply to local data

NAB - Edit Grids: Corrected issue in Designer where, if an editable field had a regex validation set, clearing that validation would still cause the regex to be used to validate the field

NAB - Edit Grids: Corrected issue where, if the grid was grouped by a column and that column was edited (not inline), the grouped column would become shown as a regular column after the update. The grouped column now remains grouped.

NAB - Edit Grids: Added new widget properties when using inline cell edit auto-edit functionality:
autoEditFocusField: when auto-editing a row, will focus that specific cell instead of the default first editable cell

addRowFocusField: when adding a record in local data mode, set to determine which cell receives focus during auto-edit

NAB - Edit Grids: Corrected issue where, in inline editing mode, adding a row was checking the edit condition rather than the add condition

NAB - Edit Grids/Forms: Added several new widget properties for any column/field that has been transformed into a dropdown:
data: Sets the data for the dropdown. If set, the dropdown will not automatically load the underlying store.

getData: Sets an app variable to the current data of the dropdown store

refresh: Reloads the store (this already existed for forms but not for edit grids)

totalCount: Sets an app variable to the total row count in the store

NAB - Forms: Added ability to add a horizontal line to a form widget in Designer

NAB - Forms: Added ability to set the tab index on fields within the form, overriding the default tab order of the fields (per forum post)

NAB - Forms: Added handler for new widget property clearReset which allows clearing the form and resetting specific fields to a value

NAB - Forms: Adjusted form validation on forms tracking the isValid property such that when a field’s min/max value is changed dynamically, the updated min/max values are now re-checked for validity

NAB - Forms: Adjusted update record logic so when an app variable is used to set a field value, the associated rendering and color of the field is updated accordingly

NAB - Forms: Corrected issue where a field container with a large number of fields could throw a console error and break the app

NAB - Forms: Corrected issue where, if a form’s widget property isInvalid was being used, a required field transformed into a dropdown was sometimes not setting isInvalid to true when it should?

NAB - Forms: Corrected issue where setting a non-editable field to bold was not applying the bold style properly

NAB - Forms: Corrected issue where form number fields were sometimes not set correctly when using the NAB app variable 'nabSetAllDecimalSeparators', if the number field has an input mask.

NAB - Forms: Corrected issue where “formFieldError” set via a NAB button program was only being applied after the form had already been shown once; it will now mark the field in error the first time the form is shown.

NAB - Forms: Corrected issue where hiding a field in the form was not hiding its after-text component if set

NAB - Data Sources: Adjusted parser to allow an alias on a vvin_virtual used as the table name in the FROM clause

NAB - Data Sources: Added new widget properties to override a widget’s data source vvIn_Virtual app variable value. This will only be shown if the widget’s data source uses vvIn_Virtual within the SQL statement. Use case: An app has two widgets that use the same data source; however, one widget’s vvIn_Virtual needs to have a different value from the other widget.

NAB - Data Sources: Corrected issue where vvIn_virtual could erroneously pull in a previous user filter value under certain conditions

NAB - Data Sources: Corrected issue where the SQL parser was incorrectly handling escaped single quotes within strings, adding additional single quotes

NAB - URL Widgets: Corrected issue where passed parameters could result in garbled values on vvIn_char under certain conditions (per forum post)

NAB - Filters: Added new option to place select filter fields on a second row, below the primary filter row. Must have at least one filter already selected.

NAB - Filters: When using "between" with a date field, adjusted logic so app will now validate date filters before applying them

NAB - Filters: Adjusted rendering for cases where filters are on the toolbar and the overflow menu is enabled so that the Apply/Clear buttons always appear first, so the filters will overflow but not the action buttons

NAB - Filters: When using the widget property to reset a filter, adjusted logic to check whether a reset value has been defined for that filter. If so, set the filter to that value instead of resetting it.

NAB - Filters: Corrected issue where a search value containing a single quote was being replaced with four single quotes instead of two in the back-end SQL Where clause

NAB - Filters: Corrected issue where setting a filter value via an app variable could sometimes not properly set the widget filter

NAB - Filters: Corrected issue where setting a filter as required via an app variable wasn’t working correctly when the widget’s data source was created via the wizard (non-SQL)

NAB - Filters: Adjusted so when the field data type is 'T' (time), value is now automatically formatted to ensure it is 00:00:00. If the filter is set to “between” and one value is populated while the other is not, automatically set the empty field to 00:00:00 or 23:59:59 as appropriate.?

NAB - Filters: Added new "Filter Locally" checkbox in Settings > Miscellaneous so local filtering can be turned off to allow filtering via the backend like normal. Previously, a local data edit grid would always filter locally.

NAB - Behaviors: On Call RPG PGM, added new functionality to fire a local event if the user cancels the 'prompt for more information' window

NAB - Behaviors: Adjusted getData to check metaData in graphic fields so, if found, fields will be decoded for each record returned

NAB - Behaviors: When firing a local event, adjusted to no longer pass the application's app variables as these are only needed for public events. This was causing an issue where firing a local event that then set app variables, followed by a filter widget using that app variable value, would result in the old value being used because it was passed with the event (per forum post)

NAB - Bahaviors: Corrected issue where when a button state was changed to disabled and a tooltip was subsequently changed, the tooltip would not display (per forum post)

NAB - Behaviors: In the Set App Variables window of Designer, added a "Set Only" checkbox which, when selected, limits the app variable list to only items that have been set or cleared

NAB - Behaviors: In the Set App Variables of Designer, corrected issue where clicking the search for app vars to set to another app var would close the available list. Also added a search for available fields.

NAB - Tab Containers: Added logic tabs marked in error such that clicking on the error icon in the tab will now find the first form that has a field in error and highlight it

NAB - Tab Containers: Corrected issue where fixed height would not be applied properly if a tab container existed anywhere in the app

NAB - Pie Charts: Adjusted rendering logic so it no longer attempts to show slices with zero values

NAB - General: App will now automatically add an overflow menu to app bar/toolbar whenever app section has more top buttons than can be displayed at once within screen width

NAB - General: For button colors, if an app variable is set to change the button color dynamically, it can now be set to 'default' to return the button to its original color

NAB - General: Added new "Auto Refresh" widget property that is available when auto refresh is set on the widget, allowing Auto Refresh to be turned off and back on via app variables

NAB - General: Added new widget properties "beforeLoad" and "afterLoad" that will set the corresponding app variable to true before the widget store loads and after the widget store loads. This can help trigger an action before or after a widget store loads.

NAB - General: Added new NAB-specific app variable "nabAutoFocusErrorCurrentSection" to manage auto-focus behavior for error handling in the current section. This can be used to auto-focus the first error in a section form/edit grid when users cannot perform an action, such as save, until errors are corrected. A benefit of this is that if a tab container is used and a widget within a tab is in error, the tab will automatically be activated to focus the error.

NAB - General: When auto-refresh is enabled on a widget, NAB will now verify the session has not received a 569 request logout before doing the reload (per forum post)

NAB - General: Corrected issue where, under certain conditions, a widget button was not getting disabled when an app variable linked to its disabled property was set to true

NAB - General: Corrected issue on buttons linked to feature IDs where the button could still show even when feature is disabled

NAB - Git: Corrected issue where the option to see the Git difference was only available if/data source, widget or app was currently checked out to the current user; The option is now available if has the object checked out.

NAB - Dev Console: Added logic to check if the "Return SQL" setting was enabled the last time it was open. If so, default it back to that state.

NAB - Dev Console: Adjusted to automatically sort app variables that were passed down in network calls by name

Portal Admin - Logs: Corrected issue where the list of users in the Valence User dropdown filter would only show the first 25 users

Portal - General: Adjusted logic for apps launched as non-closable popup windows so the ESC key does not close the window

Portal - General: Corrected issue for sites using the PKS eXcite product where additional parameters on the app launch could be truncated under certain conditions

Features and fixes in Valence 6.3.20251222:
NAB (Nitro App Builder) - Grids: Added support for dynamic checkbox selection visibility so when checkbox selection is enabled and the checkbox’s visibility is controlled by an app variable-dependent condition, changes made to the app variable will now re-evaluate the condition and re-render.

NAB - Grids: Added new link-widget property checkboxClearSelection. When checkbox row selection is enabled and this property is set to true, the link widget will clear all selected rows in the grid.

NAB - Grids: Adjusted paging logic to reload grid on page 1 when user changes page size via the dropdown on the paging toolbar?

NAB - Grids: Corrected issue where decimal separator adjustments to nabSetAllDecimalSeparators were not being applied to edit grid cells and summary columns

NAB - Grids: Corrected issue on numeric columns where checking the hide-zero-values flag on a canned numeric format would persist after switching the column to a custom formatter

NAB - Grids: Corrected issue where grids with checkbox selection turned on and a maximum number of selections set via Widget Properties could cause multiple snackbar messages about reaching the maximum to appear

NAB - Grids: Corrected issue where custom column formats were not being applied to Excel/PDF downloads

NAB - Grids: Corrected issue where a grid with summary row(s) could trigger an error when downloading

NAB - Grids: Corrected issue where “hide zero values” on the formatter could be checked yet zero values would still show?

NAB - Grids: Corrected issue where a formatted column used as a 'group by' field would break the grouping function (per forum post)

NAB - Edit Grids: Corrected issue on grouped grids where rendering errors could occur when the grouping field was changed by the user

NAB - Edit Grids: Corrected issue in row-editing mode where icons in icon columns would not remain correctly aligned with the row fields when the Cancel/Update buttons are positioned at the top or bottom

NAB - Edit Grids: Corrected issue with drop-down grid where the incorrect value could show under certain conditions

NAB - Forms: Corrected issue where enabling the "Align numbers to the right" global default (Portal Admin > Settings > Nitro App Builder) would incorrectly right-align numeric display-only fields in forms. Display fields now ignore this global setting and respect only the alignment explicitly configured for the field.

NAB - Filters: Add a new widget link property for widgets containing filters so individual filters can be marked as required

NAB - Behaviors: Adjusted Designer so when adding a fire event action, the Enter key can now be used to save instead of having to click the save button

NAB - Behaviors: Corrected issue within “Show Section” behavior where a button hidden via an app-variable condition would remain visible when navigating to the section, even though the app variable was correctly set to hide it.

NAB - Behaviors: Corrected issue where, in some cases, buttons using an inverted hide app variable link would not hide/show appropriately

NAB - Behaviors: Corrected issue in Designer where deleted local events were remaining in the "Add Listener" window

NAB - Data Sources: Updated SQL parser to support exception join statements

NAB - Data Sources: Updated SQL parset to support LATERAL values in From clause

NAB - Data Sources: Updated SQL Parser to recognize VALUES 1, 2 to work the same as VALUES (1), (2)

NAB - Data Sources: Corrected issue where J and O type fields were being treated as standard character fields

NAB - Utility Widgets: Corrected issue with Info Widget where HTML-encoded line breaks would not break (per forum post)

NAB - Calendar Widget: Corrected issue where the "+X more" popup on monthly view was not scrolling vertically (per forum post)

NAB - General: Added ability to either play a custom sound (specify relative path) or a canned sound (alert, chime, confirmation, error, success), in either Desktop or Mobile (per forum post)

NAB - General: Added new app variable "nabInfoDuration" to override the number of seconds the nabInfo snackbar is shown before it’s hidden (per forum post)

NAB - General: Added new "Send To Backend" options when adding new app variables to control whether the backend should receive the values

NAB - General: Adjusted Designer's add app variable window to include a new "Add Another" button, making it easier to add multiple app variables in succession. This function can also be triggered via hitting shift-Enter, so no clicking required.

NAB - Developer Console: Added new "watch" feature for focused app variable debugging. Specified app variables will be listed in a dedicated tab?.

NAB - Developer Console: Added functionality to log network calls that return a document. Previously you wouldn’t see such calls in the network call list.?

NAB - Developer Console: Improved readability of app variable values so that when they contain an array or object, the values will now automatically be collapsed with the ability to expand them

NAB - Mobile Portal: Added support for public events (requires applying the latest Mobile Portal update)

Portal - Change Password: Adjusted to accommodate CPF4AA7 password rule exceptions. Window now shows the full text associated with triggered reason code.

RPG Toolkit - vvUtility_rtvMsgText: Expanded message text field size in returned data structure

New Features and Fixes in Valence 6.3.20251117:
Nitro App Builder (NAB) - Grids: Added a new link widget property available when checkbox selection is enabled: checkboxSelHide. When set to true, the column will be hidden, otherwise it will be shown

NAB - Grids: Corrected issue with NabSetAllDecimalSeparators app variable changes only being applied to the first editable cell for the column rather than all cells

NAB - Filters: Adjusted toolbar filter Reset button so it no longer resets the paging toolbar when clicked

NAB - Edit Grids: Adjusted rendering for cell editing on fields flagged as textareas, adjusting the styling so the full height of the textarea is visible

NAB - Edit Grids: Adjusted UI so that disabled cells will no longer be highlighted as in error

NAB - Edit Grids: For grids using cell or row editing, on a field being transformed into a dropdown/dropdown grid/lookup, added ability to set the edit grid record's field(s) to a field value from the transformed widget (indicated by name with a "_DS" suffix)

NAB - Edit Grids: Corrected issue where a non-editable cell disabled by a feature setting was still showing as editable

NAB - Forms: Added fireEventOnEnter link widget property so an event can be fired when user hits the Enter key

NAB - Forms: In Designer, the Allow Link Widget Property Reset Value section now lists all fields, including ones that are not editable

NAB - Forms: Added a new "Don't Grow" option for fields transformed into a dropdown with multi-select turned on. When enabled, the field will not grow in height at all after item(s) are selected.

NAB - Forms: Corrected issue where a field formerly highlighted as being in error would remain so even after the error condition was corrected

NAB - Filters: Corrected issue where user filters set to appear in a popup window were not showing due to a console error

NAB - Filters: Corrected issue in Designer where a console error would occur when user filters had "Enable Menu Overflow" checked

NAB - Filters: Removed adjustment from prior build addressing ssue where widget filters based on app var via vvIn_Virtual were retaining previous value in session storage when filter field was cleared. Will readdress.

NAB - Data Sources: Adjusted parser to support column lists after aliases in VALUES clauses or subqueries used in FROM clauses. Example: AS DummyFile (id, description)

NAB - Data Sources: Adjusted parser to support functions within VALUES clauses

NAB - Data Sources: Corrected issue where if a table function was used in select statement it would be limited to only one subsequent join statement

NAB - Data Sources: Corrected SQL Parser so it parses correctly (VALUES(ABC)) as a result column correctly. Previously it was treating it as a sub select statement.

NAB - General: Corrected a timing issue where setting the subtitle of a widget via link widget properties would sometimes not set the subtitle if the widget wasn't yet available

NAB - General: Rework the App Variables list in Designer: Expression columns will no longer wrap; improved tooltip readability for expressions; replaced the Do Not Pass to IBM i and Do Not Pass If Empty checkcolumns with a single combobox column

NAB - General: Completely reworked the widget options form that appears in Designer when selecting a widget. Now includes ability to specify border width and radius for top/right/bottom/left

NAB - Import/Export: Corrected an issue where a hard-bracketed substitution value inside VVSETTINGS could trigger a MSGW on import. Entailed an adjustment to vvIn_Char for session ID pulls.

Fusion 5250: Corrected issue where copy/paste function would not work if user took an excessive amount of time to select the copy area

New Features and Fixes in Valence 6.3.20251030:
Nitro App Builder (NAB) - Grids: When Global Search is used, columns that are not applicable to the search value (e.g., column size is shorter than search string, or type of column does not apply) are no longer included in the search. If no columns apply to the search an exception message will be shown and the grid will not be reloaded.

NAB - Grids: Added new "clearSort" app variable linkage property that will clear the sort of the grid or set it to its default/original sort state\

NAB - Grids: Corrected issue on download to Excel where, if the grid has column container(s) and the "Excel override" feature is used with the "Use base column format" option unchecked, the Excel document would lose the column container(s)

NAB - Grids: Corrected issue where, on grids with column container(s), the first column in the container would always have center alignment instead of the alignment set on the column itself

NAB - Edit Grids: Added "addRowCount" link widget property for local data edit grids that allows you to programmatically add row(s) to local data edit grids

NAB - Edit Grids: Adjusted logic so when using local data, row menu and icon columns that call a back-end RPG on click will only pass that row, rather than the entire grid

NAB - Edit Grids: When using local data, EXNABBTN-based programs can now use new procedures CommitRow and RemoveRow to visually commit (remove red change mark) or remove specific rows

NAB - Edit Grids: Updated grid import to support double byte (Japanese) characters

NAB - Edit Grids: Adjusted grid import logic to better support different date formats

NAB - Edit Grids: Corrected issue with cell editing and date fields where the date field would register as changed even if the same/original date was selected (per forum post)

NAB - Edit Grids: Corrected issue where configurable features (Add Record, Edit Record, Delete Record, Import) were not being applied to the edit popup window (per forum post)

NAB - Edit Grids: Corrected issue where backend SetRowValue() could update the wrong local data record under certain conditions

NAB - Pivot Grids: Corrected issue where the pivot would not display correctly if "Lock Left Axis" is enabled and the pivot is not in the main section of the application

NAB - Forms: Added new "formFieldValueSilent" option to EXNABBTN-based programs to update a form field's value without triggering the "hasChanged" property of the form to change (per forum post)

NAB - Forms: Added ability to left/center/right-align any non editable fields in Designer

NAB - Forms: Adjusted Designer to better accommodate field sequencing within field groups, via a new popup window that can be activated by clicking on "Manage Fields"

NAB - Forms: Adjusted Designer so, when selecting a field to add to a field group, it will no longer automatically collapse the dropdown picker so users can more easily select additional fields

NAB - Forms: Corrected issue where an editable field with an input mask could start flickering if user was hitting the tab key quickly (per forum post)

NAB - Forms: Corrected issue where field groups without a border, and containing fields with left or right alignment, did not have any spacing between field groups

NAB - Forms and Grids: Added a field mapping window to Designer that will appear whenever widget configurations reference fields/columns that no longer exist in the data source, providing an opportunity to adjust the mapping instead of dropping the reference

NAB - Behaviors: Added a Link Widget Property to set a column label when the grid includes an icon column (per forum post)

NAB - Behaviors: Added new "nabShowSection" app variable that allows you to set the name of the section you want to show

NAB - Behaviors: Added a new "getData" action to retrieve data from an existing data source. With this you can now link the total count of rows returned to an app variable, link all data returned to an app variable, link specific app variables to the first row returned, and trigger an event after data load is completed.

NAB - Dropdown Multiselect: Corrected issue where, if the user is typing in the field and selects an item, the typed value remains in the input element

NAB - Filters: Added a new filter setting under Miscellaneous called "Auto Apply Filters" (checked by default). If unchecked, and the filter is a date picker, checkbox, dropdown, lookup, or dropdown grid, the widget will no longer immediately apply the filter when value is changed.

NAB - Filters: Corrected timing issue where a filter value set via an app variable would sometimes not be applied

NAB - Filters: Corrected issue where a widget filter based on a vvIn_Virtual value would retain the previous value in session storage when filter field was cleared (per forum post)

NAB - Filters: Corrected issue where multi-select combo using saved filter values (remember last value) would generate an invalid SQL statement

NAB - Filters: Corrected issue where user filter set value linkage was not working if file or field name included multiple underscores

NAB - Utility Widgets: Corrected issue where transforming an existing utility widget into a popup would sometimes not carry over the assigned name that was originally assigned to the widget

NAB - Utility Widgets: Corrected issue in URL widget where it was not correctly structuring the url when running in the mobile portal

NAB - General: Corrected issue with Tab Utility widget and Link Widget Properties not working with "inverted" values

NAB - General: Added new "getData" link widget property to sync widget data to app variables

NAB - Exit Programs: Increased maximum size of response in EXNABBTN-based programs, which was previously limited to 64K (per forum post)

NAB - Data Sources: For SQL-based data sources, corrected issue in Designer where leaving statement blank would make the app unresponsive, forcing the user to reload NAB

NAB - Developer Console: Adjusted to show the data source name in the network section when applicable

NAB - Horizontal Containers: Corrected issue where a widget's fixed width within a horizontal container was not being saved in Designer

NAB - Tab Containers: Corrected issue where setting a title or subtitle via an app variable would cause the application to crash

NAB - Import/Export: Corrected issue where portal settings could start pulling values from the import instance after an import

NAB - Import/Export: Corrected issue where linked data sources (i.e., those used in a drop-down) were not being included on an export for an app (per forum post)

NAB - Dev Console: Updated the network list to include calls that are uploading a file (per forum post)

RPG Toolkit: Adjusted vvUtility_lock to avoid occasional MSGW condition that could be caused when a front-end call to VVLOGIN does not pass a sid (session ID)

RPG Tookit: Adjusted vvUtility_logError to avoid recursive posting of exception messages into error file stemming from calling VVMAIL_Send() in a non-CGI batch environment

New Features and Fixes in Valence 6.3.20250923:
Nitro App Builder (NAB) - Grids: Added an option to exclude specific columns from the generic grid search (entitled "searchable"), available when not searching by column or using a local search (per forum post)

NAB - Grids: Corrected issue where, when a menu button or icon column was set to call a backend program and the grid had checkbox selection enabled, selecting multiple rows caused the row menu button or icon column to pass all selected rows, not just the row clicked (per forum post)

NAB - Grids: Corrected issue where locked columns were not remembering column "state", such as resize, order, hidden (per forum post)

NAB - Grids: Corrected issue where if global grid search this is turned on over a hex-sorted data source, an error could occur on graphic fields encoded to double byte CCSID values

NAB - Edit Grids: Corrected issue where, when an edit grid allowed multiple tables for deletion, the widget property "deleteConfirmMsg" was not available unless it had only one table

NAB - Edit Grids: Corrected issue when using cell editing where if a numeric field’s decimal positions were specified (i.e., overridden via a widget property or app variable), the setting was not being applied

NAB - Edit Grigs: Corrected issue when using form-based editing where a field's decimal positions setting could cause a minor value change to not be detected and thus not be applied to the underlying file

NAB - Pivot Grids: Adjusted to allow for selecting specific types of exports if exporting is turned on, rather than providing all the download options (per forum post)

NAB - Forms: Adjusted timing for primary button (triggered by ENTER key) to ensure helper program is called and completed prior to executing the click action (per forum post)

NAB - Forms: Corrected issue where using an app variable to set all form fields to read-only was not accommodating field-level overrides to the read-only property

NAB - Utility Widgets: Corrected issue where horizontal containers were not made available to be added when inside a tab container > scrolling container

NAB - Timelines: Corrected issue where reloading a timeline that was not grouping was not working properly

NAB - Behaviors: Added setAppVar method to be made available when using Filter Widget and providing a custom filter

NAB - Behaviors: Corrected issue where buttons that should be shown would sometimes not appear under certain conditions (per forum post)

NAB - Data Sources: Adjusted SQL parser to identify the line number causing a syntax error, when possible

NAB - Data Sources: Corrected issue where spaces were not being added correctly for httpgetclob syntax in the SQL parser, resulting in an error upon validation

NAB - General: Corrected issue where the 'preventAutoLoad' set to true on a widget would, under certain conditions, autoload the widget anyway

NAB - General: Corrected issue where the 'nabHideDataSourceLoadMask' property was not being checked on form and map widgets, resulting in the mask being shown even when set to true

NAB - General: Corrected issue in Designer where the check-in/check-out information could incorrectly render the name or description of a NAB object

Portal - Login: Adjusted Kerberos login logic to no longer throw "REMOTE_USER not found" exceptions into error log

Portal Admin - Categories: Corrected issue where disabling a category was not saving correctly

RPG Toolkit: Added VVKILLALL command, which will terminate all active sessions in the instance (per forum post)

New Features and Fixes in Valence 6.3.20250910:
Nitro App Builder (NAB) - Grids: Corrected issue involving checkbox selections inside infinite scrolling grids where the grid would think previous selections were still selected after a refresh (per forum post)

NAB - Edit Grids: Expanded the "No decimals" and ability to set a max value configuration to include dialog editing (previously only applied to inline editing)

NAB - Edit Grids: Corrected issue where a console error could occur in cases where grouping is enabled, local data is active, and the value of a group field is changed

NAB - Edit Grids: Corrected issue where, when row editing and defaulting the number of decimals allowed for a field are enabled, the app could encounter a console error at startup

NAB - Edit Grids: Corrected issue where, if a column's Decimal Positions had a default value, a console error could occur if the grid was not yet available

NAB - Forms: Adjusted logic for accommodating pasting into a numeric field so that line breaks are ignored and only valid numeric digits are accepted

NAB - Forms: Corrected issue where Radio Buttons that had been disabled and then reenabled via an app variable change would remain disabled

NAB - Forms: Corrected issue in dropdown grid where, if initially empty and then a selection was made, the form's "isChanged" linkage was not being set

NAB - Forms: Corrected issue where, under certain conditions, setting all fields to readonly true/false was not being applied to all fields

NAB - Filters: Adjusted logic so that hidden filters are not included when checking that all filter values are valid

NAB - Tab Panels: Corrected issue where a hard error could occur if tab panel widget properties were manually set instead of using an app variable

NAB - Data Sources: Added support for QUARTER, WEEK and EPOCH in EXTRACT function inside SQL parser

NAB - Data Sources: Corrected issue where vvIn_Virtual would escape single quotes inside a field value when it should not be

NAB - Data Sources: Corrected issue where a DISTINCT clause was not being handled properly in parser

NAB - Data Sources: Corrected issue with certain CASE statement structures not being recognized by parser (per forum post)

NAB - Behaviors: Improved window height optimization logic on Call RPG Program additional info window

NAB - Import/Export: Corrected issue where apps consisting of only utility widgets and/or other app references would fail to import

NAB - General: Added new App menu option Miscellaneous > Debug Info to assist with pulling pertinent debug info for tech support

NAB - General: Corrected issue where the appbar title was erroneously line breaking when html markup exists in the title

NAB - General: Corrected vertical alignment on appbar title, which was off on any apps using slim or ultra slim UI

NAB - General: Corrected issue where Main section lost the ability to specify Settings (width)

NAB - General: Corrected a Safari-specific issue where the Save Widget dialog box would appear empty or blank

Portal - General: Corrected issue with URL parameters being unnecessarily encoded upon app launch

Portal - Login: Adjusted back-end logic to return user's email address upon successful login

New Features and Fixes in Valence 6.3.20250821:
Nitro App Builder (NAB) - Grids: Added summary.isGroup for custom renderer, which will be set to 'true' when working within the summary of a group and not the total summary row

NAB - Grids: Corrected issue where summary values were not displaying correctly on PDF downloads

NAB - Grids: Corrected issue where a PDF download over grids containing images would fail under certain circumstances, leaving the screen masked as if it were still building the file

NAB - Grids: Corrected issue where any grid utilizing the "Selection Total" app variable link would cause a console error upon startup of the application

NAB - Grids: Corrected issues with the combineButtonsAndFilters widget property where, if global search was not enabled, then action buttons could sometimes disappear and toolbar items could appear with a fill at the front, causing filters to be centered

NAB - Grids: Corrected issue where the summary.group.get for a custom formatter would sometimes not give the group value (only applies if summary is active for a column and the grid is grouping)

NAB - Grids: Corrected issue in Designer where dragging and dropping a column container could result in a hard error

NAB - Edit Grids: Added an option to prevent decimals on editable fields that contain decimal places

NAB - Edit Grids: Added ability to dynamically change the number of decimal places on columns that are editable on edit or add. Must be equal to or less than the field's original number of decimals.

NAB - Edit Grids: Added a maximum value option to numeric fields, similar to the minimum value option

NAB - Edit Grids: Added logic to validate that a file selected for upload matches the file type specified

NAB - Edit Grids: Corrected issue where, when using Cell Editing, and a cell was both editable and locked, a console error would cause the widget to become unresponsive

NAB - Edit Grids: Corrected issue where, under certain conditions, fields flagged as read-only were still editable

NAB - Edit Grids: Corrected issue with Inline Row Editing where if a transformed field is the only item flagged as editable (not read-only), then the row editor would not display on row click

NAB - Edit Grids: Corrected issue where isInvalid widget property was sometimes set to false even though a field on the row was invalid

NAB - Edit Grids: Corrected issue on grids using local data where filters were being applied to the data source rather than to the local data

NAB - Forms: Adjusted "minimum value" configuration to allow up to 5 decimal places

NAB - Forms: Adjusted UI so that whenever a field has an input format defined, the field value will be automatically selected when focused (per forum post)

NAB - Forms: Corrected timing issue where hitting Enter too quickly after changing a field linked to an app variable could sometimes result in the value not being passed to the form helper program (per forum post)

NAB - Forms: Corrected issue where multiple selection combos inside forms using slim or ultra-slim view were not showing the first character when typing into it (per forum post)

NAB - Forms: Corrected issue where setting a tooltip to a field via an app variable was only working on editable fields

NAB - Forms: Corrected issue where the isInvalid property could be incorrectly set to true upon loading data under certain conditions

NAB - Forms: Corrected issue where fields transformed into dropdown grids could indicate that the form has changes (via "hasChanged" property) when no changes have actually been made

NAB - Forms: Corrected issue in Form Helper where field value would not be set when program was filtering a drop-down field's data and setting its value on the same call

NAB - Forms: Corrected issue on lookup fields where the read-only property was not being honored when set to true

NAB - Forms (mobile): Corrected issue where attempting to use the NAB file upload inside a form would fail

NAB - Forms: Corrected obscure issue where a field transformed into radio buttons inside an edit grid-linked form, where the form includes a helper program for form rendering and the radio buttons are connected to a data source, could result in the value of the radio button field not being passed down properly

NAB - Info Utility Widget: Added ability to attach a "primary" button

NAB - KPI widget: Corrected issue where the progress bar was not visible

NAB - Timeline widget: Corrected issue where a refresh would cause wrong results if grouping is enabled and the previous dataset had new groups added or removed (per forum post)

NAB - App Variables: Corrected issue where assignment of a string value with an embedded "E" could be incorrectly interpreted as scientific notation (e.g., setting an app variable to '12345E02' would be interpreted as '1234500')

NAB - Behaviors: Adjusted Designer to include nabFeature app variables, etc. in the link widget properties list

NAB - Filters: Added option to have filter(s) initially hidden

NAB - Data Sources: Added support to SQL parser for sub-selects with unions

NAB - Data Sources: Added support to SQL parser for hierarchical traversal clauses (e.g., "start with xxx conect by yyyy) by converting the main statement to a CTE so filtering can be successfully applied at runtime

NAB - Data Sources: Added support to SQL parser for RECURSIVE keyword in CTEs (e.g., "WITH RECURSIVE numbers (n) AS (...")?

NAB - Data Sources: Adjusted the SQL parser's comment handling so it now converts line comments into block comments, as the IBM i SQL validator cannot always accommodate line comments

NAB - General: Added a new widget property, 'preventAutoLoad', which when set to true will prevent the widget from autoloading

NAB - General: Corrected issue where enabling a feature would sometimes not show the button/widget to which the feature was attached

NAB - General: Corrected issue in Designer where if a vertical container has more than one horizontal container within it, only the widgets for the last horizontal container are saved

NAB - General: Corrected rare issue where, upon clicking data source menu button to create a new widget, the loadmask would not clear

NAB - Import/Export: Corrected issue where any widget using the "clear data" option would revert back to "load data" (default) upon import

Instance Manager: Added ability to terminate all sessions in a specific instance

RPG Toolkit - vvOut_Data: Corrected issue where a pointer to data flagged as "binary" was being treated as regular character data and thus corrupting the output

Portal - Web Services: Adjusted back-end VVSECURE web service logic to be more efficient when pulling in Valence settings (now skips data area check)

Portal - General: Corrected issue when launching apps where "%" was getting encoded when it shouldn't be

Portal Admin - Apps: Corrected issue where, when a delete request for an app was blocked due to the app being referenced in another app for launch, no error message was showing explaining why the delete could not be processed

New Features and Fixes in Valence 6.3.20250708:
Nitro App Builder (NAB) - Grids: Added a new "Selection Total" section under Link Widget Properties that can be used when checkbox selection is enabled and grid allows multiple selections (per forum post)

NAB - Grids: Added a new link property "hideRowBody" which, when set to true, will hide any row body content and, if expandable, the expander column.

NAB - Grids: Added a new link property "combineButtonsAndFilters" for use on grids that have filters on the toolbar as well as top toolbar buttons. When set to true, the elements will be consolidated into a single toolbar.

NAB - Grids: Corrected issue where, on grids with two downloads that were not paging and had multi-sort enabled, the right-most button was not fully visible

NAB - Grids: Corrected issue where right-click action was not working on right-aligned icon columns

NAB - Grids: Corrected issue where PDF downloads over grids with both grouping and summary functions activated were not being built correctly

NAB - Edit Grid: Corrected issue where a form linked to the edit grid containing fields transformed into radio buttons would sometimes fail to display the selected value of the field (i.e., no radio button is selected)

NAB - Edit Grids: Added a new Import CSV/Excel feature (Beta)

NAB - Edit Grids: For local data, added a new widget property "dataCommitted" which, when set to true, locally syncs the store, treating new, changed, or deleted records as if they are in a "clean" state, as if the data had just been reloaded. This is helpful if you save data for a local data edit grid and don't want to reload the grid just to turn off the data changed cell indicators.

NAB - Edit Grids: Corrected issue with inline cell editing where a column set to be editable on add but not on edit (or vice versa) was not working as expected

NAB - Edit Grids: Corrected issue introduced on prior build to consolidate action buttons where possible, where if the edit grid had "Add" ability enabled and included an action button, it would lose the Add button

NAB - Edit Grids: Corrected issue where the "hasChanged" link property would not work on grids using local data with in-line editing

NAB - Edit Grids: Corrected issue where a field marked as available for both add and edit, with only the edit field marked as read only, would incorrectly show as read only for adding as well

NAB - Edit Grid: Corrected issue where if "Add" feature was disabled via a startup program, the button was not hidden as expected

NAB - File Upload: Added the ability to drag and drop a file onto the upload field

NAB - Filters: Corrected issue where filter fields transformed to drop-down grids were not being applied correctly

NAB - Forms: Added new option "Turn Off Browser Suggestions" that will prevent the browser from auto-suggesting any values in fields (addresses, passwords, etc.)

NAB - Forms: Added new widget property link "focusFieldName" wherein specifying the name of a form field will auto-focus to that field

NAB - Forms: Corrected issue where a display field sometimes doesn’t show the proper value when set via an app variable

NAB - Forms: Corrected issue where linked app variable to set all fields to 'read only' was not being applied to lookup fields

NAB - Forms: Corrected issue where linked app variable to set all fields to 'read only' was not working against fields which were separately linked to field-specific 'read only' app variables

NAB - Charts: Added color rules for gauge charts (per forum post)

NAB - App Variables: For app variable expressions, added a new local function called nabTriggeredBy(), into which you pass an app variable name (or an array of app variable names). Function will return true if any of the passed app variables triggered the call to the expression for re-evaluation.

NAB - App Variables: Added a new app variable "nabMaskApplication" which will mask the app when set to true, or when set to a text value will mask the app with the specified text. When set to false the application is unmasked.

NAB - App Variables: Added "nabRefreshAllVisibleWidgets" to trigger new refresh option

NAB - App Variables: Corrected issue where nabCurrentTimeStamp was not being set to the current time of the device (per forum post)

NAB - App Variables: Corrected issue where calculated fields transformed into a drop-down grid, the field would not be listed in the "Selected Record: FIELDNAME" link app variable section

NAB - Behaviors: Added a new Utility Action in behaviors: Utility > Refresh All Visible Widgets

NAB - Data Sources: Added support for comment blocks in SQL. Must /* apply comments like this */

NAB - Data Sources: Added support for escaping single quotes

NAB - Data Sources: Adjusted vvIn_virtual to escape any single quotes found in the app variable value

NAB - Data Sources: Adjusted SQL formatter to better handle reserve keywords during formatting. Prior to this a space could be injected - for example, "DIV#" was previously formatted as "DIV #" because DIV is a division keyword. Now, DIV# remains DIV#.

NAB - App Breadcrumbs: Corrected issue where an app variable linked to the breadcrumb text would not get updated properly after being set initially

NAB - Timeline Widgets: Corrected issue where setting the UI > Scale Step in the link to widget properties, the step was not being applied correctly to the scale

NAB - Event Listeners: Added ability to use Utility > Refresh action on event listeners

NAB - Exit Programs: EXNABSTART-based programs using disableFeature are now setting app variable nabFeatureXXXX (where XXX is the feature name) to make the action more visible in the NAB Console

NAB - Dev Console: Added search option over data source responses

NAB - Dev Console: Corrected issue where the Active Widgets/Fields section would not always show all visible widgets under certain conditions

NAB - Utility Widget: On scrolling containers, added a new settings property to allow for collapsing/expanding the container items

NAB - General: Added a new widget property called "nabHideDataSourceLoadMask" which, when set to false, will omit the mask on the widget during load

NAB - General: When a numeric field has been transformed to a checkbox, adjusted logic to ensure that boolean values are not used; Developers must specify custom numeric values for true and false, which default to 1 and 0 respectively.

NAB - General: Corrected issue where apps being launched with a parameter passed to set nabHideAppBar to true was not always working properly

NAB - GIT: Corrected an issue where a commit message containing double-byte characters would trigger an error when performing a rollback

Instance Manager: Added ability to terminate all sessions in a specific instance (back-end logic only; front-end functionality will be released next month)

Portal Admin - Settings: Adjusted Java Classpath entry to be a pop-up grid rather than a text area; Adjusted authorized programs to be listed in alphabetic order

Portal Admin - Settings: Corrected issue where license expiration date was not showing on hover

Desktop Portal: Added ability to add or remove an app as a favorite via the search bar in the top-right corner by checking or unchecking star icon

New Features and Fixes in Valence 6.3.20250516:
Nitro App Builder (NAB) - Grids: Adjusted PDF download logic to accommodate flex widths on columns

NAB - Grids: Adjusted rendering so that any buttons added to the top or bottom of the widget will be consolidated with download buttons (when not paging) and global search field (if activated).

NAB - Grids: Added a new widget property to optionally hide the 'copy data' button

NAB - Grids: Added ability to use setBackgroundColor and setTextColor when using custom formatting for a summary column (per forum post)

NAB - Grids: For grids with global search activated, a new Link Widget Property called searchClause has been added under General. If this property is linked to an app variable, the grid widget will not apply the search SQL clause and will instead set the app variable with the search clause, in which case the app variable would typically be applied in a vvIn_Virtual within the WHERE clause of the main SQL statement. Additionally, a new section within the Link Widget Properties, called "Search Clause," will list all fields in the data source, allowing you to override the field name used in the search clause.

NAB - Grids: Adjusted global search field to be case-agnostic on character columns when the underlying data source is using hex sort sequence

NAB - Grids: Added checkbox in Designer to indicate the global search field should span the entire width of the grid

NAB - Grids: Adjusted local search functionality to be case-insensitve

NAB - Grids: Corrected issue where the global search was not being properly set by a linked app variable

NAB - Grids: Corrected issue where state (column order, size, hidden state, etc) could get mangled when columns are locked

NAB - Grids: Corrected issue where a global search field set to only execute when Enter is pressed would fail to process when the value was changed or cleared via an app variable

NAB - Grids: Corrected issue where numeric columns on legacy Excel downloads were not being formatted properly; Also improved default column width calculation, which is invoked whenever an explicit column width has not been specified.

NAB - Grids: Corrected issue in non-legacy Excel downloads where checking the "Exclude headers" option would cause a hard error

NAB - Grids: Corrected issue where under certain conditions the Row Select app variable link would not work with a right click against a grid row (per forum post)

NAB - Edit Grids: Added user page size selection option, matching functionality added for regular grids in the prior build

NAB - Edit Grids: For row editing, adjusted so that the attached row/form helper program will now make initial call using gMode as "formRender" instead of "rowRender"; It will now also call the helper program each time a field is changed (per forum post)

NAB - Edit Grids: Adjusted logic to support regular expressions in non-inline edit grids (previously only applied to edit grids using inline editing)

NAB - Edit Grids: Corrected issue where a field transformed into a radio button was not displaying correctly during editing

NAB - Edit Grids: Corrected issue in cell-level edits where color rules would not be reapplied as expected after the cell value was changed

NAB - Edit Grids: Corrected issue in cell-level edits transformed into a lookup where the value on a subsequent row could change in error to the prior row's value when the display value and lookup value were identical

NAB - Edit Grids: Corrected issue with local data where, if a field was graphic, it would not decode the value in some situations, causing the typed value to become the encoded value

NAB - Tree Grids: Corrected issue where an icon column sometimes wouldn’t show on certain levels

NAB - Tree Grids: Corrected issue where selected rows could become unselected when the parent row is collapsed (per forum post)

NAB - Tree Grids: Corrected issue in Designer where removing a column container could cause a hard error when rebuilding the selected columns / tree grid columns (per forum post)

NAB - Forms: Adjusted maximum value logic to throw an error message rather than override the form field value to the maximum when exceeded

NAB - Forms: Adjusted rendering for text areas to increase line spacing when the field font size is large or extra-large (per forum post)

NAB - Forms: Corrected issue where, on PCs running Windows, multiple fields with an input format could compete for focus, causing an unwanted blinking effect (per forum post)

NAB - Forms: Corrected issue where field values linked to app variables were not being updated as expected when the field value was blank or zero

NAB - Forms: Corrected issue on mobile where the non-editable background color property was not being applied as expected

NAB - Forms: Corrected issue on mobile where a button placed next to a field was not aligning with the field

NAB - Maps: Adjusted map widget logic to support functional changes recently introduced by Google

NAB - Filters: Adjusted logic for initial values on checkbox-based filters to support the unchecked state as well as the checked state. For example, previously an unchecked box could be set to 'false' instead of zero (0).

NAB - Calendar Widget: Corrected issue where shift to daylight savings time could cause events to display on prior day's calendar cell

NAB - Widget Filters: Adjusted logic so that when all filters are initially hidden, the Apply and Reset buttons are not displayed (per forum post)

NAB - Widget Filters: Corrected an issue where multi-select drop-downs rendered in "ultra slim" mode would truncate a character (per forum post)?

NAB - Behaviors: Added app-level events for function keys, allowing the application to listen for a function key press and then perform specific behaviors (per forum post)

NAB - Behaviors: Added support for time fields in "Prompt for more info" on RPG program calls (per forum post)

NAB - Behaviors: Adjusted calls to backend programs to ensure JSON arrays are "stringified" to retain their hard brackets (e.g., "[1,2,3]" will no longer be passed as "1,2,3")

NAB - Behaviors: Added ability in Designer to search the app variable listing (per forum post)

NAB - Behaviors: Corrected issue where retrieving an app variable from within an "execute script" action was not working properly

NAB - App Variables: Adjusted logic so that when a backend RPG program sets an app variable to a value beginning with a plus sign (i.e., '+123'), the value is treated as a string so the plus sign is retained. Previously such a value would be treated as a positive number and the "+" prefix would be dropped.

NAB - App Variables: Adjusted logic to prevent super long numeric strings from being expressed in exponential notation, so 1234567890123456789012 will no longer become 1.2345678901234568e+21 (per forum post)

NAB - App Variables: Adjusted logic so that when a value is wrapped in [hard brackets], check to see if it refers to another app variable before actually replacing it. If no app variable exists, NAB will now leave the value intact (with the brackets).

NAB - App Variables: Adjusted logic to ensure all NAB-specific app variables (such as nabUserId) are set immediately upon app launch, so any app variable expressions that reference them are processed as expected

NAB - Developer Console: Adjusted logic so that when one or more NAB apps have been launched within the current NAB app, a window will automatically appear prompting you to select which NAB app to monitor (per forum post)

NAB - Developer Console: Corrected issue where dropdown grids would sometimes be shown in the widgets section multiple times; Corrected issue where searching in the network calls was not working properly; Added a tooltip when hovering over widgets in the widget section to show the underlying data source ID.

NAB - Import/Export: Corrected issue where an app containing nothing but utility widgets would fail to export (per forum post)

NAB - Import/Export: Corrected issue where exported widgets containing numerous intricate configurations (thereby requiring longer amounts of configuration instructions) could result in a corrupted widget upon import

NAB - Data Sources: Adjusted logic that derives available files and fields to accommodate scenarios where fields are not visible in QSYS2.SYSCOLUMNS (e.g., join logical files and remote data aliases)

NAB - Data Sources: Adjusted SQL parser to recognize CAST to character with no specific field length - e.g., CAST('-' AS CHAR CCSID 37)

NAB - Data Sources: Corrected issue where a vvIn_virtual replacement exceeding 2056 characters was being truncated. Now supports up to 32K characters.

NAB - Data Sources: Corrected issue where result columns in subqueries were not always being included during statement parsing

NAB - Exit Programs: Added a new gTabNumber global variable that will be populated with the tab number for the current widget, when applicable

NAB - Exit Programs: Corrected issue in EXNABBTN-based helper programs where the call to initiate the upload could fail due to a very large data set coming from the widget

NAB - General: For fields transformed to a dropdown, added a minimum width for the list to be set, with the default minimum width set to 70 (per forum post)

NAB - General: Corrected issue where a field transformed into a dropdown grid would not work properly when inside a popup window or was associated with a grid containing a locked column

NAB - General: Corrected issue where a field transformed into a dropdown grid would throw an SQL error if the value field was derived from a calculated column (per forum post)

NAB - General: Adjusted appbar title rendering such that if the title value includes a line break (<br&gt) it will be segregated into a bolded title and smaller-sized subtitle

NAB - General: Added the ability to rename a section and allow section names to have a maximum length of 20 characters, up from the previous limit of 10 (per forum post)

NAB - General: Added support for surrogate characters (i.e., emojis) in Valence.util.Helper.encodeUTF16

NAB - General: Adjusted SQL data source Valence Assistant file definitions window to be closable (per forum post)

NAB - General: Corrected issue with app-wide slim/ultra slim UI setting where it would be ignored on top toolbar if no appbar title was assigned

NAB - General: Corrected issue on section-level events (show/hide) where the events would not be re-added upon editing behaviors when the section names were similar. For example, in a case where there was a section named "Contracts" and another named "Contract", the "Contract" events were being lost.

NAB - General: Corrected issue where some widget link properties were not working correctly when using the "Invert / Not / !" functionality

RPG Toolkit - vvUtility: Adjusted getObjectList procedure to address a CPF22F9 issue that became a problem with the latest IBM i cumulative PTFs released for 7.4 and 7.5. This issue can cause MSGW conditions in Spool File Viewer, legacy Excel downloads made through NAB or vvOut, numerous iAdmin functions and various other areas.

RPG Toolkit - vvUtility: Made adjustments to vvUtility_encodeUTF16 to improve performance when working with graphic (double byte) fields

Portal Admin - Settings: Corrected issue where removing the visibility of a component (e.g., by unchecking Autocode) would not disable edit checks on the formerly visible fields associated with that component

Portal: Added a search field in the environment selection window (per forum post)

Portal: Corrected issue where local cookie policy could cause a terminated Valence session to remain showing as active after user closed browser tab

New Features and Fixes in Valence 6.3.20250325:
Nitro App Builder (NAB) - Edit Grids: When using local data, adjusted rendering logic so that when a value is changed for any given cell it will now show a small red ribbon in the top left of the changed cell

NAB - Edit Grids: Corrected issue involving local data where a call to updateRec and/or edit grid validation was being made when it should not be (per forum post)

NAB - Edit Grids: Adjusted Designer so that when a field with regex applied is transformed, the regex is no longer applied

NAB - Edit Grids: Adjusted Icon Column conditions to have access to a new "nabRowHasChanges" flag, which will be set to true when user has made changes to the row (only applies when using local data)

NAB - Edit Grids: When adding a record while using local data, adjusted logic to scroll the record into view before trying to auto-edit it

NAB - Edit Grids: Added ability to link app variables to pull in values of any editable fields that have been transformed into a combo, dropdown, or lookup, as can already be done in a form widget (per forum post)

NAB - Edit Grids: Corrected issue where local data wasn't being properly encoded when a graphic column was changed during cell editing

NAB - Grids: When paging is active, added option for users to change the page size selection in the paging toolbar. When turned on, the toolbar will feature a combo box with available row options (10, 25, 50, 100, 250, 500) so user can change the number of rows at runtime.

NAB - Grids: On legacy Excel downloads, adjusted download button to disable itself until back-end completes the spreadsheet stream to the browser. Also increased the timeout for generating a spreadsheet to 30 minutes.

NAB - Grids: On legacy Excel downloads, adjusted logic to strip HTML markup from the column header (i.e., when a tooltip is added to the column)

NAB - Grids: On legacy Excel downloads, corrected issue where any Japanese characters included in the file name were getting corrupted

NAB - Grids: When grouping, and a grouping column has a color or color rules set for its background color, instead of applying the color to the text the grouped row will now adopt the background color.

NAB - Grids: Adjusted search setup in Designer to omit columns derived from LAG/LEAD SQL functions, as these would throw an SQL error if included in the WHERE clause (per forum post)

NAB - Grids: When checkbox selection is on, adjusted so that the checkbox column can be hidden via the Hidden Columns section in the link widget properties (per forum post)

NAB - Grids: Corrected issue involving checkbox selection where "selectionCount" was incorrect when the checkboxes were conditioned (per forum post)

NAB - Pivot Grids: Corrected issue where Tabular would sometimes show undefined; Also, when applying colors, the "hide zero values" setting was not being applied (per forum post)

NAB - Forms: For time fields, added the ability to change the default increment (formerly 15 minutes)

NAB - Forms: Corrected issue where a form could say it's invalid when it's not

NAB - Forms: Corrected issue where a negative sign could not be keyed into numeric fields

NAB - Forms: Corrected issue where an app variable link used to indicate form is in error and disable a button was not working correctly

NAB - Forms: Added a "Maximum Value" linked app variable, complementing the "Minimum Value" that already existed

NAB - Forms: Added new "Suspend Change" and "Suspend Blur" properties for helper programs being called when a field is changed or blurred. Now you can suspend the call for changes or blur on specific form fields by setting the corresponding property to true.

NAB - Tiles: Added UI option to horizontally align items left, center, or right. Default is center.

NAB - Data Sources: Added support for TRY_CAST (per forum post)

NAB - Data Sources: Corrected issue where a yuge number of vvIn_virtual clauses could cause the SQL statement to be truncated

NAB - Data Sources: Corrected issue that was causing remoteDB/Postgres connections to not retrieve metadata properly

NAB - Behaviors: Adjusted SetAppVar for numeric values to retain decimal point and precision when applicable. Previously a value of "1.0" would become "1" (per forum post).

NAB - Behaviors: Corrected issue involving buttons where, when using the inverse condition of an app variable to hide, disable, or select a button, you could never remove the inverse condition -- it would not save correctly

NAB - Behaviors: Corrected issue where Execute Script was not able to retrieve the value of an event parameter via getAppVar?

NAB - Popup Windows: Added option to allow the window to be maximizable

NAB - Popup Windows: Adjusted rendering logic such that when a popup's height exceeds the browser window's height, NAB will automatically set the popup's height to match the browser's height

NAB - Spool File Viewer: Corrected an issue where the Spool File Viewer utility widget could be saved without filling in the required app variable links

NAB - Timelines: Added widget properties to set scale, zoomable and scale step (per forum post):
Scale info: Select the time unit for the timeline’s axis. This setting determines the granularity of time intervals displayed (e.g., millisecond, second, minute, hour, weekday, day, month, year).

Scale step info: Defines the number of time units per step on the timeline's axis. For example, a step of 2 on an 'hour' scale equals 2 hours per interval. Must be a positive integer starting at 1. For usability, choose a value that keeps the timeline readable based on the selected scale.

Zoomable info: Enables or disables user-initiated zooming. When enabled, users can adjust the timeline scale using mouse scroll or pinch gestures; when disabled, the timeline remains at a fixed scale.

NAB - Import/Export: Corrected an issue where, under certain rare conditions, listeners could be dropped on the imported app

NAB - Developer Console: Added the ability to click on an app variable to see where it is used

NAB - Git integration: Corrected issue where multi-line commit messages were getting mangled

NAB - General: Adjusted app rendering so when widgets are added to a section on the same row, and all the widgets have a fixed width, horizontal scrolling is activated when needed

NAB - General: Adjusted Designer to only show a "Share" option on apps, not on the underlying widgets, etc.

NAB - General: Adjusted Runner to automatically exit full-screen mode before launching a new app

NAB - General: Corrected issue with numeric fields where adding a second decimal point could cause problems with field validation

NAB - General: Corrected issue where a multi-line app variable expression containing double quotes was triggering a console error (per forum post)

NAB - General: Corrected issue in Designer where using "Create New App" menu function from a widget would result in the app being marked as locked by the user who created it

RPG Toolkit - vvIN_***: Corrected issue where a search for specific query parameters on posts exceeding 32K could fail to find the target

Portal - Login: Added a new exit program option for external login authentication. See source member EXEXITPGML for a sample template.

Portal - General: Adjusted Valence.util.App.isRunning() to accept the name of an app to check for running status, instead of just the app ID or app key (per forum post)

Portal Admin - Settings: Replaced "Show deprecated settings" with new "Active Components" section to determine which additional sections of settings are visible (corrected in .1 build)

Portal Admin - Remote DB: Adjusted the database name to only show for connections that require it, such as Postgres SQL (driver adjusted in .1 build)

Portal Admin - Logs: Adjusted the Apps dropdown to list all apps rather than just the first 25, and adjusted to order by app name

Fusion5250: Adjusted copy/paste functionality to behave more like Access Client Solutions 5250 emulator

Fusion5250: Corrected an issue where fields might not be assigned the correct input or display-only role under special circumstances

Fusion5250: Corrected an issue where pressing Ctrl, Shift or Alt keys could inadvertently delete a character

Fusion5250: Corrected an issue where the "mandatory entry" error message text on a mandatory field was not showing

New Features and Fixes in Valence 6.3.20250207:
(see details below)?

New Features and Fixes in Valence 6.3.20250108.1:
(see details below)

New Features and Fixes in Valence 6.3.20241120:
(see details below)

New Features and Fixes in Valence 6.3.20241025:
(see details below)

New Features and Fixes in Valence 6.3.20240821:
(see details below)

New Features and Fixes in Valence 6.3.20240724:
(see details below)

New Features and Fixes in Valence 6.3.20240627:
(see details below)

New Features and Fixes in 6.3.20240529 since the last version of Valence 6.2:
(see details below)

Last edited by robert.swanson; 08-25-2026, 10:33 AM.
Tags: None
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#2

05-29-2024, 11:51 PM

Valence for IBM i 6.3.20240529 is now released. Go to https://cnxcorp.com/downloads/ to download.

Licensing:

Existing Valence customers will need to obtain a new license key from CNX to use this version. Keys will be provided at no cost for existing licensed systems if current on maintenance. Be sure to obtain a valid Valence 6.3 key prior to installing this version. Email support@cnxcorp.com to obtain a new license key.

The new Valence Assistant AI service introduced in this version is provided by CNX to licensed customers with active maintenance. CNX reserves the right to set reasonable access limits on this service.

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.

Installing This Release:
If you already have an earlier version of Valence 6.X installed, the Valence 6.3 installer will automatically upgrade your Valence 6.X base instance to Valence 6.3 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.3 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.3 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 page. 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 6.3 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.3 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.3 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.

New Features and Fixes in 6.3.20240529 since the last version of Valence 6.2:
Valence - General: Updated UI to better utilize screen space and make data entry fields more prominent

Valence - General: Added Portugese to available language options

Portal Admin - General: Various updates to the visual structure for better readability

Nitro App Builder (NAB): Added new "Valence Assistant" AI functionality to data source creation window and various widgets

NAB - Data sources: added PostgreSQL option for remoteDB

NAB - Pivot grids: Corrected issue where clicking the Save & Exit button from inside the widget was not exiting

NAB - Edit grids: Corrected issue where, on grids with a linked form widget, a form transformed to a lookup could corrupt the form after showing the lookup window

NAB - Forms: In Designer, added ability to search for fields (per forum post)

NAB - Forms (mobile): Corrected issue where we validity change on file upload field was not being

NAB - Forms (mobile): Corrected issue where a form containing field(s) transformed to radio would result in an "on change" helper program call when loading a data source record, which shouldn't happen

NAB - Forms (mobile): Corrected issue where error messages on fields transformed to radio were not displaying the error text properly

NAB - Tiles: Added ability to show special text when empty (per forum post)

NAB - General: Added new setting to Portal Admin > Settings ("Number Fields Align Right"), which when turned on will cause all numeric fields (forms, filters, etc) to be right-aligned

NAB - General: Downloads for legacy Excel now allow for up to a 10-minute timeout instead of relying on the browser's default timeout

NAB - General: Added a delete icon to data sources and widgets that shows when deletable

Nitro IFS Explorer: Added new URL parameters:
title : sets the AppBar title

titleHidden : if equal to true will hide the AppBar

explorerTitle : sets the title on the explorer aka tree

readOnly : if set to true then read only mode is set, thus no deleting of folders/files, updated files, renaming of files etc is permitted; View only however still allowed to download

folder : sets the folder to view instead of the default root

folderText : if specified, overrides the text of the root folder or the folder specified in "folder" above

recentFiles : if set to false then the recentFiles panel will be hidden

Nitro IFS Explorer - Corrected issue where non lower-cased extensions (like "PDF") would trip up the pdf viewer load

VVSYSINFO: New interactive (5250) program that replaces VVANLUSR. Call this program from a command line to terminate sessions, review user setup, or attempt a recovery from foreign key corruption on session records that can be caused by an unexpected power loss to the system

Last edited by richard.milone; 08-15-2024, 01:19 PM.
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#3

06-27-2024, 12:29 PM

Valence Framework 6.3.20240627 is now available. Changes in this build since the previous release are:
Nitro App Builder (NAB) - Grids: On non-legacy Excel downloads, adjusted to display leading zero on any decimal value less than 1 (i.e., "0.12" instead of ".12")

NAB - Grids: Added ability to hide an icon column via an app variable (per forum post)

NAB - Grids: Added two new linked app variable sections:
Cell Click Fire Event: Provides ability to link an app variable to a column, and when that column's cell is clicked, will fire a local event based on the value of the linked app variable

Row Click Set: Provides ability to link app variables to any column in the grid. When a row is clicked, will set those app variables to the value of the selected row field

NAB - Grids: Corrected issue where an app var used to set the download filename would fail to apply any filename changes after first download was performed

NAB - Forms: Corrected issue in 'call RPG program' where disabled date fields were being passed as 0001-01-01 rather then their actual value

NAB - Forms (mobile): Corrected issue where a change made to a DateTime field was not firing the change event (per forum post)

NAB - Forms: Corrected issue where "non-editable field background" was checked and an editable field was set to read-only, the field background was lighter than it should have been

NAB - Forms: Corrected issue where tooltips were not showing on fields when set

NAB - Tiles (Mobile): Corrected issue where mobile UI was always showing one tile per row instead of showing multiple, as desktop mode does (per forum post)

NAB - Utility Widgets: Added functionality to vertical container to allow for resizing widgets. When enabled, you can also allow the widgets to be collapsible (desktop mode only)

NAB - Utility Widgets: Added "set subtitle" functionality to vertical and horizontal containers

NAB - Behaviors: Corrected issue where, in some cases, "Show Section & Save State" would save off the wrong state of the app, causing "Show Previous Section" to go to unexpected section

NAB - Behaviors: Corrected issue where a large amount of actions inside a listener could trigger a console error and prevent an app from launching

NAB - Data Sources: Adjusted vvIn_virtual prompter to allow names containing numbers

NAB - Data Sources: Adjusted SQL formatter to support column names containing "load" (was treating as a reserved word previously)

NAB - Valence Assistant: Added new section in Portal Admin to pass additional custom instructions on every call. For example, "Convert all 8-digit numeric date fields to YYYY-MM-DD format" could be automatically appended to all data source prompts.

NAB - Valence Assistant: Added explicit functionality in forms to assist you with creating a regex

NAB - Valence Assistant: Adjusted the copy/paste functionality to work more reliably; Renamed "Copy & Paste" to "Paste".

NAB - Valence Assistant: Added support for Japanese language requests

NAB - General: Corrected issue where Designer would sometimes allow another developer to edit an app that was already open for editing in another session

NAB - General: Corrected issue where any combo box (drop-down list) containing strictly numeric values could trigger a console error

NAB - General: Corrected issue where widgets meant to be shown could be hidden in apps containing horizontal or vertical containers

RPG Toolkit - vvUtility_getLiteral: Corrected issue where literals were not being returned due to a 6.3-specific change in how language literals are structured (double quotes versus single quotes)

RPG Toolkit - vvOut_initialize: Added logic to set job-level SYSIBM.SELFCODES so SQL exception logging can be activated for a specific instance. This is controlled via a new setting in Portal Admin > Settings > IBM i Settings > SQL SELFCODES.

VVSYSINFO: Added additional instance information and ability to set license key (accessed from a 5250 command line via CALL VVSYSINFO)

Installer: Adjusted to ensure display file object for VVSYSINFO is created if it does not yet exist

Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#4

07-24-2024, 05:20 PM

Valence Framework 6.3.20240724 is now available. Changes in this build since the previous release are:
Nitro App Builder (NAB) - Behaviors: Added a new configuration option when launching app into a URL widget to force a new load of the application even if same app is already open (per forum post)

NAB - Behaviors: Corrected issue where saved event listeners would sometimes not show in the Designer and were not functioning in the running application

NAB - Behaviors: Added support for longer startup actions/scripts

NAB - Forms: Added a new setting to combine all combo box (drop down) loads into a single call, which can improve performance. Activated in Portal Admin > Settings > Hidden Settings (on by default).

NAB - Forms: Adjusted form helper logic so that a change made via an app variable to a non-editable field will now trigger a change event (Desktop only)

NAB - App Variables: App variable expressions now use built-in code editor and now support "return" statements (previously only an expression would work)

NAB - General: Added logic for logging front-end errors into the Errors app

NAB - General: App variables that are set via a back-end program are now automatically structured based on the content -- i.e., true/false are now treated as boolean, strings containing nothing but numbers are now numeric, etc.

NAB - Valence Assistant AI: Corrected issue where Japanese characters were being removed from responses

Portal - Login: Added option to show non-specific login exception messages, activated via a new setting in Portal Admin > Login Method > "Show generic login exception messages"

VVADM_USRS: Added option for calling directly to delete specific Valence users, or to delete all Valence users associated with IBM i profiles that no longer exist

RPG Toolkit - VVOUT: Added support for SQL boolean fields (IBM i 7.5 feature)

RPG Toolkit - VVPDF: The addTable procedure now verifies VVPDF.OBJECT has been properly set, throws an error message if omitted

Fusion5250: Improved support for external USB barcode scanners

Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.

Last edited by robert.swanson; 08-22-2024, 01:29 PM.
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#5

08-21-2024, 06:07 PM

Valence Framework 6.3.20240821 is now available. Changes in this build since the previous release are:
NAB - Grids: Corrected issue where a grid containing locked columns would throw a hard error when browser zoom was set to anything other than 100%

NAB - Grids: Corrected issue where icon columns could not be clicked under certain rare conditions

NAB - Data Sources: Corrected issue in Designer where SQL Valence Assistant popup window was not masking the underlying content, where hitting "Next" would trigger a hard error

NAB - Charts: Adjusted line chart logic so that when no max value is set, widget will automatically make the max value of the chart 1% beyond the range from the actual min & max values (per forum post)

NAB - Charts: For pie charts, if legend is selected to be displayed, pie slices will now show the data value instead of the text label (per forum post)

NAB - Forms: Corrected issue where a field container would still show even after all fields inside the container had become hidden

NAB - Forms (Mobile): Corrected issue where field blur was not calling the helper program as expected

NAB - Forms: Corrected issue where app variables used by a vvIn_virtual clause were not being made available to combo box loads

NAB - Form: Corrected issue where linking an app variable to "get value" was not getting set if it wasn't a field included on the form

NAB - Behaviors: Corrected issue where "Show Previous Section" would not work under certain conditions, typically due to initial Show Section being the callback of an RPG program. Note: must re-save affected app for this fix to be applied.

NAB - Behaviors: Corrected issue in Designer where a menu button was not showing align/position options

NAB - Behaviors: Corrected issue where button text set via an app variable would not change when the app variable value changed (per forum post)

NAB - Behaviors: Corrected issue where a public event would sometimes not notify another NAB application when nested inside another application (per forum post)

NAB - General: App variable expressions can now invoke the Valence Assistant

NAB - General: Corrected an issue where an app variable set to blank would be overridden to "NaN" rather than being left blank

NAB - General: Added option for appbar title position to be specified: left, center, right

NAB - General: Adjusted back-end helper program to not treat a string beginning with a "0" as numeric when setting app variables

NAB - Mobile: Added support for local events

RPG Toolkit - vvOut_execSQLtoJSON: Adjusted count logic to ignore certain SQL warnings, which was causing total count to be incorrect under certain circumstances

Portal - Login: Added ability to paste all two-factor authentication digits into first input field, rather than having to manually type them in

Portal - Login: Corrected issue where sites using non-IBM i login method were still seeing specific "user does not exist" login exceptions, despite having activated new "Show generic login exception messages" setting

Portal - Login: Removed pathVars from initial getSettings call at login

Portal - General: Added ability to enable/disable all Valence Assistant AI features in Portal Admin > Settings > Hidden Settings > "Valence Assistant enabled"

Portal Admin - Remote DBs: Corrected issue where connection parameters for remote DB server were not sticking upon save

Fusion5250: Added functionality so that upon saving a macro, user can override the "value" when the action is "Type", thereby making it possible to change the typed value to be a parameter and not have to manually edit the macro file

Errors App: Added "Error ID" column to main grid

Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#6

10-28-2024, 08:56 AM

Valence Framework 6.3.20241025 is now available. Changes in this build since the previous release are:?
Nitro App Builder - New Beta feature: Added check-in / check-out support in Designer for all NAB objects (data sources, widgets, apps)

Nitro App Builder - New Beta feature: Added Git support in Designer for all NAB objects (data sources, widgets, apps)

NAB - Edit Grids: Corrected issue affecting edit grids linked to forms containing one or more fields transformed to a combo box -- the transformation was being ignored on any fields set to read only or not editable

NAB - Edit Grids: Adjusted numeric input fields to honor the "Comma Decimal Separator" setting, matching format shown when not editing

NAB - Edit Grids: Corrected issue where the Auto-edit property would sometimes not work when set via an app variable, typically when the grid is in a tab container and not in the first tab?

NAB - Tree Grids: Corrected issue where searching by column on date fields would sometimes not work (per forum post)

NAB - Tree Grids: Corrected issue in Designer where under certain scenarios it would render the Selected tab as if it were a Level

NAB - Pivot Grids: Added "Tabular" UI option in Designer (formerly only accessible via the user configuration)

NAB - Grids: Added new linked app variable for pulling in the formatted value of a cell (as opposed to getting the "raw" unformatted value) when row is clicked. Only applies to regular grids and edit grids on cells containing a formatter.

NAB - Grids: Added new "Input Delay" option for global search -- default is 500 ms but can be increased as needed

NAB - Grids: Added new linked app variable for pulling in the value of the global search field

NAB - Grids: Adjusted non-legacy Excel downloads to use the width/flex values set on each grid column, rather than using the underlying data source field sizes

NAB - Grids: Adjusted rendering so that any locked columns containing flex width values will have their flex values removes in order to avoid unexpected display anomalies

NAB - Grids: Adjusted drag and drop logic to temporarily suspend the sort sequence of the grid to ensure the drag and drop action always works as expected?

NAB - Grids: Corrected issue in the custom column formatter where the Valence Assistant would append to the existing source code rather than overwrite it

NAB - Grids: Corrected issue involving use of literals where column container text would show the literal name rather than the literal value

NAB - Grids: Corrected issue in Designer where "Search Locally" option was not available for global search field

NAB - Grids: Corrected issue where a grid containing nested columns (column containers) would sometimes fail to fire a Cell Click event

NAB - Grids: Corrected issue where downloads of grids containing nested columns (column containers) would inadvertently include HTML markup for the corresponding tool tips

NAB - Forms: Added new linked app variable to set the disabled days of the week on date fields. The app variable can be set to "false" to have no disabled days, or any string of text to indicate disabled days (i.e., "0, 1, 2" or "Sunday, Monday, Tuesday" or "Sun, Mon, Tue").

NAB - Forms: Added new week-of-year field to support showing values in format "week number - year" (e.g., "40-2024"). The field will display with a special week-centric date picker in Desktop mode.

NAB - Forms: For fields transformed into a checkboxes, added the ability to align the field label with the checkbox "box label"

NAB - Forms: Adjusted numeric input fields to honor the "Comma Decimal Separator" setting, matching format shown when not editing

NAB - Forms: Corrected issue where, on forms that had not yet been loaded, values could not be properly retrieved from disabled fields when set via app variables

NAB - Forms: Corrected issue where a field set was not automatically being hidden when all fields within it become hidden (per forum post)

NAB - Forms: Corrected issue where a Runtime only license would incorrectly cause an "Enterprise License Required" error message to appear when opening a form with multiple combo boxes

NAB - Forms: Corrected issue where forms containing multiple combo boxes would throw a licensing error if a Valence Runtime-Only license was in use

NAB - Forms (Mobile): Added validation to character and J-type fields to ensure no non-double-byte characters are included

NAB - Forms (Mobile): Corrected issue where a field set to upper case when using the Japanese keyboard could cause typed values to not be applied correctly

NAB - Charts: Corrected issue where super small values in Bar and Column charts would show initially, but then stop showing once the chart was refreshed or resized

NAB - KPIs: Improved rendering on progress bar UI

NAB - Containers: Added ability to set border width, radius and title alignment in horizontal and vertical containers; Horizontal containers now include a title field, matching vertical containers

NAB - Filters: On multi-select combo boxes, corrected issue where deliberately blank values were not being included in the SQL where clause

NAB - Filters: Corrected issue in Designer where "Overlay" option was not working properly

NAB - Filters: Corrected issue where a hard error could occur when attempting to set filter values via linked app variables

NAB - Filters: Corrected issue where contains and starts-with type filters were not escaping special characters (per forum post)

NAB - Filters: Corrected issue where a filtered data source the filter program would not be called when only a vvIn_Virtual filter field was changed (per forum post).

NAB - Filters: Corrected issue where a vvIn_Virtual set to a blank space could result in a MSGW condition

NAB - Import: Added logic to check for a corrupt or empty save file prior to attempting import

NAB - Import: Corrected issue where a direct export of an app to another instance for the first time could result in the imported app not receiving the proper default Group specified in Portal Admin > Settings for that instance

NAB - Export: Corrected issue where a direct export to another instance could circumvent restriction that normally prevents importing NAB objects from a newer build to an instance running an older build

NAB - Data Sources: Designer will now prompt user to confirm that they want to exit and discard changes when back arrow is hit without first hitting Save while inside SQL statement editor

NAB - Data Sources: Added support to the SQL parser logic to support CTE clauses with local table definitions (per forum post)

NAB - Data Sources: Added support for "ESCAPE" keyword to set custom escape characters

NAB - Tab Container: Corrected issue in Designer where, under certain conditions, moving a widget within a section that contains a tab container would cause the widget to not move correctly

NAB - Tile Widgets: Added option to hide empty text (per forum post)

NAB - Charts (Bar/Column): added new option to suppress zero values

NAB - App Variable Expressions: Corrected issue where an expression that concludes with an explicit return of a boolean "false" value could result in a console error (per forum post)

NAB - Info Utility Widget: Added Valence Assistant AI support

NAB - Exit Programs: Adjusted dialog UI such that when the backend sets 'msg' or the nabMsg app variable to match the "Prompt User With Confirmation Text" dialog via RPG call (per forum post)

NAB - Exit Programs: Added a second general purpose input parameter to VVNABBTN ("gMisc" - 2048 alpha) so program can be called directly from other RPG programs with structured input values if needed

NAB - General: Added new global app variable nabPlaySound which can be set to "chime" or "error" to play a corresponding sound

NAB - General: In Designer, separated the app variables section into three sections: "App" (for all custom app variables), "Features" for feature-controlling app variables and "NAB" for universal action variables such as nabAppMsg

NAB - General: In Designer, all app navigation is now breadcrumb-based for better clarity

NAB - General: Corrected issue where a pop up window containing an autoload widget with a filter could result in two back-end calls occurring when only one was needed -- one call for the autoload, then another call for the filter (per forum post)

NAB - General: Corrected issue where app variables would not always handle literals properly, showing the literal name rather than the literal value

NAB - General: Corrected issue where Designer could not properly load an older NAB app containing tabs

NAB - General: Corrected issue in Designer where the "Launch" menu option was showing on items other than applications (i.e., widgets)

NAB - General: Corrected issue where the initial load of a widget would sometimes not show the expected load mask

NAB - General: Corrected issue where, under certain obscure scenarios, the setting of an app variable would fail to "stick" (per forum post)

NAB - General: Corrected issue in Designer where border width and radius would reset to default after being adjusted (per forum post)

File Editor: Main grid will now show true content of underlying rows rather than treating values as potential HTML, so concurrent spaces in a field are no longer truncated into single spaces

Portal Admin - Assistant: Added edit controls (maintained in Settings > Portal Administration > Groups Authorized to Administration Functions)

Portal Admin - Users: Corrected issue where sort order would be lost after saving a user record

Portal Admin - Apps: Added validation to the Optional Parameters to ensure proper URL formatting

Portal Admin - Apps/Environments: Corrected issue where "Translation" tab did not have a "Description" column

Instance Manager: Corrected issue where the Note field was not properly handling double-byte characters (Japanese only)

Fusion5250: Corrected rare issue where a new screen would not fully clear fields from the previous screen

Fusion5250: Corrected issue where sometimes a partial screen clear instruction would be interpreted as a full screen clear, resulting in a blank screen

RPG Toolkit - vvOut_execSQLtoCSV: Added "omitCsvHeader" to the VVOUT data structure which, when set to '1', will result in the .csv file having no header row

RPG Toolkit - vvUtility_getValenceSetting: The Valence Setting formerly named BASE_LIB has been renamed to INSTANCE_LIB for better clarity. For backward compatibility, a call to this procedure passing BASE_LIB will return the value of INSTANCE_LIB

Installer: Corrected issue where recently added VVDFTMBR field in file VVENVS was not being assigned the correct CCSID

Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.?
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#7

11-20-2024, 04:38 PM

Valence Framework 6.3.20241120 is now available. Changes in this build since the previous release are:
NAB - Grids: Added new link property to focus on the search field when grid searching is turned on

NAB - Grids: Added a new link property to set a column's width/flex, allowing for changing the original width/flex defined on the widget when running in an app (not available on pivot grids)

NAB - Grids: Added minimum width option for columns using flex width

NAB - Grids: Added option to override the default left and right margins of a PDF download. Default is 32.

NAB - Edit Grids: Added support for adding new rows inline when using local data and in-line editing, instead of displaying a dialog window

NAB - Edit Grids: Added new linked properties "isInvalid" and "highlightError" for use when local data and inline editing (cell/row) are active, matching functionality already available to Forms

NAB - Edit Grids: Added validation types and regex to editable columns, matching form widget functionality

NAB - Edit Grids: Added ability for the backend to add new rows to the grid when using local data via new procedure: AddRow(fieldNameArray:fieldValueArray)

NAB - Edit Grids: Corrected issue where the "add" button associated with a feature would sometimes would not get disabled when feature was turned off

NAB - Edit Grids: Corrected issue a hard error could occur when where a grid with inline cell editing inside a tab container had its edit feature turned off

NAB - Edit Grids: On columns transformed to a lookup, added ability to set the display value to another column on the grid when the user makes a selection?

NAB - Pivot Grids: Added borders to the column headers (per forum request)

NAB - Forms: Adjusted logic so that when focus is moved to a Rich Text Editor component via an app variable, the cursor is now placed at the start of the first line in the editor

NAB - Forms: Added ability to specify height configuration for Rich Text Editor fields, similar to text areas

NAB - Forms: Added "After Text" feature for editable fields that are not transformed into checkboxes or radio buttons. This allows text to be placed directly after the field, similar to functionality available in grid column renderers. Also added app variable links to change and hide the text.

NAB - Forms: Adjusted so that when a form is reset, its onValidityChange method will be called so when an app variable is linked to isInvalid, it will get set accordingly

NAB - Forms: Adjusted so that when setting a field in error from the back-end, if the field isn't found, then attempt to find the field via alias_fieldname

NAB - Forms: Adjusted logic so text areas set via backend template or app variable change no longer escapes carriage return /n as //n (per forum post)

NAB - Forms: Adjusted radio button logic so that when setting them, a character '1' and numeric 1 are treated the same

NAB - Forms: Corrected issue where, under some conditions, forms containing a rich text editor were not setting the component size correctly

NAB - Forms: Corrected issue where the ReadOnly-All app link would not function correctly when inside a tab container

NAB - Forms: Corrected issue where fields set as Rich Text Editors would sometimes not have their readonly property enabled correctly

NAB - Forms: Corrected issue where defined reset values on radio buttons weren't being applied when the field was reset

NAB - Utility Widgets: Adjusted to check for features (on/off) on any buttons contained within the widget

NAB - App Variables: Added 'nabCurrentYear' system app variable that stores the current year. This variable functions similarly to 'nabCurrentDate' but is specifically designed to hold only the year value.?

NAB - App Variables: Added new checkbox column in Designer/App Variable list to omit passing app variable to backend regardless of value

NAB - App Variables: Adjusted logic so that when app variables are set from the backend in the format of an array or object, it will be treated as a true JavaScript object/array on the frontend

NAB - Behaviors: "Call RPG Program" now supports the use of an app variable for the program name. Place the app variable inside [hard brackets] to activate.

NAB - Behaviors: "Call RPG program" confirmation text will now replace any app variables in the text wrapped in hard brackets. For example: "Are you sure you want to delete: '[itemDescription]'?"

NAB - Behaviors: Adjusted Designer so you can now search within Behaviors (app variables, RPG program names, feature IDs, button text, etc.)

NAB - General: Added ability to set a fixed width on a widget even when it's the only widget in the section

NAB - General: For any field transformed to a lookup, adjusted so the down arrow will now display the lookup grid widget, similar to clicking the magnifier icon in the field

NAB - General: Adjusted so that when an app is locked and in view-only mode, the Designer will still display the behaviors/app vars buttons (per forum post)

NAB - Mobile: Corrected issue where, under certain rare conditions, main section widgets would not be displayed

NAB - Export: Corrected issue where data sources associated with drop-downs inside a "Prompt for more info" window (ie, in conjunction with a call to an RPG program) were not being included on an app export

NAB - Exit Programs (VVNABBTN): For Edit Grids using row-level edits over local data, added support for highlighting cells with errors from backend responses via a new "cellError" property (desktop only)

NAB - Exit Programs (VVNABBTN): For Edit Grids using local data, added new procedures RowAdded and RowChanged which, when called with a row index, return *ON if the row was added or changed, respectively

NAB - Exit Programs (VVNABBTN): For Edit Grids using local data, added new procedures GetRemovedBool/Char/Num/Null to return column values of removed rows for a particular row index (GetRemovedNull will return *ON if the removed column value was set to null)

NAB - Exit Programs (VVNABBTN): For Edit Grids using local data, added global variables gRemovedCnt and gChangedCnt which hold the number of records removed or changed respectively

NAB - Git integration: Added a new "Git Difference" menu option to show all pending (not yet committed) changes on a checked out component

NAB - Git integration: Added "sanitize" logic to commit messages to omit any invalid characters included in the text

Portal - Valence Toolkit: Added ability to override color and icon when launching an app via Valence.util.App.launch

Portal Admin - Groups: Adjusted to prohibit removal of core group IDs to avoid problems when applying updates containing new apps. These groups can be disabled, but not deleted.

Portal Admin - Apps: Added a dedicated "Fusion5250" app type with a combo box to select any applicable macro

Portal Admin - Apps: Corrected an issue where certain conditions could cause an error to occur when saving an app

Portal Admin - Settings: Added a new external call option to VVADM_SETS to refresh the current license status in VVSETTINGS

Portal - General: Added ability to resize apps while in Portal "split view" mode

Portal - General: Adjusted VVUSERS2 index to be unique over VVLOGINID

Portal - General: Adjusted instance installer/updater to add Postgres to Java Classpath setting

Instance Manager: Added ability to delete an instance via direct call to VVINSTMGR, action='deleteInstance'

?Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#8

01-08-2025, 09:35 PM

Valence Framework 6.3.20250108 is now available. Changes in this build since the previous release are:
Nitro App Builder - New feature: Introducing the NAB Developer Console which can be opened while running an app to monitor app variables in real-time and see NAB-specific console information.

NAB - Grids: Adjusted PDF download logic so, on column headers containing line breaks (<br>), the header length is now determined by the longest line between breaks

NAB - Grids: Adjusted Excel download so that when determining column width it will now honor any explicit column pixel widths set on the grid, rather than assuming a flex value of 1

NAB - Grids: Adjusted "Allow copy of data" grid config so that, when checked, a document-copy icon appears below the grid. When clicked, the grid is copied into the clipboard and can then be pasted elsewhere (i.e., into Excel)

NAB - Grids: Corrected lookup issue on grids containing an expandable row body, where clicking on the expander would result in the record being auto-selected and the lookup being closed

NAB - Grids/Edit Grids: Adjusted rendering such that whenever a cell contains overflow "ellipsis" (...) because the cell is not wide enough to show all the content, then show a tooltip with the full content will appear whenever the user hovers over the truncated cell. Can be disabled by checking the "Disable tooltips for overflowing cell content" setting at the widget label.

NAB - Grids/Edit Grids: Added option for the global search to be placed on the left edge of the toolbar (previously was always placed on the right)

NAB - Grids/Edit Grids: Added option to set row click action to require a double click (previously was always a single click)

NAB - Edit Grids: Added a new back-end procedure for grids using local data with checkbox selections called "rowSelected", to which the row index is passed. Returns *on if specified row is selected.

NAB - Edit Grids: Added ability to set a minimum value on editable numeric fields

NAB - Edit Grids: Corrected issue where showing or hiding the Add/Copy/Delete buttons based on a feature ID would sometimes not function properly

NAB - Edit Grids: Corrected issue on edit grids with checkbox selections activated where selected row count app variable "checkboxSelCount" was not being set properly -- was only working on regular grids

NAB - App Variables: Added new "nabSetAllDateFormats" that will auto-set the date format for any fields that are not explicitly set to a date renderer. Otherwise date fields without renderers defer to the global date format set in Portal Admin > Settings.

NAB - App Variables: Added new "nabSetAllDecimalSeparators" that will override the decimal separator on all grid columns and form fields that have a numeric renderer with decimal separators applied. Can be set to a period or comma.

NAB - App Variables: Added new NAB variables "nabCurrentMonth" and "nabCurrentDay"

NAB - App Variables: Added new linked app variable "deleteConfirmMsg" to edit grids to allow record deletion confirmation message to be overridden

NAB - App Variables: Added new linked app variable for grids columns and form fields to override all before/after text specified within the widget

NAB - App Variables: Added new linked app variable "Reset Filter Value" to set the value of filters when reset button is clicked

NAB - App Variables: Added new linked app variable "hasChanged" to forms and edit grids using local data. This variable will be set to true whenever a field within the widget has been changed. App variable reverts back to false when form has been reloaded.

NAB - App Variables: For grids, added new linked app variable section "Selected Row Set" to set field values based on the currently selected record

NAB - Filters: Added ability to mark any filter field as required, so user cannot load data until all required filters have a value specified

NAB - Filters: Added ability to add a tooltip to filter fields

NAB - Filters: Added ability to specify an overflow menu for filter toolbars. When "Enable Overflow Menu" is checked in the filter configuration, filters that would otherwise require horizontal scrolling to access will become accessible via a menu button in the toolbar

NAB - Forms and Filters: Added new linked app variable category ("Lookup Additional Filter") wherein a lookup field's data source can have a WHERE clause appended based on the value of the specified app variable

NAB - Form: Added a "Time Picker" that will automatically appear when editing time fields

NAB - Forms: Adjusted to ensure read-only fields are not focusable, similar to disabled fields

NAB - Forms: Corrected issue where adding a button or after-text to a form field would sometimes fail

NAB - Forms: Corrected issue where radio buttons on a form linked to an edit grid would not function properly (per forum post)

NAB - Forms: Corrected issue where fields given a different font size (extra small, small, large, extra large) were not honoring the font size when placed in read-only mode via an app variable and/or form helper call

NAB - Forms: Corrected issue where under certain conditions the "clear" icon inside a filled-in field was not being removed properly

NAB - Lookup: Corrected issue where a read-only field that is transformed into a lookup could cause an error under certain circumstances

NAB - Behaviors: Added option for icon columns and row menus to be available via a right-click on the row

NAB - Behaviors: Corrected issue where the tooltip included on a button would be discarded once the button was disabled (per forum post)

NAB - Behaviors: Corrected issue where button text overridden via a linked app variable would sometimes not function properly (per forum post)

NAB - Data Sources: Added support for the EXTRACT function -- i.e., EXTRACT(YEAR FROM CURRENT_DATE)

NAB - Data Sources: Corrected issue where specifying the long SQL table name would omit columns for filter selection, etc.

NAB - Data Sources: Corrected issue where vvIn_Virtual would not function properly if default value contained and end parenthesis

NAB - General: Added a new option for the AppBar title to have any right-aligned buttons on the AppBar to be positioned directly after the title, instead of at the far right of the AppBar, which is the default. The AppBar title must be left-aligned, and the app must have at least one aligned-right button on the AppBar for this option to appear.

NAB - General: Corrected issue where a URL widget that launches another nested app was not signaling to the portal that the "children" apps were closed when the "parent" was closed, so Active Sessions would incorrectly show the user was still running the children apps

NAB - Import/Export: Adjusted logic so that the "last maintained by" user and timestamp will now be applied to app/widget/data source records when exporting to an instance in which the object had previously been exported (per forum post)

Fusion 5250: Added ability to specify a default keymap through the Hook.js

Fusion 5250: Corrected issue where a paste into a field could become truncated under certain conditions

Portal Admin > Users: Added ability to mass-create Valence users from IBM i users that don't yet have Valence profiles

Portal Admin > Users: Adjusted global search to include first name, last name, description and email address (previously search was limited to user ID)

Portal Admin > Settings: Added new "Show Developer Console for Admins" setting which, when checked, will allow anyone with access to the Portal Admin app to launch the NAB Developer Console from the Portal

Instance Manager: Added an explanatory tooltip and empty text to the "Node port" field, and adjusted so it is no longer required

Instance Manager: Adjusted instance update logic to be more fault-tolerant of locked objects when creating save file of origin instance

??Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.?
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#9

02-07-2025, 04:38 PM

Valence Framework 6.3.20250207 is now available. Changes in this build since the previous release are:?
NAB - Grids: Added new "Search Only on Enter" configuration checkbox for global search - when checked, the search will be executed only when Enter key is pressed (previously the search would execute whenever there was a pause in keystrokes within the search field)

NAB - Grids: Adjusted manner in which icon columns are displayed such that whenever any icons are hidden, the remaining visible icons will still align vertically from row to row

NAB - Edit Grids: Added ability to specify a minimum value on fields transformed into combo/lookup

NAB - Edit Grids: Adjusted cell & row rendering so that the editor doesn't show 0001-0-01 dates (shows as blank instead)

NAB - Edit Grids: Added a new "IsInForm" procedure for EXNABVAL-based exit/helper programs

NAB - Grids & Forms: Added a new "Ultra Slim View" UI configuration for cramming in more rows and columns

NAB - Grids & Forms: Added a new linked app variable to override the position of the before/after text at runtime (i.e., change 'before' to 'after')

NAB - Filters, Forms, Edit Grids: Added a new "dropdown grid" as an option for "transform to"

NAB - Forms: Added ability to show tool tips on non-editable fields (previously only applied to editable fields)

NAB - Forms: Corrected issue in Designer where, after going into the formatting of an editable field, clicking the OK button would not dismiss the window

NAB - Forms: Corrected issue in form helper exit program (EXNABFHLP) where the form would sometimes send down an action of "change" when it should have been "blur" (per forum post)

NAB - Filters: Added new "Align left" checkbox for filters set to show in toolbar. Does not apply to grids with generic search activated.

NAB - Behaviors: Adjusted "Prompt for more info" on RPG program call to right-align the text on checkboxes (per forum post)

NAB - Behaviors: Corrected an issue in "call RPG program" where, if the called program failed, the NAB app would encounter a hard error as well

NAB - Behaviors: Corrected issue where child buttons of a menu button were not properly translating to a literal when specified

NAB - Tiles: Added ability to get the `totalCount` via an app variable, similar to grids?

NAB - Dev Console: Multiple aesthetic and functional updates for this new tool

NAB - Export/Import: Corrected issue where after performing an import, the CGI job could subsequently be pulling Valence Settings from an incorrect instance

NAB - App Variables: Adjusted logic to treat any app variable starting with a plus sign (+) and followed by numbers to be treated as a string rather than as a number

NAB - Filters: Added new "removeFilter" procedure to the filter helper/exit program

NAB - Timeline Widget: Corrected issue where grouping a timeline could trigger an error in the app

NAB - Checkout Manager: Added ability to reassign the checked-out user (per forum post)

NAB - Check In/Out related changes:
If user selects the "Launch" or "Share" option against an application, it will now prompt the user to share/launch the "checked out" version or the "current version" of the application

When clicking a checked out ds/widget/app by someone other than yourself, you will now be prompted to view the "checked out" version or the "current version" of the ds/widget/app?

NAB - General: Applied various aesthetic and UI adjustments to NAB Designer:
Left edge tab panel narrowed, leveraging tool tips in favor of text for better use of screen real estate

Floating buttons in lower right of main NAB object grid have been replaced with static buttons in bottom toolbar

Popup windows that cannot fit within the bottom toolbar are now listed via a menu button on the right edge of the toolbar (previously required horizontal scrolling to view)

Link button within a widget now opens a refined "Link Widget Properties" window (formerly entitled "Link to App Variables"), which includes a new general search/filter field for property names and values

NAB - General: Link Widget Properties now allows entry of hard-coded values (previously had to be app variables), and for boolean fields you can now indicate the inverse should apply (so when checked, true means false and false means true)

NAB - General: Added an app-level UI configuration, similar to the options available to grids (default, slim, ultra slim). This will supersede widget UI configurations unless specified.?

NAB - General: Adjusted all combo boxes so that when focus is received, the content is automatically selected (previously would just place the cursor at the end of the value)

NAB - General: Corrected issue in the Designer app list where double byte characters in the app name were not showing properly

NAB - General: Corrected a loophole in Designer where a widget name could receive invalid characters when pasted in versus typed

NAB - General: Corrected issue where a toolbar menu overflow was occasionally causing the app or Designer to crash?

NAB - Git: Adjusted to encode all commit messages for double byte character language support. NOTE: If you are currently using this Git feature with NAB, you must restart your Node server.

Portal Admin - Users: Adjusted search to include the numeric user ID column

Portal Admin - Users & Apps: Adjusted search to support double byte characters

Portal Admin - Remote DB: Added "Database Name" field, required for Postgres connections

?Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.?
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#10

03-26-2025, 09:11 PM

Valence Framework 6.3.20250325 is now available. Changes in this build since the previous release are:?
NAB - Edit Grids: When using local data, adjusted rendering logic so that when a value is changed for any given cell it will now show a small red ribbon in the top left of the changed cell

NAB - Edit Grids: Corrected issue involving local data where a call to updateRec and/or edit grid validation was being made when it should not be (per forum post)

NAB - Edit Grids: Adjusted Designer so that when a field with regex applied is transformed, the regex is no longer applied

NAB - Edit Grids: Adjusted Icon Column conditions to have access to a new "nabRowHasChanges" flag, which will be set to true when user has made changes to the row (only applies when using local data)

NAB - Edit Grids: When adding a record while using local data, adjusted logic to scroll the record into view before trying to auto-edit it

NAB - Edit Grids: Corrected issue where local data wasn't being properly encoded when a graphic column was changed during cell editing

NAB - Grids: When paging is active, added option for users to change the page size selection in the paging toolbar. When turned on, the toolbar will feature a combo box with available row options (10, 25, 50, 100, 250, 500) so user can change the number of rows at runtime.

NAB - Grids: On legacy Excel downloads, adjusted download button to disable itself until back-end completes the spreadsheet stream to the browser. Also increased the timeout for generating a spreadsheet to 30 minutes.

NAB - Grids: On legacy Excel downloads, adjusted logic to strip HTML markup from the column header (i.e., when a tooltip is added to the column)

NAB - Grids: On legacy Excel downloads, corrected issue where any Japanese characters included in the file name were getting corrupted

NAB - Grids: Adjusted search setup in Designer to omit columns derived from LAG/LEAD SQL functions, as these would throw an SQL error if included in the WHERE clause (per forum post)

NAB - Grids: When checkbox selection is on, adjusted so that the checkbox column can be hidden via the Hidden Columns section in the link widget properties (per forum post)

NAB - Grids: Corrected issue involving checkbox selection where "selectionCount" was incorrect when the checkboxes were conditioned (per forum post)

NAB - Pivot Grids: Corrected issue where Tabular would sometimes show undefined; Also, when applying colors, the "hide zero values" setting was not being applied (per forum post)?

NAB - Forms: For time fields, added the ability to change the default increment (formerly 15 minutes)

NAB - Forms: Corrected issue where a form could say it's invalid when it's not

NAB - Forms: Corrected issue where a negative sign could not be keyed into numeric fields

NAB - Forms: Corrected issue where an app variable link used to indicate form is in error and disable a button was not working correctly

NAB - Forms: Added a "Maximum Value" linked app variable, complementing the "Minimum Value" that already existed

NAB - Forms: Added new "Suspend Change" and "Suspend Blur" properties for helper programs being called when a field is changed or blurred. Now you can suspend the call for changes or blur on specific form fields by setting the corresponding property to true.

NAB - Data Sources: Added support for TRY_CAST (per forum post)

NAB - Data Sources: Corrected issue where a yuge number of vvIn_virtual clauses could cause the SQL statement to be truncated

NAB - Data Sources: Corrected issue that was causing remoteDB/Postgres connections to not retrieve metadata properly

NAB - Behaviors: Adjusted SetAppVar for numeric values to retain decimal point and precision when applicable. Previously a value of "1.0" would become "1" (per forum post).

NAB - Behaviors: Corrected issue involving buttons where, when using the inverse condition of an app variable to hide, disable, or select a button, you could never remove the inverse condition -- it would not save correctly

NAB - Behaviors: Corrected issue where Execute Script was not able to retrieve the value of an event parameter via getAppVar?

NAB - Spool File Viewer: Corrected an issue where the Spool File Viewer utility widget could be saved without filling in the required app variable links

NAB - Timelines: Added widget properties to set scale, zoomable and scale step (per forum post):
Scale info: Select the time unit for the timeline’s axis. This setting determines the granularity of time intervals displayed (e.g., millisecond, second, minute, hour, weekday, day, month, year).

Scale step info: Defines the number of time units per step on the timeline's axis. For example, a step of 2 on an 'hour' scale equals 2 hours per interval. Must be a positive integer starting at 1. For usability, choose a value that keeps the timeline readable based on the selected scale.

Zoomable info: Enables or disables user-initiated zooming. When enabled, users can adjust the timeline scale using mouse scroll or pinch gestures; when disabled, the timeline remains at a fixed scale.?

NAB - Import/Export: Corrected an issue where, under certain rare conditions, listeners could be dropped on the imported app

NAB - Developer Console: Added the ability to click on an app variable to see where it is used

NAB - Git integration: Corrected issue where multi-line commit messages were getting mangled

NAB - General: Adjusted app rendering so when widgets are added to a section on the same row, and all the widgets have a fixed width, horizontal scrolling is activated when needed

NAB - General: Adjusted Designer to only show a "Share" option on apps, not on the underlying widgets, etc.

NAB - General: Corrected issue with numeric fields where adding a second decimal point could cause problems with field validation

NAB - General: Corrected issue where a multi-line app variable expression containing double quotes was triggering a console error (per forum post)

NAB - General: Corrected issue in Designer where using "Create New App" menu function from a widget would result in the app being marked as locked by the user who created it

RPG Toolkit - vvIN_***: Corrected issue where a search for specific query parameters on posts exceeding 32K could fail to find the target

Portal - Login: Added a new exit program option for external login authentication. See source member EXEXITPGML for a sample template.

Portal - General: Adjusted Valence.util.App.isRunning() to accept the name of an app to check for running status, instead of just the app ID or app key (per forum post)?

Portal Admin - Settings: Replaced "Show deprecated settings" with new "Active Components" section to determine which additional sections of settings are visible (corrected in .1 build)

Portal Admin - Remote DB: Adjusted the database name to only show for connections that require it, such as Postgres SQL (driver adjusted in .1 build)

Portal Admin - Logs: Adjusted the Apps dropdown to list all apps rather than just the first 25, and adjusted to order by app name

Fusion5250: Adjusted copy/paste functionality to behave more like Access Client Solutions 5250 emulator

Fusion5250: Corrected an issue where fields might not be assigned the correct input or display-only role under special circumstances

Fusion5250: Corrected an issue where pressing Ctrl, Shift or Alt keys could inadvertently delete a character

Fusion5250: Corrected an issue where the "mandatory entry" error message text on a mandatory field was not showing

?Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.??
?
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#11

05-16-2025, 12:18 PM

Valence Framework 6.3.20250516 is now available. Changes in this build since the previous release are:?
Nitro App Builder (NAB) - Grids: Adjusted PDF download logic to accommodate flex widths on columns

NAB - Grids: Adjusted rendering so that any buttons added to the top or bottom of the widget will be consolidated with download buttons (when not paging) and global search field (if activated).

NAB - Grids: Added a new widget property to optionally hide the 'copy data' button

NAB - Grids: Added ability to use setBackgroundColor and setTextColor when using custom formatting for a summary column (per forum post)

NAB - Grids: For grids with global search activated, a new Link Widget Property called searchClause has been added under General. If this property is linked to an app variable, the grid widget will not apply the search SQL clause and will instead set the app variable with the search clause, in which case the app variable would typically be applied in a vvIn_Virtual within the WHERE clause of the main SQL statement. Additionally, a new section within the Link Widget Properties, called "Search Clause," will list all fields in the data source, allowing you to override the field name used in the search clause.

NAB - Grids: Adjusted global search field to be case-agnostic on character columns when the underlying data source is using hex sort sequence

NAB - Grids: Added checkbox in Designer to indicate the global search field should span the entire width of the grid

NAB - Grids: Adjusted local search functionality to be case-insensitve

NAB - Grids: Corrected issue where the global search was not being properly set by a linked app variable

NAB - Grids: Corrected issue where state (column order, size, hidden state, etc) could get mangled when columns are locked

NAB - Grids: Corrected issue where a global search field set to only execute when Enter is pressed would fail to process when the value was changed or cleared via an app variable

NAB - Grids: Corrected issue where numeric columns on legacy Excel downloads were not being formatted properly; Also improved default column width calculation, which is invoked whenever an explicit column width has not been specified.

NAB - Grids: Corrected issue in non-legacy Excel downloads where checking the "Exclude headers" option would cause a hard error

NAB - Grids: Corrected issue where under certain conditions the Row Select app variable link would not work with a right click against a grid row (per forum post)

NAB - Edit Grids: Added user page size selection option, matching functionality added for regular grids in the prior build

NAB - Edit Grids: For row editing, adjusted so that the attached row/form helper program will now make initial call using gMode as "formRender" instead of "rowRender"; It will now also call the helper program each time a field is changed (per forum post)

NAB - Edit Grids: Adjusted logic to support regular expressions in non-inline edit grids (previously only applied to edit grids using inline editing)

NAB - Edit Grids: Corrected issue where a field transformed into a radio button was not displaying correctly during editing

NAB - Edit Grids: Corrected issue in cell-level edits where color rules would not be reapplied as expected after the cell value was changed

NAB - Edit Grids: Corrected issue in cell-level edits transformed into a lookup where the value on a subsequent row could change in error to the prior row's value when the display value and lookup value were identical

NAB - Edit Grids: Corrected issue with local data where, if a field was graphic, it would not decode the value in some situations, causing the typed value to become the encoded value

NAB - Tree Grids: Corrected issue where an icon column sometimes wouldn’t show on certain levels

NAB - Tree Grids: Corrected issue where selected rows could become unselected when the parent row is collapsed (per forum post)

NAB - Tree Grids: Corrected issue in Designer where removing a column container could cause a hard error when rebuilding the selected columns / tree grid columns (per forum post)

NAB - Forms: Adjusted maximum value logic to throw an error message rather than override the form field value to the maximum when exceeded

NAB - Forms: Adjusted rendering for text areas to increase line spacing when the field font size is large or extra-large (per forum post)

NAB - Forms: Corrected issue where, on PCs running Windows, multiple fields with an input format could compete for focus, causing an unwanted blinking effect (per forum post)

NAB - Forms: Corrected issue where field values linked to app variables were not being updated as expected when the field value was blank or zero

NAB - Forms: Corrected issue on mobile where the non-editable background color property was not being applied as expected

NAB - Forms: Corrected issue on mobile where a button placed next to a field was not aligning with the field

NAB - Maps: Adjusted map widget logic to support functional changes recently introduced by Google

NAB - Filters: Adjusted logic for initial values on checkbox-based filters to support the unchecked state as well as the checked state. For example, previously an unchecked box could be set to 'false' instead of zero (0).

NAB - Calendar Widget: Corrected issue where shift to daylight savings time could cause events to display on prior day's calendar cell

NAB - Widget Filters: Adjusted logic so that when all filters are initially hidden, the Apply and Reset buttons are not displayed (per forum post)

NAB - Widget Filters: Corrected an issue where multi-select drop-downs rendered in "ultra slim" mode would truncate a character (per forum post)?

NAB - Behaviors: Added app-level events for function keys, allowing the application to listen for a function key press and then perform specific behaviors (per forum post)

NAB - Behaviors: Added support for time fields in "Prompt for more info" on RPG program calls (per forum post)

NAB - Behaviors: Adjusted calls to backend programs to ensure JSON arrays are "stringified" to retain their hard brackets (e.g., "[1,2,3]" will no longer be passed as "1,2,3")

NAB - Behaviors: Added ability in Designer to search the app variable listing (per forum post)

NAB - Behaviors: Corrected issue where retrieving an app variable from within an "execute script" action was not working properly

NAB - App Variables: Adjusted logic so that when a backend RPG program sets an app variable to a value beginning with a plus sign (i.e., '+123'), the value is treated as a string so the plus sign is retained. Previously such a value would be treated as a positive number and the "+" prefix would be dropped.

NAB - App Variables: Adjusted logic to prevent super long numeric strings from being expressed in exponential notation, so 1234567890123456789012 will no longer become 1.2345678901234568e+21 (per forum post)

NAB - App Variables: Adjusted logic so that when a value is wrapped in [hard brackets], check to see if it refers to another app variable before actually replacing it. If no app variable exists, NAB will now leave the value intact (with the brackets).

NAB - App Variables: Adjusted logic to ensure all NAB-specific app variables (such as nabUserId) are set immediately upon app launch, so any app variable expressions that reference them are processed as expected

NAB - Developer Console: Adjusted logic so that when one or more NAB apps have been launched within the current NAB app, a window will automatically appear prompting you to select which NAB app to monitor (per forum post)?

NAB - Developer Console: Corrected issue where dropdown grids would sometimes be shown in the widgets section multiple times; Corrected issue where searching in the network calls was not working properly; Added a tooltip when hovering over widgets in the widget section to show the underlying data source ID.

NAB - Import/Export: Corrected issue where an app containing nothing but utility widgets would fail to export (per forum post)

NAB - Import/Export: Corrected issue where exported widgets containing numerous intricate configurations (thereby requiring longer amounts of configuration instructions) could result in a corrupted widget upon import

NAB - Data Sources: Adjusted logic that derives available files and fields to accommodate scenarios where fields are not visible in QSYS2.SYSCOLUMNS (e.g., join logical files and remote data aliases)

NAB - Data Sources: Adjusted SQL parser to recognize CAST to character with no specific field length - e.g., CAST('-' AS CHAR CCSID 37)

NAB - Data Sources: Corrected issue where a vvIn_virtual replacement exceeding 2056 characters was being truncated. Now supports up to 32K characters.

NAB - Data Sources: Corrected issue where result columns in subqueries were not always being included during statement parsing

NAB - Exit Programs: Added a new gTabNumber global variable that will be populated with the tab number for the current widget, when applicable

NAB - Exit Programs: Corrected issue in EXNABBTN-based helper programs where the call to initiate the upload could fail due to a very large data set coming from the widget

NAB - General: For fields transformed to a dropdown, added a minimum width for the list to be set, with the default minimum width set to 70 (per forum post)

NAB - General: Corrected issue where a field transformed into a dropdown grid would not work properly when inside a popup window or was associated with a grid containing a locked column

NAB - General: Corrected issue where a field transformed into a dropdown grid would throw an SQL error if the value field was derived from a calculated column (per forum post)

NAB - General: Adjusted appbar title rendering such that if the title value includes a line break (<br>) it will be segregated into a bolded title and smaller-sized subtitle

NAB - General: Added the ability to rename a section and allow section names to have a maximum length of 20 characters, up from the previous limit of 10 (per forum post)

NAB - General: Added support for surrogate characters (i.e., emojis) in Valence.util.Helper.encodeUTF16?

NAB - General: Adjusted SQL data source Valence Assistant file definitions window to be closable (per forum post)

NAB - General: Corrected issue with app-wide slim/ultra slim UI setting where it would be ignored on top toolbar if no appbar title was assigned

NAB - General: Corrected issue on section-level events (show/hide) where the events would not be re-added upon editing behaviors when the section names were similar. For example, in a case where there was a section named "Contracts" and another named "Contract", the "Contract" events were being lost.

NAB - General: Corrected issue where some widget link properties were not working correctly when using the "Invert / Not / !" functionality

RPG Toolkit - vvUtility: Adjusted getObjectList procedure to address a CPF22F9 issue that became a problem with the latest IBM i cumulative PTFs released for 7.4 and 7.5. This issue can cause MSGW conditions in Spool File Viewer, legacy Excel downloads made through NAB or vvOut, numerous iAdmin functions and various other areas.

RPG Toolkit - vvUtility: Made adjustments to vvUtility_encodeUTF16 to improve performance when working with graphic (double byte) fields

Portal Admin - Settings: Corrected issue where removing the visibility of a component (e.g., by unchecking Autocode) would not disable edit checks on the formerly visible fields associated with that component

Portal: Added a search field in the environment selection window (per forum post)

Portal: Corrected issue where local cookie policy could cause a terminated Valence session to remain showing as active after user closed browser tab

??Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.???
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#12

07-08-2025, 10:01 AM

Valence Framework 6.3.20250708 is now available. Changes in this build since the previous release are:
NAB - Grids: Added a new "Selection Total" section under Link Widget Properties that can be use when checkbox selection is enabled and grid allows multiple selections (per forum post)

NAB - Grids: Add a new link property "hideRowBody" which, when set to true, will hide any row body content and, if expandable, the expander column.

NAB - Grids: Added a new link property "combineButtonsAndFilters" for use on grids that have filters on the toolbar as well as top toolbar buttons. When set to true, the elements will be consolidated into a single toolbar.

NAB - Grids: Corrected issue where, on grids with two downloads that were not paging and had multi-sort enabled, the right-most button was not fully visible

NAB - Grids: Corrected issue where right-click action was not working on right-aligned icon columns

NAB - Grids: Corrected issue where PDF downloads over grids with both grouping and summary functions activated were not being built correctly

NAB - Edit Grid: Corrected issue where a form linked to the edit grid containing fields transformed into radio buttons would sometimes fail to display the selected value of the field (i.e., no radio button is selected)

NAB - Edit Grids: Added a new Import CSV/Excel feature (Beta)

NAB - Edit Grids: For local data, added a new widget property "dataCommitted" which, when set to true, locally syncs the store, treating new, changed, or deleted records as if they are in a "clean" state, as if the data had just been reloaded. This is helpful if you save data for a local data edit grid and don't want to reload the grid just to turn off the data changed cell indicators.

NAB - Edit Grids: Corrected issue with inline cell editing where a column set to be editable on add but not on edit (or vice versa) was not working as expected

NAB - Edit Grids: Corrected issue introduced on prior build to consolidate action buttons where possible, where if the edit grid had "Add" ability enabled and included an action button, it would lose the Add button

NAB - Edit Grids: Corrected issue where the "hasChanged" link property would not work on grids using local data with in-line editing

NAB - Edit Grids: Corrected issue where a field marked as available for both add and edit, with only the edit field marked as read only, would incorrectly show as read only for adding as well

NAB - Edit Grid: Corrected issue where if "Add" feature was disabled via a startup program, the button was not hidden as expected

NAB - File Upload: Added the ability to drag and drop a file onto the upload field

NAB - Filters: Corrected issue where filter fields transformed to drop-down grids were not being applied correctly

NAB - Forms: Added new option "Turn Off Browser Suggestions" that will prevent the browser from auto-suggesting any values in fields (addresses, passwords, etc.)

NAB - Forms: Added new widget property link "focusFieldName" wherein specifying the name of a form field will auto-focus to that field

NAB - Forms: Corrected issue where a display field sometimes doesn’t show the proper value when set via an app variable

NAB - Forms: Corrected issue where linked app variable to set all fields to 'read only' was not being applied to lookup fields

NAB - Forms: Corrected issue where linked app variable to set all fields to 'read only' was not working against fields which were separately linked to field-specific 'read only' app variables

NAB - Charts: Added color rules for gauge charts (per forum post)

NAB - App Variables: For app variable expressions, added a new local function called nabTriggeredBy(), into which you pass an app variable name (or an array of app variable names). Function will return true if any of the passed app variables triggered the call to the expression for re-evaluation.

NAB - App Variables: Added a new app variable "nabMaskApplication" which will mask the app when set to true, or when set to a text value will mask the app with the specified text. When set to false the application is unmasked.

NAB - App Variables: Corrected issue where nabCurrentTimeStamp was not being set to the current time of the device (per forum post)

NAB - App Variables: Corrected issue where calculated fields transformed into a drop-drown grid, the field would not be listed in the "Selected Record: FIELDNAME" link app variable section

NAB - App Variables: Added "nabRefreshAllVisibleWidgets" to trigger new refresh option

NAB - Behaviors: Added a new Utility Action in behaviors: Utility > Refresh All Visible Widgets

NAB - Data Sources: Added support for comment blocks in SQL. Must /* apply comments like this */

NAB - Data Sources: Added support for escaping single quotes

NAB - Data Sources: Adjusted vvIn_virtual to escape any single quotes found in the app variable value

NAB - Data Sources: Adjusted SQL formatter to better handle reserve keywords during formatting. Prior to this a space could be injected - for example, "DIV#" was previously formatted as "DIV #" because DIV is a division keyword. Now, DIV# remains DIV#.

NAB - App Breadcrumbs: Corrected issue where an app variable linked to the breadcrumb text would not get updated properly after being set initially

NAB - Timeline Widgets: Corrected issue where setting the UI > Scale Step in the link to widget properties, the step was not being applied correctly to the scale

NAB - Event Listeners: Added ability to use Utility > Refresh action on event listeners

NAB - Exit Programs: EXNABSTART-based programs using disableFeature are now setting app variable nabFeatureXXXX (where XXX is the feature name) to make the action more visible in the NAB Console

NAB - Dev Console: Added search option over data source responses

NAB - Dev Console: Corrected issue where the Active Widgets/Fields section would not always show all visible widgets under certain conditions

NAB - Utility Widget: On scrolling containers, added a new settings property to allow for collapsing/expanding the container items

NAB - General: Added a new widget property called "nabHideDataSourceLoadMask" which, when set to false, will omit the mask on the widget during load

NAB - General: When a numeric field has been transformed to a checkbox, adjusted logic to ensure that boolean values are not used; Developers must specify custom numeric values for true and false, which default to 1 and 0 respectively.

NAB - General: Corrected issue where apps being launched with a parameter passed to set nabHideAppBar to true was not always working properly

NAB - GIT: Corrected an issue where a commit message containing double-byte characters would trigger an error when performing a rollback

Instance Manager: Added ability to terminate all sessions in a specific instance

Portal Admin - Settings: Adjusted Java Classpath entry to be a pop-up grid rather than a text area; Adjusted authorized programs to be listed in alphabetic order

Portal Admin - Settings: Corrected issue where license expiration date was not showing on hover

Desktop Portal: Added ability to add or remove an app as a favorite via the search bar in the top-right corner by checking or unchecking star icon

?Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.?
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#13

08-21-2025, 10:42 PM

Valence Framework 6.3.20250821 is now available. Changes in this build since the previous release are:
Nitro App Builder (NAB) - Grids: Added summary.isGroup for custom renderer, which will be set to 'true' when working within the summary of a group and not the total summary row

NAB - Grids: Corrected issue where summary values were not displaying correctly on PDF downloads

NAB - Grids: Corrected issue where a PDF download over grids containing images would fail under certain circumstances, leaving the screen masked as if it were still building the file

NAB - Grids: Corrected issue where any grid utilizing the "Selection Total" app variable link would cause a console error upon startup of the application

NAB - Grids: Corrected issues with the combineButtonsAndFilters widget property where, if global search was not enabled, then action buttons could sometimes disappear and toolbar items could appear with a fill at the front, causing filters to be centered

NAB - Grids: Corrected issue where the summary.group.get for a custom formatter would sometimes not give the group value (only applies if summary is active for a column and the grid is grouping)

NAB - Grids: Corrected issue in Designer where dragging and dropping a column container could result in a hard error

NAB - Edit Grids: Added an option to prevent decimals on editable fields that contain decimal places

NAB - Edit Grids: Added ability to dynamically change the number of decimal places on columns that are editable on edit or add. Must be equal to or less than the field's original number of decimals.

NAB - Edit Grids: Added a maximum value option to numeric fields, similar to the minimum value option

NAB - Edit Grids: Added logic to validate that a file selected for upload matches the file type specified

NAB - Edit Grids: Corrected issue where, when using Cell Editing, and a cell was both editable and locked, a console error would cause the widget to become unresponsive

NAB - Edit Grids: Corrected issue where, under certain conditions, fields flagged as read-only were still editable

NAB - Edit Grids: Corrected issue with Inline Row Editing where if a transformed field is the only item flagged as editable (not read-only), then the row editor would not display on row click

NAB - Edit Grids: Corrected issue where isInvalid widget property was sometimes set to false even though a field on the row was invalid

NAB - Edit Grids: Corrected issue on grids using local data where filters were being applied to the data source rather than to the local data

NAB - Forms: Adjusted "minimum value" configuration to allow up to 5 decimal places

NAB - Forms: Adjusted UI so that whenever a field has an input format defined, the field value will be automatically selected when focused (per forum post)

NAB - Forms: Corrected timing issue where hitting Enter too quickly after changing a field linked to an app variable could sometimes result in the value not being passed to the form helper program (per forum post)

NAB - Forms: Corrected issue where multiple selection combos inside forms using slim or ultra-slim view were not showing the first character when typing into it (per forum post)

NAB - Forms: Corrected issue where setting a tooltip to a field via an app variable was only working on editable fields

NAB - Forms: Corrected issue where the isInvalid property could be incorrectly set to true upon loading data under certain conditions

NAB - Forms: Corrected issue where fields transformed into dropdown grids could indicate that the form has changes (via "hasChanged" property) when no changes have actually been made

NAB - Forms: Corrected issue in Form Helper where field value would not be set when program was filtering a drop-down field's data and setting its value on the same call

NAB - Forms: Corrected issue on lookup fields where the read-only property was not being honored when set to true

NAB - Forms (mobile): Corrected issue where attempting to use the NAB file upload inside a form would fail

NAB - Forms: Corrected obscure issue where a field transformed into radio buttons inside an edit grid-linked form, where the form includes a helper program for form rendering and the radio buttons are connected to a data source, could result in the value of the radio button field not being passed down properly

NAB - Info Utility Widget: Added ability to attach a "primary" button

NAB - KPI widget: Corrected issue where the progress bar was not visible

NAB - Timeline widget: Corrected issue where a refresh would cause wrong results if grouping is enabled and the previous dataset had new groups added or removed (per forum post)

NAB - App Variables: Corrected issue where assignment of a string value with an embedded "E" could be incorrectly interpreted as scientific notation (e.g., setting an app variable to '12345E02' would be interpreted as '1234500')

NAB - Behaviors: Adjusted Designer to include nabFeature app variables, etc. in the link widget properties list

NAB - Filters: Added option to have filter(s) initially hidden

NAB - Data Sources: Added support to SQL parser for sub-selects with unions

NAB - Data Sources: Added support to SQL parser for hierarchical traversal clauses (e.g., "start with xxx conect by yyyy) by converting the main statement to a CTE so filtering can be successfully applied at runtime

NAB - Data Sources: Added support to SQL parser for RECURSIVE keyword in CTEs (e.g., "WITH RECURSIVE numbers (n) AS (...")?

NAB - Data Sources: Adjusted the SQL parser's comment handling so it now converts line comments into block comments, as the IBM i SQL validator cannot always accommodate line comments?

NAB - General: Added a new widget property, 'preventAutoLoad', which when set to true will prevent the widget from autoloading

NAB - General: Corrected issue where enabling a feature would sometimes not show the button/widget to which the feature was attached

NAB - General: Corrected issue in Designer where if a vertical container has more than one horizontal container within it, only the widgets for the last horizontal container are saved

NAB - General: Corrected rare issue where, upon clicking data source menu button to create a new widget, the loadmask would not clear

NAB - Import/Export: Corrected issue where any widget using the "clear data" option would revert back to "load data" (default) upon import

Instance Manager: Added ability to terminate all sessions in a specific instance

RPG Toolkit - vvOut_Data: Corrected issue where a pointer to data flagged as "binary" was being treated as regular character data and thus corrupting the output

Portal - Web Services: Adjusted back-end VVSECURE web service logic to be more efficient when pulling in Valence settings (now skips data area check)

Portal - General: Corrected issue when launching apps where "%" was getting encoded when it shouldn't be

Portal Admin - Apps: Corrected issue where, when a delete request for an app was blocked due to the app being referenced in another app for launch, no error message was showing explaining why the delete could not be processed

?Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.??

Last edited by robert.swanson; 08-22-2025, 02:26 PM.
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#14

09-10-2025, 01:34 PM

Valence Framework 6.3.20250910 is now available. Changes in this build since the previous release are:
Nitro App Builder (NAB) - Grids: Corrected issue involving checkbox selections inside infinite scrolling grids where the grid would think previous selections were still selected after a refresh (per forum post)

NAB - Edit Grids: Expanded the "No decimals" and ability to set a max value configuration to include dialog editing (previously only applied to inline editing)

NAB - Edit Grids: Corrected issue where a console error could occur in cases where grouping is enabled, local data is active, and the value of a group field is changed

NAB - Edit Grids: Corrected issue where, when row editing and defaulting the number of decimals allowed for a field are enabled, the app could encounter a console error at startup

NAB - Edit Grids: Corrected issue where, if a column's Decimal Positions had a default value, a console error could occur if the grid was not yet available

NAB - Forms: Adjusted logic for accommodating pasting into a numeric field so that line breaks are ignored and only valid numeric digits are accepted

NAB - Forms: Corrected issue where Radio Buttons that had been disabled and then reenabled via an app variable change would remain disabled

NAB - Forms: Corrected issue in dropdown grid where, if initially empty and then a selection was made, the form's "isChanged" linkage was not being set

NAB - Forms: Corrected issue where, under certain conditions, setting all fields to readonly true/false was not being applied to all fields

NAB - Filters: Adjusted logic so that hidden filters are not included when checking that all filter values are valid

NAB - Tab Panels: Corrected issue where a hard error could occur if tab panel widget properties were manually set instead of using an app variable

NAB - Data Sources: Added support for QUARTER, WEEK and EPOCH in EXTRACT function inside SQL parser

NAB - Data Sources: Corrected issue where vvIn_Virtual would escape single quotes inside a field value when it should not be

NAB - Data Sources: Corrected issue where a DISTINCT clause was not being handled properly in parser

NAB - Data Sources: Corrected issue with certain CASE statement structures not being recognized by parser (per forum post)

NAB - Behaviors: Improved window height optimization logic on Call RPG Program additional info window

NAB - Import/Export: Corrected issue where apps consisting of only utility widgets and/or other app references would fail to import

NAB - General: Added new App menu option Miscellaneous > Debug Info to assist with pulling pertinent debug info for tech support

NAB - General: Corrected issue where the appbar title was erroneously line breaking when html markup exists in the title

NAB - General: Corrected vertical alignment on appbar title, which was off on any apps using slim or ultra slim UI

NAB - General: Corrected issue where Main section lost the ability to specify Settings (width)

NAB - General: Corrected a Safari-specific issue where the Save Widget dialog box would appear empty or blank

Portal - General: Corrected issue with URL parameters being unnecessarily encoded upon app launch

Portal - Login: Adjusted back-end logic to return user's email address upon successful login

Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.?
Comment
richard.milone

CNX Co-founder and Managing Partner

Join Date: Jun 2008

Posts: 965
- Share
- Tweet
#15

09-25-2025, 12:59 PM

Valence Framework 6.3.20250923 is now available. Changes in this build since the previous release are:
NAB - Grids: Added an option to exclude specific columns from the generic grid search (entitled "searchable"), available when not searching by column or using a local search (per forum post)

NAB - Grids: Corrected issue where, when a menu button or icon column was set to call a backend program and the grid had checkbox selection enabled, selecting multiple rows caused the row menu button or icon column to pass all selected rows, not just the row clicked (per forum post)

NAB - Grids: Corrected issue where locked columns were not remembering column "state", such as resize, order, hidden (per forum post)

NAB - Grids: Corrected issue where if global grid search this is turned on over a hex-sorted data source, an error could occur on graphic fields encoded to double byte CCSID values

NAB - Edit Grids: Corrected issue where, when an edit grid allowed multiple tables for deletion, the widget property "deleteConfirmMsg" was not available unless it had only one table

NAB - Edit Grids: Corrected issue when using cell editing where if a numeric field’s decimal positions were specified (i.e., overridden via a widget property or app variable), the setting was not being applied

NAB - Edit Grigs: Corrected issue when using form-based editing where a field's decimal positions setting could cause a minor value change to not be detected and thus not be applied to the underlying file

NAB - Pivot Grids: Adjusted to allow for selecting specific types of exports if exporting is turned on, rather than providing all the download options (per forum post) ?

NAB - Forms: Adjusted timing for primary button (triggered by ENTER key) to ensure helper program is called and completed prior to executing the click action (per forum post)

NAB - Forms: Corrected issue where using an app variable to set all form fields to read-only was not accommodating field-level overrides to the read-only property

NAB - Utility Widgets: Corrected issue where horizontal containers were not made available to be added when inside a tab container > scrolling container

NAB - Timelines: Corrected issue where reloading a timeline that was not grouping was not working properly

NAB - Behaviors: Added setAppVar method to be made available when using Filter Widget and providing a custom filter

NAB - Behaviors: Corrected issue where buttons that should be shown would sometimes not appear under certain conditions (per forum post)

NAB - Data Sources: Adjusted SQL parser to identify the line number causing a syntax error, when possible

NAB - Data Sources: Corrected issue where spaces were not being added correctly for httpgetclob syntax in the SQL parser, resulting in an error upon validation

NAB - General: Corrected issue where the 'preventAutoLoad' set to true on a widget would, under certain conditions, autoload the widget anyway

NAB - General: Corrected issue where the 'nabHideDataSourceLoadMask' property was not being checked on form and map widgets, resulting in the mask being shown even when set to true

NAB - General: Corrected issue in Designer where the check-in/check-out information could incorrectly render the name or description of a NAB object

Portal Admin - Categories: Corrected issue where disabling a category was not saving correctly

RPG Toolkit: Added VVKILLALL command, which will terminate all active sessions in the instance (per forum post)

Go to https://www.cnxcorp.com/downloads to download this release of Valence 6.

Go to https://forums.cnxcorp.com/node/17784 for full release notes.?
Comment

Previous 1 2 template Next

Announcement

Valence 6.3 (All Builds)

Valence 6.3 (All Builds)

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment