Version:
20222024-
R2R1-SR3 (5.
14.
63)
Release date: 14 February 202321 August 2024
Highlights
Dashboards: Work with multiple and personalized dashboards. Choose between cached and real-time widgets, with an optimized presentation.
Translation Management: Perform one-click updates via Google Translate or the DeepL service. Perform fast multi-updates directly in grid.
API: Work easier with delta loads or time-controlled queries via the new date operations.Language variants on selectables:
Validate selectable translations in grid and item editor
Edit translations via “Open selectable item”
‘Default values’ and ‘Copy’ are now allowed together
Action management improvements
Multiple environments:
Manage environments
Individual connections for each environment
See more info in the features presentation (on the front page of the Knowledge Base) or refer to the release notes.
Windows Client
The Perfion Windows Client has to be installed/upgraded for all Perfion users
Release Notes
20222024-
R2R1-SR3 (5.
14.
63)
2022-R2 (5.1.1)
Release note title
Release note
Bugfix of Table Designer supporting remote parameters
When using remote features with parameter in table - both in Table Designer and in report - proper parameter usage is now used.
2022-R2 (5.1.0)
Release note title
Release note
Removing all roles from a user would leave him with default roles
In previous versions of Perfion, if you removed all roles from a user, he/she would get assigned all the default roles. This error has been corrected.
API validation also validated base value
When updating a value for a feature with validation, Perfion would in previous versions also have the base-value validated using the same rule. That error has been fixed so now only the correct feature is validated.
Bugfix of Table Designer to not show empty features in dynamic tables
In Table Designer when using feature list (e.g. @GROUP(...)) an empty feature could be shown when the items in the table did not have values for the feature but the parent did have value. The error occurred if the feature was non-inherited. This has been fixed.
Actions - command Send.Email and method SendEmail
The Email library used in Actions is changed from System.Net.Mail to MailKit to secure future referments for authentications
Actions - SELECT.PERFION.REPORTDATA and Table Designer
The SELECT.PERFION.REPORTDATA did not find all features in the Table Designer if the table designer use Feature List to define the Features to the table design.
Internal cache do not need “View Server State”-rights to the Database
In Perfion 2022-R1-SR2, the Database user required the “View Server State”-rights to access the internal cache. The internal cache is changed and the “View Server State”-rights is not need anymore.
User IDs can now hold up to 26 characters
The unique user id on both users and groups can now hold up to 26 characters instead of the previous maximum of 10 characters. Furthermore it is now only allowed to create user ids using English letters, digits, underbars and dashes. User ids already created using now invalid characters will, however, not be converted and hereby be kept as they were in previous versions of Perfion.
Possible to create a scheduled job for synchronizing inactive users from Active Directory
Previously, it was only possible to sync inactive users when opening settings for Users & Groups.
Now it is possible to add a scheduled job to synchronize inactive users from Active Directory.
It is still possible to do a manual update by going into Users & Groups and pressing the button to sync inactive users from AD
Possible to migrate existing Perfion users to Active Directory users
Before Active Directory would be created even when a Perfion user had the same email.
Now it is possible to migrate all Perfion users with an email to AD users or migrate a single user
Export from grid updated to comment ReadOnly features
Export from grid includes features with enabled ReadOnly data property, but data from such features cannot be imported back to Perfion. Therefore, the handling of export was updated to comment such features by prepending a hash character which means that such features will be ignored when importing data back to Perfion using Feature Data importer.
DevExpress components has been updated
The Perfion software uses the DevExpress component library. This library has been updated to latest version, 22.1
Could not store Tasks if not General-tab was selected
In previous versions of Perfion you could get an error when trying to store a Task without having the "General"-tab selected. This issue has been corrected.
Configuration files for ApplicationServer package has been renamed
The configuration files included in the deployment package for the Perfion Application Server has been renamed to .example to avoid overwriting of existing .config files during upgrades. The administrator, after update of the database connection string, will have to rename the file to have the .config extension.
Views and Filters was not sorted correctly
Views and Filters selectors in the main grid did not sort the items correctly.
This has been resolved.
ECommerce-API: IncludeTiming-parameter did not include embedded binaries
The includetiming-parameter did not include the time it took to fetch and embed binaries in case these were embedded in the result of typically a GetProducts-call. This has been fixed.
Localizable feature filtering in the grid fixed
The filtering in the grid did not work correctly when using localizable features which had empty values. This issue was fixed.
Bugfix when copying item with children having values conflicting with default values
When copying an item in the grid where children exist having values for feature having default value the default value of the parent conflicts with the child values if inheritance used.
It is now not allowed in the feature configurator to both set a default value for a feature and set the feature as copy.
Support for calling translation from action
It is now possible to use a new script method in actions for translating text from one language to another.
DeepL translation available in Windows Client
It is now possible to translate feature values in the grid and in the item editor using DeepL.
Actions - ExecuteActionLoop
Parameters in ExecuteActionLoop was only resolved in the first loop. Parameters is not resolved in every loop.
Bugfix of Perfion API using case sensitive selectable values
In the Perfion API specifying a selectable as a value not using selectable ID now properly uses case insensitive values so e.g. specifying 'black' properly matches 'Black' in the database.
Import of table features possible
It is now possible to import also table features - both as base feature; i.e. add feature data to a table selectable feature and as a feature for another base feature; i.e. set table feature selectable value for a base feature.
Users without permissions to read Action-features would get error executing actions from menu
A user without read permissions to run Actions would get an error saying "No access to 'ActionMapTo'" when trying to execute an action from the "Execute Action"-menu. This has been fixed.
Multi Factor Authentication
It is now possible to setup Multi Factor Authentication at the login process.
New Dashborad version
The new Dashboard include things like, see the documentation for more information:
Multiple dashboards
User permissions for each Dashboard
New layout in the Windows Client
Dashboard widgets are organized in sections and rows
Expressions can be used for formula features in Table Designer
It is now possible to use expressions in Table Designer if the element is a formula value. Expressions available for Table Designer formula usage is: @FormatValue, @CaseReplace and @Convert.
Bugfix of Table Designer not sorting correct when feature with expression used for sorting
When Table Designer sorting is used (order attribute set) on column using same feature to sort as column feature and an expression is present for the feature column the sorting is now functioning correct using original value for sorting instead of expression resovled value.
Bugfix of Table Designer expressions not showing three letter language alternative captions/units
In Table Designer when using an expression like @FormatMultiValues(
{CaptionAlternative}
(
{Unit}
)) the alternative captions and units was not shown for language codes constisting of three letters (DAN, NLD, ...). The proper mapping is now done.
Grid/API performance optimizations
Grid and API operations when updating, deleting and inserting data were optimized to perform operations in bulk mode instead of handling data in 1-by-1 basis. These changes affects all operations in grid, but can also have influence in other parts of Perfion, e.g. when using Perfion API.
In Table Designer now possible to clear style setting
Before it was not possible to clear style settings in Table Designer. This is possible now as a default, empty option is available.
Update Tabel Designer documentation to describe sorting better
Due to some confusion regarding usage of Table Designer sorting (order attribute) the Perfion Table Designer manual is updated with better description regarding this.
Google Translate available in Windows client
It is now possible to translate feature values in the grid and in the item editor using Google Translate.
A new context menu item to import data added to categorizer feature items
A new context menu item added to all categorizer features used in sections on the left side. The new menu item allows importing feature data to selected categorizer feature. Before the change the same functionality was only available from Feature and Feature Data sections and with this update it is now available in all sections.
Reporting parameters now supports use of system-date calculations
Date parameters used in reporting now supports use of system date variable calculations. You can now enter expressions like @@DATE-1d which will be converted into a date with the value of today minus one day.
Bugfix of Table Designer expressions showing all language values for a derived value
In Table Designer when using an expression using derived feature values all language values of the derived value was used and not only the specific language used.
Example: @FormatValue(
{PassendesZubehör.Category.Value}
) - here all language values of localized feature Category were returned, now only the language value matching the current language used is returned.
Bugfix of Table Designer showing all localized multi values for specified language of a feature value and not only first value
The Table Designer only showed the first value of specified language of a localized multivalue. This has been corrected to show all values for specified language - as is done for non-localized multi values.
Perfion API now supports use of system date calculations
You can now, in the Perfion API, use system date variable calculations within clauses and update statements. You can now create an where clause like <Clause id='ProductValidUntil' operator='<' value='@@DATE+30d' /> which will find products that have a 'ProductVaildUntil' value less than today plus 30 days.
Better documentation on delete row/column/element in Perfion Table Designer
In Perfion Table Designer the pop-up menu item 'Delete' has been renamed to proper name 'Delete Element' as the command deletes a possible element inside the selected cell.
Furthermore the Perfion Table Designer manual has been updated with better description on Delete Row/Column in order to describe that split rows/columns cannot be deleted before they have been merged using the Merge command.
Proper Perfion table fixed width usage in reports
When a Perfion table is set to use fixed width - AutoWidth set to false - then proper fixed size set in Designer is now used.
Perfion table Url links clickable in reports
When a report contains a Perfion table with a feature value which is a link data type the url link is now clickable.
Bugfix of proper rowcount in API Query result window and Table Designer datasource result window
API Query result window and Table Designer datasource result window now contains rowount.
Bugfix to Table Designer feature list
Table Designer feature list keyword @LIST handling changed to exclude features having no values
Table Designer feature list keyword @FEATURES handling changed to allow list of name/ID in looked up feature value and to exclude features having no values
Table Designer feature list filtering of features having null value fixed to properly handle parent inheritance.
Support for empty multi-value parameters in reports
Release note title | Release note |
---|
Possibility to configure timeout for database maintenance scheduled task
Previously it was not possible to change the default value of 5 minutes for timeout on the database maintenance scheduled tasks for updating statistics and rebuilding indexes. It is now possible to configure the timeout ranging from 0 (no timeout) up to 24 hours. Default value has been changed to one hour.
Bugfix of allowing update of read-only feature in Perfion API
Allow update of read-only features in Perfion API (and Query Analyzer in Windows Client) as specified in the manual.
Bugfix of proper resolve of formula in API when multivalue used is not present in config used
In the API when a formula used a multivalue feature not present in the config the formula was not resolved ok due to multi values filtered away in fetch of data.
This has been fixed by always returning all multivalue features as for single value features.
Linebreaks in reports with Chinese characters
When using Chinese characters in a report, linebreaks could show differently in preview, print and export to PDF resulting in different rendered results. This has now been fixed so that linebreaks are the same.
Bugfix of not possible to deactivate a user
When the maximum number of users was reached, it was not possible to deactivate a user. Furthermore, it was impossible to edit a user without getting an error - an error occurred but pressing ok again saved the change.
This has been fixed.
Bugfix of possible to drag and drop on read-only feature
When drag and drop update is done a fix has been made to always check permissions - part of checking permissions is to check if the feature is read-only and prohibit this.
Cleanup of completed task operations could fail
An issue where the automatic cleanup of completed task operations in the scheduler could fail has been fixed. The issue was caused by an incorrect conversion of datetimes when the database was running in a non-English collation.
Fixes to Table Designer for specific customer problem of rendering report
Table Designer has two fixes for proper rendering of specific customer report. One is a small height alignment fix and another is usage of feature list where feature points to list of features to use - here it is possible to use two data sources in the table designer and have the feature list feature of one data source point to a list of features in another data source ensuring only features having value to be shown.
Fixed issue with showing links longer than 255 chars in grid
We fixed an issue where a link feature would show a red cross in grid if the length of the link was longer than 255 characters. This has now been fixed so links longer than 255 characters are shown correctly.
Bugfix of action command Perfion select to show correct inherited language value
When broken inheritance exists for a localized feature - i.e. a parent inherited value exists for one language and an item-specific value for another language - the proper inherited language value is fetched for action command Perfion select.
Actions - Joins on empty key fields
It is now possible to join on tables with empty cells in the key column
Use of ModifiedDate in Actions could result in an error.
The use and manipulation of an Item's ModifiedDate in Actions could result in an error related to IConvertible. This has now been fixed.
Bugfix of Table Designer not sorting values correctly when variants used
In Table Designer, an error could occur in rendering table if variants used
Fix to Table Designer for specific customer problem of rendering report
Table designer fix for proper row height compared to earlier versions of customer specific report.
Application Server crashed when running the AD Sync system task.
The Perfion Application Server could crash if you tried to run the 'Synchronize inactive Active Directory Users' system task. This has now been fixed.
Not possible to log in if AD integration settings are invalid.
If the AD integration settings were invalid, you could experience not being able to log on to the Windows client with local Perfion accounts. This has now been fixed.
Actions - Empty rows in Actions
An error is fixed, so it is possible to have empty rows in Actions
Dashboards - A bug in "Copy a dashboard" is fixed
It is now possible to copy a dashboard
Sending emails from Actions could fail when sent to multiple recipients.
Sending emails from Actions could fail when sending to multiple recipients, This has now been fixed.
Bugfix of staging compare button to be shown correctly
The staging compare button had disappeared when staging is used - this has been fixed.
Bugfix of disabling late-loading and paging in Query Analyzer
In Query Analyzer the grid result and the XML/JSON output not always was correct due to possible late-loading enabled or paging used as default. This has been fixed so both late-loading and paging have been disabled in the Query Analyzer.
After the disable using 'maxCount' query option now functions in Query Analyzer.
Main grid - Grid is jumping
In some cases, the main grid jumps to a random cell. This is fixed
Actions - Bug in Validate.FailItem()
An “Object reference not set to an instance of an object” Error in Validate.FailItem() is fixed
API update statement
An error in API updates is fixed if the API query selects zero rows
2022-R2-SR2 (5.1.5)
Release note title
Release note
Multi select in editor
The editor for multi selector keep focus when a Item is selected
Grid - Select all keep focused cell
When selecting all cells in Grid, the focused cell will not change.
Item Triggers - Performance and log filter
The Item Triggers Administration has been performance optimized and filters and sorting are added to the log window
Bugfix of multivalue rich editor not showing correct
When multivalue rich editor was invoked no rich editor browser was shown. This has been fixed.
German translations in Report Designer
An issue with missing German translations in the Report Designer has been fixed.
Actions - Wild card in Select mapping
The wild card mapping in Select should not overwrite mapping created in scripts.
Bugfix of sub-reports not showing images correct
When Perfion image control is used in a subreport the image is not shown.
This has been fixed so both Windows client view/preview report and Application Server view report functions.
Scheduler task Rebuild Database Indices fixed
The scheduler task Rebuild Database Indices was fixed not to throw the error which it did before the fix. After this fix the task should run correctly.
DateTime when using @@UTCNOW variable was calculated incorrectly
When using the @@UTCNOW variable in Perfion API queries, you could get incorrect results because the date/time was calculated incorrectly. This has been fixed.
Simple feature validation fix for decimal numbers
Simple feature validation was not working correctly when validation request was issued via Perfion API. This issue was fixed.
Actions - Multiple email address
It is now possible to add multiple email addresses in Actions.
Bugfix of Table Designer rendering robust towards unknown variants
In Table Designer when rendering cells and value has an expression it can happen that the expression value and the original feature value variants does not match due to expression value having unknown variant 'Expr'. A fix has been made to make the rendering robust towards this.
API query - Multivalue in an equal where clause
It is now possible to create API query with multivalue like:
Code Block |
---|
<Where>
<Clause id="Color" operator="=">
<Value>Black</Value>
<Value>Grey</Value>
</Clause>
</Where> |
Search and replace
Bug in search and replace has a bug and replace on all items. The bug is fixed.
Issue with running Perfion on Windows 11 with Swedish or Finnish language
An issue with running Perfion on Windows 11 has been fixed. When Windows was set to use e.g Swedish or Finnish languagepack, the Perfion application would not start correctly. This has now been fixed.
2022-R2-SR1 (5.1.4)
Release note title
Release note
Perfion 5.1.4 now also includes the NAV 2009 add-in
From Perfion 5.1.4 we have re-introduced the NAV 2009 add-in.
2022-R2-SR1 (5.1.3)
Release note title
Release note
OData connection string updates
OData connection string parser was replaced with a new one which allows handling more complex cases. The old parser did not allow using double quotes in connection string parameter values while the new one allows to do that.
In addition to the new parser there was also an update to OData connection string specifications when using BasicAuth type authentication. In the new version, one can specify the actual basic authentication token directly instead of defining user ID and password.
2022-R2-SR1 (5.1.2)
Release note title
Release note
Bugfix of Table Designer rendering robust towards variants with mixed case
In Table Designer when rendering cells and value has an expression it can happen that the expression value and the original feature value variants have different cases (e.g. feature value variant is 'en' and expression value variant is 'EN'). A fix has been made to make the rendering robust towards this.
Application Server configuration files updated
The configuration files for Application Server were updated to include necessary runtime dependency bindings which were missing and did not allow the server to run correctly.
User update related issues fixed
User creation and update had issues where Perfion would show an error related to Perfion license as a reason for error. The issue was related to user's Reader or Editor status handling and it was fixed.
Multi-factor authentication - Email server with without authentication
In the Multi-factor authentication it is now possible to use a mail server without authentication
EC API: FormatMultivalue did not working when , (comma) was used
Using "FormatMultiValue" to output multi values as one separated string failed when , (comma) was used as separator (or begin- or end-value). This has been fixed.
Actions - Execute Actions on Items
An Action can be executed on chosen Item in the Grid. See the Action manual for more inforamtions.
Report folders are sorted in grid's context menu
In Perfion grid context menu the reports were sorted alphabetically, but not the folders. This update also sorts the report folders alphabetically.
Could not store Tasks if not General-tab was selected
In previous versions of Perfion you could get an error when trying to store a Task without having the "General"-tab selected. This issue has been corrected.
Item Grid - Reports and Publications in right click menu
The reports and Publications are now cached and will only be reloaded is the Reports and Publications changed.
Permits returned in Features-section was wrong
When permits were included in a Perfion API call, the permits returned was wrong. For non-Super Users/Admins the permits were calculated and for Super User/Admins it was not (assuming full access). It should have been the other way around and has now been corrected. Permits returned in data were correct.
Image fixer tool added to Settings -> Support
There was added a new image fixing tool in Windows client under Settings -> Support. The tool will check all images in Perfion if there are any invalid and will fix them. The invalid image is such image which was uploaded using wrong file extension which does not match the actual image format. The tool will update file extension to match the actual image format and will regenerate image previews.
Action Execute Action list order fixed
Execute Action list order was changed to order actions alphabetically
Bugfix of Item Editor exception on selectable selection when item dependency used
When item dependency is used and special/rare case of item ID matching feature ID of selectable feature also used an exception could occur in Item Editor when the feature was selected.
This has been fixed.
Image conversion from CMYK to RGB
In some cases, the image conversion from CMYK to RGB removed some of the bark colors. A new conversion is used to perform the conversion.
Filter search with multiple values in an IN clause may fail
When doing a right-side search with multiple selected values in an IN clause, you may experience an error saying "_Incorrect syntax near the keyword 'AND'. Incorrect syntax near 'sub'_". This has been fixed.
Default selectable value handling fixed
One can use a selectable item in feature configuration as default value which is then automatically used when creating a new item data in Perfion. However, if selectable item as default value is defined, but later deleted from Perfion, then the default value is still used in Perfion as if it was not deleted. This issue was fixed so that when deleting the selectable items the default value would be automatically deleted as well.
Actions - Adding external libraries
It is not possible to add external libraries which have dependencies to other sub libraries. In some cases the upload of DLL files excepted.
Feature data import updated to correctly handle binary extensions
Feature data import was incorrectly importing binary file extensions with prefixed dot in the front of extension. The issue was related to binaries which are imported from a remote server when using URLs. This issue was fixed.
Order "left side" items keep focus
Ordering eg. Category at the left side keep focus
Actions - Select.Csv define datatypes
A new parameter @ColumnsType makes it possible to define which data type a column should be and then e.g. keep leading zeros
Bugfix of storing property 'Can Grow' on Multi column Rtf report control
Multi column Rtf report control has property 'Can Grow' which is partially controlled by property 'NumColumns' (when 'NumColumns' = 1 then 'Can Grow’can be true/false and when 'NumColumns' > 1 then 'Can Grow' can only be false).
It is now possible to store the property 'Can Grow' as true if NumColumns = 1.
View selector
Focus handling in the View selector is optimized
Asset Cloud StorageGUIInterface project migrated to .NET 6
The Asset Cloud GUI interface project has been migrated from .NET Core 3.1 to .NET 6. .NET Core 3.1 has end-of-life in december 2022.
Grid view - Focus handling
Focus handling in the Grid view is optimized
Error when saving Asset Cloud settings
When updating Asset Cloud settings in the Perfion Client, you could get a validation error if trying to save an empty value. This is now fixed, so that empty values now are allowed if the storage location is the local database.
Bugfix of pdf document shown in reports for multivalue file features
When a multivalue file feature had more than one pdf file as value no pdf file was shown.
Documentation specifies the first pdf file should be shown.
This has been fixed and requires API service update.
Bugfix of change of language specfic characters not being recognized in update of feature value
When using e.g. the german character eszett ß and changing the letter to the two chars ss then the change would not be recognized and the original character ß would be kept. This has been fixed so proper language specific character handling will be detected.
Item Editor updated to always open base feature
Item Editor could open base feature item for editing, but in some cases it was possible to open item editor item using feature which is inherited feature from the base feature which did not work correctly and would not show all the item data. This issue was fixed so that whenever inherited feature item editing is requested Perfion will open its base feature item instead.
Performance optimization of stage/compare functionality
Performance of the stage/compare functionality has been improved.
Could not apply Filter on Value if an invalid filter exist
Previously you could not apply a Filter on Value in the grid if an invalid filter existed. This has now been fixed.
Bugfix of index reports in publications getting proper output parameters
When publishing and the publish contains an index report using parameters the publish parameter values were not transferred to the index report - only the reports (superquery) default values were used.
This has been fixed so output parameters are transferred to the index report in same way as normal reports during publish.
DPI parameter on ImageServer will no longer resize images | Previously, the DPI parameter for the Perfion Image Server endpoint would resize the original image according to the requested DPI setting. Because of rounding issues related to conversion between pixels per centimeter and pixels per inch, the resulting DPI setting on images could be show unexpected results. We have changed the meaning of the DPI setting, from previously resizing the image to only being a metadata setting. It is now possible to request an image in a specific size and with a specific DPI setting. |
Error when using View Item Relations with more than three features selected for the Compact View. | If more than three features were selected for the Compact View, the Perfion Windows client would show an error when using View Item Relations. This has been fixed |
ParseNumber could return incorrect results when string contained multiple numbers | The ParseNumber scripting function in Actions could return incorrect results when string contained multiple numbers. An example would be 60 g/m2, where the expected result would be 60. This has been fixed. |
Whitespace in Remote Connection templates | Some of the Remote Connection templates contained incorrect white space characters between the property name and the equal sign. These has been removed. |
Remote Connections are now sorted by name | Previously Remote Connections did not have a particular order when shown in the Windows client. The connections are now sorted by name. |
Application Server running on 64bit operation systems | Previously, the Perfion Application Server was configured to prefer to run as a 32bit process. This has been updated so that it now runs as a 64bit process if possible. |
Empty error message if @CONTEXT parameter is invalid when using the WRITE.EXCEL command | If the Mode or Direction elements of the @CONTEXT parameter was invalid, Perfion would show an empty error message. This has been fixed so that a more meaningful message is shown. |
System Task for update license will now retry failed requests | Previously the 'Update License' system task, which by default checks for a new license every Sunday night, would only perform three consecutive retry attempts if the request failed. The task will now perform additional retries. |
Import of Actions could be slow, when overwriting existing Actions | When importing Actions in Perfion, in certain situations it could slow to remove existing Actions that should be re-imported. This has been optimized. |
2024-R1-SR2 (5.4.2)
Release note title | Release note |
---|---|
ECommerce API: Attributes can now be output from Multi-value features | It is now allowed to decorate multi value output with values coming from multi value features. That is useful when you want to output Images or Attachments with for example titles and captions. See more in documentation. |
ECommerce API: Fields holding multiple values can now be output individually | In previous versions of Perfion, features holding multiple values where, in the ECommerce API when mapped to a Field, output using sub-elements named Value:
Except when the multi value only held one value, where it would be output as an attribute named value:
Now you can use the method-parameter OutputMultiValueFieldsIndividually to output each value as a separate field. The parameter is supplied to fx. GetProducts like this:
And the result is now output with a separate Field-element per value, regardless of how many values there are (except if there are no values, in which case nothing is output):
|
Spanish UI language is added to the windows client | Spanish UI language is added to the windows client |
Application Server now utilizes fewer concurrent connections | We have optimized the way connections are used in the Application Server. In heavy load environments it could reach the default maximum allowed (which is 100 connections) causing jobs to fail with timeouts. |
Perfion Application Server now supports configurable logging | The Perfion Application Server now supports configuring logging via the application configuration file, to support logging to e.g. console or a file on the server running the application. |
Restore previous values from Log | It is now possible to restore previous values from the Log on Multi-selectable features without removing all other values in the multi feature. |
Modify and Delete buttons disabled for languages of users from AD with advanced setup | It will no longer be possible to Modify or Delete languages from users created from AD with an advanced setup, using context (right click) menu |
Actions - Moving groups and commands | It is now possible to move groups and commands to other action when the groups and commands is in a group. |
Actions - SystemVar in FROM and TO column | The SystemVar was missing support for the FROM and TO columns. |
Fixed problem with selecting base feature in filtered values when controlling feature is also selected | It will be now possible to change base feature when the controlling feature is also selected |
Removed warning before adding value for a field of a parent | There will no more warning before adding a value to a field that belongs to a parent |
Dashboard - Has/Has not values | Selecting a “Has value” in the dashboard chosen in some cases “Has no value” |
Fixed issue with channel deletion | Deletion of a channel from the web client will no longer end with an error |
Removed image/file url length limitation | Removed image/file url length limitation |
Upcoming runs of the schedule trigger will no longer be empty in some cases | Schedules with a date set far back in time will no longer display no upcoming runs. |
Query string moved from url to request body for saving search | Searches with long queries will no longer fail to save |
Execute Actions in context of an item | The Execute Action dialog picks up one item id per cell. This is changed so it only picks one per row. |
2024-R1-SR1 (5.4.1)
Release note title | Release note |
---|---|
Import of .psd files could fail when using URLs as image source | When running an import including binaries, Perfion could fail to import Adobe Photoshop files (.psd) when using URLs as image source. This has been fixed. |
Issue with Selectable Localizable value updates | Having a selectable, localizable and multi value feature, could sometimes end up, saving data incorrectly. |
Perfion Queries - Must have a <Query> element i root | The Perfion Queries Must have a <Query> element i root and e.g. From and Where elements at the first level after root. |
Got an error when trying to edit localizable base value in ItemEditor | If you edited the value for another language than the primary language, the ItemEditor would either not store the value on save or gave a null-value exception when entering the editor. This has been fixed. |
Supplier Portal shows any Expose Read Only-features when no Supplier Items are linked to a Standard Item | In previous versions of the Supplier Portal, it shows any Expose Read Only-features when no Supplier Items are linked to a Standard Item. That made sense in previous version of the Supplier Portal where two views only were used to get q query result. But it should have been dropped when it was made possible to query “any” feature/view in the Supplier Portal. This have been fixed, so that the “Expose Read Only”-features are no longer added when there are no linked items found. |
Export Report Data: Image quality picked was not taken into account | In the web client, when exporting report data, the user can choose from 3 image qualities (Low, Medium and High). In previous Perfion-versions, this choice was ignored by the Application Server. This has been fixed, so the picked quality is indeed taken into account. |
E Commerce API - Error messages | Added error message when the eCommerce Api is not licensed. |
Possible to set localized selectable number value when decimal separator is ',' | Previously it was not possible to set a localized selectable number value when decimal separator for windows user was ',' and when the value was empty. This has been fixed. |
Server Error processing HEAD requests for images | The Perfion Image Server could return a http status 500 (Internal Server Error) when handling HEAD requests for images. This has been fixed. |
Selecting 'Any Language' is only allowed on the Item Trigger definition | Previously, users incorrectly had the option to choose 'Any Language' when configuring Conditions and Activities for Item Triggers. This has been fixed, so that users no longer are presented with the option to select 'Any Language'. |
Supplier Portal search for readonly selectable value functions | Previously it was not possible to search for readonly selectable values in the Supplier Portal. This has been fixed. |
Importing images using Urls did not read filename from headers | When importing images using a Uri in the Import-file, images were not named according to Disposition Header Values. This has been fixed. |
API tester tool - Json formatter | The API tester tool will now format json results |
Calculation and application of Related Sort Order has been optimized | Previously, calculation and application of related sort order was slow on large categories of items. This has been optimized and will not perform better. |
'Widget Management' could show an error when closing the dialog. | The 'Widget Management' dialog could show an error when closing the dialog, if one or more widgets had multiple titles per language. This has been fixed. |
Perfion could fail to retrieve watermarked images during high load | Perfion could fail sometimes fail to retrieve images during high load. A fix has been implemented to allow for better concurrency of requests for images that are already cached. |
Feature validation on localized features | The Feature validation on localized features was only working on the main language. This is fixed so all localized values are validated. |
Proper usage of CSS settings for sub reports | When CSS settings was changed for a sub report the changes was not reflected in the rendering of rich editor feature values. This has been fixed. |
In Windows Client Filtered Values now functions using scene selector as pop-up selector in grid | If a Filtered Values filtered feature was setup as a scene selector (defined as a section) and the feature was edited in grid for an item the scene selector did not properly use the context of the item being updated. This has been fixed. |
Filtered Values import of configurations now functions when importing using ID | Filtered Values import of configurations did not function using ID import format. This has been fixed. |
Outputting related products using two (or more) different features would only output same relation once per product | In the ECommerce API, setting up two RelatedProduct-mappings from two different identity inheriting features and putting the same product “A” in both features, then “A” would only be output for the first mapping. Same issue was there for categories, but it is quite unusual to have more Related Categories. These two issues have been fixed. |
No error on selecting all data in grid and copy to clipboard | Previously when selecting all data with CTRL-A in grid and afterwards copying to clipboard with CTRL-C an error occurred. This has been fixed. |
Filtered Values - update/check whole chain of configurations on changes | When a chain of Filtered Values configurations exists the whole chain of configurations is now checked/updated upon changes. |
Sorting of feature within Feature configuration | Perfion supports sorting features within Feature configuration, but when trying to sort the changes was not correctly stored and thus users would not see the effect. This has been fixed. |
Export and import logs show duration for proper step | Previously the export and import logs shown in the Windows client where showing duration for the previous step. This has been fixed so the logs show duration for the correct step. |
Using keybord shortcut CTRL+ENTER in a multiline editor for search in grid does not insert new line | Previously when entering the keyboard shortcut CTRL+ENTER in a multiline editor in search in grid a new line was added. This has been fixed so the command does not insert a new line but only performs the search. |
Proper headers in grid with correct language specific unit | Headers in grid was not showing correct unit for other languages than the current users system language. Other languages showed the system language unit even though translations for other languages existed. This has been fixed. |
When copying a report the custom data xml is copied properly including xml schema | When copying a report the custom data was not properly copied as the xml schema information was missing. This has been fixed so schema information is stored as done for inserting new report and updating existing report. |
Possible to update selectable date value in grid | An error occurred when updating a selectable date value in grid. This has been fixed. |
Ordering of multi-value selectables was not correctly saved | If a user tried to re-order a multi-value selectable feature, the changes would not be identified and saved correctly. This has been fixed. |
Refresh of base feature in Feature Data before showing pop-up menu | Previously the pop-up menu in Feature Data was not showing based on newest base feature data. This has been fixed. |
Grid - Column width | The minimum column width fore booleans are increased. |
In grid blinking remote filtering warning changed to non-blinking | Previously when remote filtering was used a warning red blinking text 'remote filtering enabled' was present. This has been changed to non-blinking. |
Column Chooser in Windows Client shows all features if show all configured features chosen and no configuration exists | When choosing to show only configured features in Column Chooser not all features where shown if no configuration exists; e.g. related values where not shown. This has been fixed, so all is shown. |
In reports the visibility of a table designer component can now be toggled | Previously the visible checkmark for a table designer component in Reports did not function. This has been fixed so the visibility now can be toggled as for other report components. |
In Windows Client grid paging control - only possible to write numbers | Previously it was possible to write non-numbers in input field for number of records to fetch in one page for a grid. This has been fixed so only numbers can be entered. |
2024-R1 (5.4.0)
Release note title | Release note | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Action - Add Contains to ScriptVariable | It is now possible to use Contains on ScriptVariable like var.Contains( “@TestVar“ ). | ||||||||||
Action log messages was truncated to 200 characters | Previously any Action log messages would be truncated to 200 characters, potentially removing important context information from the messages. This has now been extended to max. 4000 characters instead. | ||||||||||
Actions - Execute.Script | The Execute.Script can use code parts from Perfion code base. The NameSpace available in actions is Perfion.Actions. Other NameSpaces are not available anymore to ensure backward compatibility. | ||||||||||
API Having clause includes Like and Match operator | It is now possible to use Like and Match in having clauses and in filters with Remotes/Related Values. | ||||||||||
Better support of SVG files | Perfion will convert any image format to a raster format to support generating different sizes previews and renditions via the ImageService. Previously, Perfion did not properly handle SVG files, resulting in the generated raster images being of too low quality. This has now been fixed. | ||||||||||
Branding feature has been removed from Perfion | Branding feature has been removed from Perfion. In case your installation has "Branded" items, these will be reckoned as normal items in this version. | ||||||||||
Column choose throws error on certain characters | In previous versions of Perfion the column chooser in the win-client would throw an error when typing certain special characters like ' (quote) and \ (backslash). This has been fixed. | ||||||||||
Concept for Environment Definitions added to settings | The Environment Definition make it possible to create and manage environments which is a prerequisite for e.g. storing individual connection strings for each environment. | ||||||||||
ConstructedFileName can now be output without fetching files | The ConstructedFileName is output as part Image- and Attachment-elements when the OutputKind is set to Image(File, '<some filename template>') or Attachment(File, '<some filename template>'). This also means, that a file named "<ConstructedFileName>" will be stored in a folder controlled by the Setting "OutputFolder". From this version of Perfion, you can get a ConstructedFileName without fetching and storing any file simply by Setting "OutputFolder" to blank. | ||||||||||
Copy Action in Perfion Windows Client | The Perfion Windows Client now supports copying an entire Action, including its definition. A new menu item 'Copy Action' is available in the right-click menu in the Actions section. | ||||||||||
Create Copy of item(s) in grid also copies unique selectable values | A fix has been made to copying items ensuring unique selectable values for an item are also copied. | ||||||||||
Database transaction isolation level changes | To minimize the amount of database locks used when reading and writing data to the database, Perfion now uses the Read Committed Snapshot feature of SQL Server. This is an optimistic locking mechanism, where SQL Server will take a copy of the data targeted for update, allowing other users to read the existing data without further locking. Note that the copy will, per default, be placed in the tempdb, so this change may result in more load and disk usage in the tempdb. | ||||||||||
DevExpress components updated to version 2023.1.6 | Perfion uses a third-party component library, DevExpress, for generating reports (amongst other things). This library has been updated to version 2023.1.6. | ||||||||||
Do not show hanging dropdown box in grid | When a localized selectable is updated in grid it was possible to get in a situation where the dropdown box was hanging in the grid. This has been fixed. | ||||||||||
Dynamics NAV Add-in - link features are clickable | In the Dynamics NAV Add-in it is now possible to click at a link feature and open a browser. | ||||||||||
eCommerce API configuration could contain incorrectly named 'Nice' view | When querying the eCommerce API configuration including the _Nice _view, the configuration would incorrectly contain a quotation mark after the name (_Nice"_). This has been fixed. | ||||||||||
Error parsing 'Ignore' column when importing Actions. | When importing Actions into Perfion, the import could fail to parse the value of the 'Ignore' column. This has been fixed. | ||||||||||
Error when using formulas including remotes | Perfion could in some cases show an error when trying to resolve formulas that includes remotes. It would typically happen when the remote did not return data for the rows in question. This has now been fixed. | ||||||||||
Export data from grid in same order as grid data order | Previously when exporting data from grid the exported data was in another order than the order of the data in grid. This has been fixed so data is exported in same order as data appears in grid. | ||||||||||
Feature Configuration - Default values and copy is allowed together | At Feature Configuration it is now possible to set Default values and copy at the same feature. | ||||||||||
Filtered Values supports multiple levels of configurations | It is now possible to make chains of Filtered Values configurations where controlling feature in one configuration can be filtered feature in another configuration. | ||||||||||
Global Search allows Match operator | A bug is fixed so Global Search can use Match operator | ||||||||||
Incorrect XML export of Actions | When exporting Actions in DataTable/XML format, the ignore column would be incorrectly exported as a string. This would lead to issues when trying to re-import the Actions. This has now been fixed. Ignore is now exported as a boolean. | ||||||||||
ISINVALID filter operator enabled in grid filter | The ISINVALID filter operator used in a Perfion query to get all items having invalid values of a feature was only enabled in the Perfion API. It is now enabled in grid filtering. | ||||||||||
Item Trigger Activity - system would incorrectly calculate days from now to be added | When using the Update value in 'Date feature' to '+- days' from now” trigger activity, the system would perform an incorrect calculation between minutes and days when editing the value. This has now been fixed. | ||||||||||
Item Triggers - Update Formula features | It is now possible to update Formula Features via Item Triggers. | ||||||||||
Mapping in SELECT.PERFION now supports '.childCount' | Previously mapping in the SELECT.PERFION Action command did not support mapping of .childCount. This has now been fixed. | ||||||||||
New API option | A new API option “IncludeVisibleChildCount” is added. This includes a ‘VisibleChildCount’ attribute value for each Item in the result-set, with the number of child items that have the Item as their parent and included in the result set. | ||||||||||
New scheduled system task for clean-up of binaries | Previously, administrators had to click the "Cleanup Binaries" button in the Settings dialog, to force Perfion to remove orphaned and other binaries marked for deletion. We have now introduced a new system task, enabling administrators to run binary clean-up on a schedule. | ||||||||||
New type "Conatant" added to Remote Connections | A new type “Constant” is added to the Remote Connections | ||||||||||
Open item-menu not available on multi-value selectables in Item Editor when value is inherited | When any feature value is inherited from its parent, it should be read only on the child. But users should still, on selectables, be able to "Open item" in the context menu of the control. In previous versions of Perfion that was not possible on multi-value selectables, but it has been fixed in this version. | ||||||||||
Perfion API IN statement with mere then about 10.000 elements | It is now possible to have many elements in a API IN statement. | ||||||||||
Perfion API: In-operator in clause now return empty result if not supplied at least one value | Using the IN-operator in Perfion now returns an empty result, if it is not supplied with at least one value. In previous versions of Perfion the clause throws error message. | ||||||||||
Perfion Client API now uses similar database connection string configuration as the Perfion API | Previous, the Perfion Client API used a database connection string configuration, based on appSettings. Instead, it now use a connectionString element, similar to the Perfion API configuration. | ||||||||||
Perfion XML API now supports inserting- and updating features to whitespace | Previously, when using the Perfion XML API for inserts and updates, users was not able to insert- or update feature values only containing whitespace characters (one or more spaces for instance). This has now been fixed. | ||||||||||
Possible to copy and paste images in Supplier Portal | When copying and pasting images in the Supplier Portal an error occurred. This has been fixed. | ||||||||||
Possible to show localized selectable values in grid and Item Editor | A new checkbox has been added to the grid language menu for enabling show of localized selectable values in same way as for explicit localized values. A new checkbox has also been added to the Item Editor for enabling show of localized selectable values for other languages than current user language. | ||||||||||
PTable-performance increased for Insert/Updates/Deletes | Optimized updating of data through PTable. The most significant performance increase will be seen when updating or inserting multiple values in the same Query. The performance of the Supplier Import will be increased similarly, since it relies on the PTable to update database. | ||||||||||
Report designer could show an “Invalid cast“ error in Formatting Rule Sheet Editor. | The Perfion Report designer could show an “Invalid cast from ‘System.Decimal’ to 'System.Drawing.Font'“ error message when working with the Formatting Rule Sheet Editor. This was caused by an error in the DevExpress component library Perfion uses. We have updated the DevExpress component library, fixing this issue. | ||||||||||
Restart Perfion required when updating current users languages | When a user changed own languages in 'Users and Groups' admin the users language list was not updated so e.g. Item Editor did not reflect the updated language list. The update of the users own languages list requires a restart of Perfion, so a mandatory restart of Perfion is now enforced. | ||||||||||
SELECT.ODATA could fail when reading more pages, due to invalid authentication | When using the SELECT.ODATA Action command, the command could fail to retrieve dataset that spanned multiple pages. The command would get a new authentication token for each subsequent call to the OData source, which could cause the server to not being able to correlate the requests and thus fail the request. | ||||||||||
SELECT.PERFION did not correctly support mapping of metadata on selectable formula features | When using SELECT.PERFION, attempting to map feature metadata (e.g. ID or ModifiedDate) on selectable formula features, users would get an error. This has been fixed. | ||||||||||
Shopware license now visible within License Management | Previously, the License Management overview would not show whether the license contained the Shopware Connector license option. This has been fixed. | ||||||||||
Supplier portal configuration | Categories in the Supplier Portal are displayed in a flat list. | ||||||||||
Supplier Portal search of read-only features | The Supplier Portal can now search on exposed read-only features when the search filter contains exposed read-only features. | ||||||||||
Support for EntraID guest accounts for logging into Perfion | Previously, Perfion incorrectly retrieved information about guest accounts in EntraID (previously Azure AD) leading to such users being unable to access Perfion through single-sign-on. This has now been fixed. | ||||||||||
Swap Relation Data can now be fetched for all features in configuration | Before this version of Perfion, the only way to fetch data for a Swap-relation-feature was to do the following:
This would fetch data for the Swap Relation Table (SRD in the following). You could include a view, and that would be used for fetching that specific relation:
Without a view only the base value for the MySrd-feature is fetched. Now two select-options have been added: Option 1:
This will make Perfion fetch SRD for all SRD-features in the Item-view for the configuration of the Product-feature. Note that this can be combined with the explicit select of individual SRD-features. Using the option to fetch SRD will always make Perfion use the Config-view when fetching SRD-features. Option 2: Adding this option will make the Perfion API fetch the same SRDs as it otherwise would (explicitly selected or selected from configuration using the option), but instead of outputting the data, it will only output a marker that indicates that the feature holds data for the specific item. Example: Instead of outputting the data as shown here:
this will be output instead:
If some item (here Product) does not hold any data on the SRD-feature, nothing will be output for it for that product. This is just as is the case for all other features in Perfion. | ||||||||||
The office add-in is deprecated | The office add-in is deprecated from 2024-R1 | ||||||||||
Timeout is now configurable on 'Delete old log entries' system task | Previously it was not possible to configure the database timeout on the 'Delete old log entries' system task. This is now possible. For existing tasks, the system will use a default value of 5 minutes. | ||||||||||
Using Filter dialog to add new filter now can handle ISINVALID operator together with id selection clause | When defining a new filter using the Filter dialog the filter handling would breakdown if id clause was specified using '_FeatureValidation' or '_FilteredValues' - e.g. using the WHERE clause '<Clause id='*._FeatureValidation' operator='ISINVALID'/>'. This has been fixed. | ||||||||||
Webkit - Report endpoint | The endpoint in Webkit is changed from /Perfion.Report?id={itemId}&reportid={reportId} to /Perfion/Report.ashx?id={itemId}&reportid={reportId} | ||||||||||
Wexo Shopware connector has been removed from Perfion license | Previously the Perfion license check included licensing of the Wexo Shopware connector. This meant that the "checkmark" had to be set within the Perfion license for this check to validate correctly. This requirement has been removed. The Wexo Shopware connector may now be licensed fully outside of Perfion. | ||||||||||
When copying a report template the rich editor styles and table designer styles are also copied | When copying a report template the rich editor styles and table designer styles where not copied to the new report template. This has been fixed. | ||||||||||
When defining a new supplier item the supplier identifier is always set | Previously the supplier handling did not ensure the supplier identifier was always set. This is enforced always now. | ||||||||||
When moving item to parent ensure Filtered Values are properly handled | A special corner case existed of item having a value for a controlled Filtered Values feature was not allowed to be moved to parent having both controlled and controlling feature values; i.e. the item value was not be used, both values are to be inherited from parent. This has been fixed. | ||||||||||
When using Simple AD integration, users were not required to be member of the Perfion AD group | When using Simple AD integration, users were not required to be member of the Perfion AD group that is meant to be used for restricting which users could logon to Perfion. This has been fixed. Users now needs to be member of the Perfion AD group to be able to successfully logon. | ||||||||||
Windows Client can now fully delete an Action | Previously, if a user deleted an Action in the Windows Client, the action definition (the items on the right side) was not correctly deleted. Instead, the items would be moved into the untagged category and had to be cleaned up separately. This has now been fixed. Deleting an Action will now correctly delete the entire definition. |