2023.06

Release Notes

Enhancements

The following are key enhancments in Servoy version 2023.06

ECMAScript Parser

Servoy is in the process of updating the JavaScript engine and tooling to be compatible with ECMA 2015+. In the 2023.6 release, we have added an ECMA parser, which enables developers to use more modern JavaScript syntax.

Try it Out

In Servoy Developer, go to the menu Window -> preferences -> JavaScript and select the option "Enabled the ECMAScript parser", after which your Script Editor will be able to parse newer ECMA syntax, such as Arrow Functions and Template Literals.

Example of Arrow Function

const materials = [
  'Hydrogen',
  'Helium',
  'Lithium',
  'Beryllium'
];

application.output(materials.map(material => material.toUpperCase()));
// Expected output: Array [HYDROGEN, HELIUM, LITHIUM, BERYLLIUM]

Additional syntax will be possible in forthcoming releases, such as let and for-of loops.

Stateless Authentication

The processes of authentication is being moved out of Servoy Developer and in the future will work with Authentication Providers, including ServoyCloud and 3rd-party identity platforms (i.e. Azure AD, Okta, Google, etc)

As part of this process, the login screen will become stateless and will not initiate a client session until post-authentication. This will increase performance and pave the way for a more integrated security setup!

This change only applies to a Solution having mustAuthenticate to true and having NOloginForm or loginSolutionName. All other solutions will not be affected.

Servoy Developer Connects to ServoyCloud

For customers that build applications in ServoyCloud, the Servoy Developer (IDE) can now automatically checkout these applications from ServoyCloud Repositories.

Servoy Developer adds simplified UI to quickly push and pull from ServoyCloud when you have a cloned repository selected.

This applies only when having an empty workspace and when you are logged into the IDE using your ServoyCloud credentials. All other implementations will be unaffected.

Value List - Search Customization

A new configuration property has been added to allow developers to customize the behavior of components using ValueList objects to perform look-ups.

A new property type is added to the system ValueListConfig which will be used besides the ValueList property type for certain components like the typeahead which use the filter option of the valuelist. now through the config file you can say how the filtering should be done like "startsWith" or "contains" also should only the display values be queried or also the real values.

This is a replacement for components that now use APP_NG_PROPERTY.VALUELIST_CONTAINS_SEARCH UI property, components that use the filter options should start using this new ValueListConfig property

List Form Component

We have added properties rowEnabledDataprovider and a rowEditableDataprovider to the ListFormComponent to disable or make 1 row read-only based on a calculation dataprovider. Also inline with other components the "readonly" property is only used under the hood by controller.readOnly and an "editable" property should be used to make the LFC itself fully read-only or not through code.

HTTP Client Pugin

HttpClient plugin now has an option to disabled hostname/certifcate validation completely with HttpClientConfig.hostValidation = false. (this should only be used for testing purposes!)

NGDesktop

When using NGDestkop and you use application.showUrl() or that is used under the hood (by the OAuth plugin) then you need to also update ngdesktop to the latest release. Else showUrl will fail or don't do anything.

Behavior Changes

Below are key client behavior changes to be aware of.

List Form Component - Default Scrolling Mode

The ListFormComponent now supports scrolling and that has become the default mode. (Previous implementations supported only pagination)

If you take no action, then you will notice that these lists will scroll instead of paginate. However, if you want to revert to the classic mode, then you can configure the client using a UI property LISTFORMCOMPONENT_PAGING_MODE. This can be done globally or for individual components.

Revert Globally

// Revert to classic pagination for ALL list form components
application.putClientProperty(APP_UI_PROPERTY.LISTFORMCOMPONENT_PAGING_MODE, true) 

Revert Individually

// Revert to classic pagination for an INDIVIDUAL list form component
elements.orders_fc.putClientProperty(APP_UI_PROPERTY.LISTFORMCOMPONENT_PAGING_MODE,true);

List Form Component - Responsive Height

When using a Responsive Layout form, the behavior can change because the responsiveHeight property of the ListFormComponent will work the same as the responsiveHeight property of the Data Grid.

API Changes

The following are additions and changes to API

• Added method getRecordByPk() to JSFoundSet (and ViewFoundSet): Added performance enhancement: Allows a developer to quickly get a cached record by primary key. Does not trigger a query to the database.

• Added methods getSQL() and getSQLParameters() to QBSelect, JSFoundSet (and ViewFoundSet) Allows a developer to quickly get the underlying SQL and Parameters from an object. These methods are now Deprecated from JSDatabaseManager.

• Added getLoadedFoundsets() to JSDataSource. This method can be used to loop over JSFoundSet objects and programmatically dispose of them to clean up resources quickly.

• Added getFoundset(name) to JSDataSource. An existing JSFoundSet under that name will be returned and created if need be.

• Performance enhancement JSDataSource.getRecord() now uses a special named JSFoundSet instead of a fully cached JSFoundSet.

• A disposed JSFoundSet cannot be used anymore (added checks)

added servoy property

"servoy.ignore.invalid.server.on.import=true" can be added to the servoy.properties file when you allow database servers to be invalid on import. Be carefull with this, because this does mean servoy will not do any updates to the schema op the database, so that is something you have to control your self. If you use this to have all kinds of clones that don't have to be there at startup, then those servers will be in a disabled state, and we will try to enabled it at the moment you use databaseManager.switchServer() So switch server can fail if the server still can't be connected to at that time.

Case List

Below is a comprehensive list of cases associated with each release candidate

2023.06-Final

We added a System property (-Dservoy.useES6) or through an Environment property to be able to set the javascript parser to the new ES202x mode. So that also through the command line you when exporting a solution/making a war the new parser can be used when exporting.

Also a new quick fix is added to the new builder warning for json properties that are in the frm files that are not in the spec anymore for those components.

Components	Key	Summary
Developer	SVY-18173	No builder marker for an unresolved media property value on Image Label (Servoy Extra Components)
Developer, NGClient	SVY-17987	Error when running as TiNG
Developer	SVY-18350	Add property for SH exporter to use the new JS Parser
NGClient	SVY-18351	OnClick in listformcomponents broken if editable = false
Runtime	SVY-18356	Logging to external log / custom fields

2023.06-RC3

This is a release for the new NGGrid release, we needed to upgrade the underlying AGGrid lib from 29.x to 30.x because of some issue they fixed. But this is a major version increase, we made this RC3 release for a bit more testing. You have to use the latest NGGrid 2023.06.x also with Servoy 2023.06_RC3. This stuff also affects the new ListFormComponent in scrolling mode (see Behavior differences)

Components	Key	Summary
Developer	SVY-18327	Cannot save changes in clients page of Preferences
Developer	SVY-18319	CC on form yields a `getFoundset() - JSFoundSet` entry
Server	SVY-18290	Server does not spawn anymore rest_ws clients
Server	SVY-18160	Stateless Login - Basic

2023.06-RC2

Components	Key	Summary
Developer	SVY-18316	Strange exception when adding column to NG Grid via right click in outline view
Extensions, NGClient	SVY-18060	TiNG Popup menus drop out of screen
Extensions, NGClient	SVY-18214	Cannot use Valuelist Empty Value when APP_NG_PROPERTY.VALUELIST_CONTAINS_SEARCH is true
NGClient	SVY-18244	new servoyApi.hide/showForm methods not workign properly (SVY-17504 Followup)
NGClient	SVY-18282	Disabled popup menu items are clickable in TiNG
NGClient	SVY-18025	Console.log statement locations in code are not easy to find due to override from sablo_app.ts
NGClient	SVY-18320	Setting container.setCSSStyle breaks when using string variable
Runtime	SVY-18321	Changed behaviour of _super variables

2023.06-RC1

Components	Key	Summary
API, Runtime	SVY-18088	Support QBSelect.getSQL/getSQLParameters()
Developer	SVY-18040	using servoy.ng2.target.folder in servoy.ini causes NG2 launching to fail
Developer	SVY-17995	Form editor changes using a Responsive Container
Developer	SVY-18000	NG2: Several problems related to styleClass in Properties view
Developer, NGClient	SVY-17987	Error when running as TiNG
Developer	SVY-17980	base and sub form component inheritance in the designer issues
Developer	SVY-18011	Error no such file when creating component/service
Developer	SVY-18032	2023.3_RC - Different fonts in servoy package manager?
Developer, Runtime	SVY-18071	.dbi file creation order property
Developer, DLTK	SVY-17537	spike: investigate js syntax tree parsing for supporting stuff like Template Literals or Arrow Functions
Developer	SVY-18034	Property generator bugs
Developer	SVY-18106	docs added on each save
Developer, Server	SVY-18209	Visual support for update.zip on the admin-page & about servoy popup
Developer, DLTK	SVY-17522	Enable support for ES2015 Template Literals
Developer	SVY-17700	NG2 designer: abstract form
Developer	SVY-18173	No builder marker for an unresolved media property value on Image Label (Servoy Extra Components)
Developer, NGClient, Runtime	SVY-17563	Enhance the IValueList filterList method to allow two additional filter options
Developer	SVY-18180	Locate Servoy Resource doesn't find designtime declared View FoundSets
Developer	SVY-18191	Cannot update module in SPM
Developer, DLTK	SVY-17523	Enable support for ES2015 Arrow functions
DLTK	SVY-18072	Fix dltk's stackoverflow issue
Extensions, NGClient	SVY-18041	NG2 issues setting relative split pane divider position, nested panels
Extensions, NGClient	SVY-18050	NG2 inline calendar takes way more height compared to NG1 implementation
Extensions, NGClient	SVY-18090	[NG1, TiNG] file upload onFileUpload not triggered when uploading a file with same name
Extensions, NGClient	SVY-18117	AGGrid not updating when adding 50+ rows
Extensions, NGClient	SVY-18179	NG2 - When double clicking in a data grid with only a onCellClick event, the record selection fails
Extensions, NGClient	SVY-18214	Cannot use Valuelist Empty Value when APP_NG_PROPERTY.VALUELIST_CONTAINS_SEARCH is true
Extensions, NGClient	SVY-18125	sidenav - navbar searches for default text
Extensions	SVY-18116	HTTP Plugin is returning bad data
Extensions, Installer	SVY-18210	Please extend Jakarta POI shipped with Developer to include POI-OOXML jar
Extensions, NGClient	SVY-18119	inconsistent padding in bts-textbox in TiNG
Extensions, NGClient	SVY-18236	bootstrap extra switch bug in touch mode
Extensions, NGClient	SVY-18190	Checkbox does not toggle
Extensions, NGClient	SVY-18122	fullcalendar2 premium plugins dont work nomore
Extensions, NGClient	SVY-18260	Bug on DBTreeview setSelectionPath method
Extensions, NGClient	SVY-18255	plugins.svyBlockUI.stop() no longer cancels all messages - leaves system unusable [TiNG]
Extensions, NGClient	SVY-18149	TiNG Image Label error when has multiple styleClasses applied
Extensions, NGClient	SVY-18172	Native select works not correctly when description for some optoins are the same
Extensions, NGClient	SVY-18225	Bootstrap combobox keypress registered 2 times
Extensions, NGClient	SVY-18142	Navbar onMenuItemClicked does not update dataproviders of input fields in TiNG
Extensions, NGClient	SVY-18101	PdfJsViewer is not showing the pdf in TiNG
Extensions, NGClient	SVY-18087	[ti client]file upload enabled property
Extensions, NGClient	SVY-18202	Carousel arrows are missing in TiNg
Extensions, NGClient	SVY-18029	Smart Doc Editor bugs
Extensions, NGClient	SVY-18031	Make plugins.ngclientutils.setBackActionCallback intercept back action
Extensions, NGClient	SVY-18207	ERRORS: checkboxes return "true" instead of 1 in Servoy NG-Grids
Extensions, NGClient	SVY-18273	Grid looses state when form is hidden and shown again
Extensions, NGClient	SVY-18227	ServoyExtraComponents TextFieldGroup has wrong value for onAction method [TiNG only]
Extensions, NGClient	SVY-18211	Collapsible runs onShow of all contained forms when the first one is shown [TiNG only]
NGClient	SVY-17968	Unable to expand the content of a combobox in NG1
NGClient	SVY-17994	Override solution property titleText programatically
NGClient	SVY-18021	Listform component missing data-target on elements
NGClient	SVY-17413	Ability to create proper JSEvents in the serverside of Web components
NGClient	SVY-18104	TiNG Default Button not centered vertically
NGClient	SVY-18109	TiNG upload dialog button arrangement has no spacing
NGClient	SVY-18135	Radio buttons not horizontal alligned NG TI
NGClient	SVY-17751	rowEnabledDataprovider for ListFormComponent
NGClient	SVY-18262	Enter shorcut in find mode does not work
NGClient	SVY-18114	Listform component breaks when rending more rows with a sort
NGClient	SVY-18016	Global Method Valuelist called with wrong row
NGClient	SVY-18171	Adding/removing style classes from containers not working
NGClient	SVY-18206	NG2 - popupMenu does not show in the correct position
NGClient	SVY-18271	Log entry created when an error occurs browserside, but not with the relevant details
NGClient	SVY-18083	CSS for ng_invalid is incorrect [TiNG only]
NGClient	SVY-18076	Tabseq in formpopup broken
NGDesktop	SVY-18219	Since NGDesktop Client 2023.03.1 using OAuth2 opens Flow in default browser
Runtime	SVY-17404	'this' inside forms methods is runtimeForm-like, but instanceof runtimeForm yields false
Runtime	SVY-18079	Support QBJoins.remove(string)
Runtime	SVY-18144	Retrieving a known QBLogicalCondition instance via QBSelect.where.getCondition(name) doesn't return a QBLogicalCondition instance
Runtime	SVY-18128	Support foundset.getRecord(pkArray)
Server	SVY-17977	setTennant seems to loop
Server	SVY-18153	skipDatabaseViewsUpdate prevents a view's columnInfo to be written to the repository
Server	SVY-18140	Blocked threads
Server	SVY-18193	New WARN in server log file with 2023.3.1