Version:
20222023-
R2-SR3R1 (5.
12.
70)
Release date: 2 March May 2023
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.
Actions: Execute in context. Execute action in context of item(s) in grid or categorizer.
Actions: FTP. It is now possible to use Actions with different variations of FTP.
OData: OData remotes now support services that only return minimal metadata.
Formulas: Formula expression features no longer needs to be part of query. Formula expressions can contain remotes and related values.
Watermarking: All endpoints will now apply watermarks according to configuration.
Active Directory Integration: Added “simple” integration option and Group prefix.
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
20222023-
R2-SR3R1 (5.
12.
70)
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.
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 |
|---|---|
NAV Add-In could fail to authenticate the user when using PerfionID | We have fixed an issue where the NAV add-in could fail to authenticate correctly when configured to use a Perfion username only. An error message would be shown, telling that the Index was out of Bounds, and the Add-in would not show the data as expected. |
2022-R2-SR3 (5.1.6)
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
Table Designer style setting update not clearing Translation settings | When editing and saving Table Designer style settings without switching to the Translation settings tab the Translation settings were cleared. This has been fixed so Translation settings are kept properly. |
OData remotes could fail to get all data when using paging | We have fixed an issue where an OData remote could fail to read all data from the remote system, when using paging. The issue was caused by the way that the '@odata.nextLink' was interpreted. This has now been fixed. |
Reports running action | Reports with action can now be executed via the API or the Application server. |
Proper auto adjustment of row height for large texts in Table Designer when row height used | Now large texts can be shown in Table Designer cells if no constraint on height - also when other rows have fixed row height; i.e. the cell height is auto-adjusted to show all text for rows having no constraint and not auto-adjusted for rows having fixed height when rows are in same table design. |
Incorrect file extension when exporting to Word format via ReportServer | When exporting a report to Word format via the ReportServer API, the file would be returned with a '.word' extension. This has now been fixed so that the file is returned via the correct '.docx' extension. |
Select Remove Variants support in JSON queries | Previously, you could only select specific remote variants via XML queries in the Perfion API. This has now been extended so you can also use JSON queries. |
Multi Factor Authentication logging | Some more logging added to the Multi Factor Authentication Email sending for error handling. |
Application server status icon change | The Application server status icon now reflects the last completed job, |
Action - Appearance order by name | The Action Appearance is ordered by name in the Execute Action menu |
Queries selecting clustered remotes failed if user had no read permit for them | Queries selecting clustered remotes failed to work, if the user executing the query had no read-permits to read it. This affected the Perfion API and the Web Client. This has been fixed. Furthermore Perfion has been optimized so that only remote features that the user has read-access to (according to the security group assigned to each remote) are read. |
Bugfix of validating formula in Formula Editor | When an invalid formula expression is inserted in the Formula Editor the Formula Editor could breakdown in an exception on both refresh formula in Formula Editor and when closing Formula Editor. This has been fixed so validation of formula expression is done as part of refreshing formula and as part of closing Formula Editor. |
Proper auto adjustment of row height for large texts in Table Designer | Now large texts can be shown in Table Designer cells if no constraint on height; i.e. the cell height is auto-adjusted to show all text. |
Filter Designer gave error when selecting a default value for selectable feature | In previous versions of Perfion you got an error when selecting default value for a selectable feature in the Filter Designer. This has been fixed. |
Bugfix of proper translation of Azerbaijan language | The culture info for the Azerbaijan language has been updated in the database so proper language code is sent to the translation service. Though the translation service DeepL does not support translation of Azerbaijan language - only Google Translate does. |
Proper translation for languages having special culture info | For languages having special/complex culureinfo (e.g. en-nz) wrong language code was sent to the translation service. This has been fixed so lookup of proper culture info language code is performed before sending to translation service. |
Bugfix in Filter Designer of ensuring proper caption of filter members | The caption shown for features in filter members in Filter Designer was sometimes in different language than current system user language. This has been fixed. |
Users with no delete right for a base feature were able to delete items of that type | The Perfion API allowed a user with no delete rights to some base feature to still delete items of that feature. The issue also affected the Web Client while the Windows Client worked. This issue is now fixed. |
NAV Add-In could fail to authenticate user when using PerfionID | We have fixed an issue where the NAV add-in could fail to authenticate correctly, when configured to use a Perfion username only. An error message would be shown, telling that the Index was out of Bounds, and the Add-in would not show the data as expected. |
Unique Values in import | It is now possible to import duplicate values and set the “Keep the first occurrence of records with duplicate keys” in Unique values features. |
Dashboard - Has Value shows also Has Not Value items | The Dashboard is only showing Items with values if a widget with “Has value” and Count is selected. |
Proper translation of norwegian culture language nynorsk | An error occurred if norwegian culture language nynorsk was chosen and DeepL was chosen as translation service. This has been fixed so translation is obtained - though the translation language used is bokmål as DeepL does not support nynorsk translations. |
Search Filter - Booleans can now filter on any type | Booleans in Search Filter can now filter on True, False, Neutral and Any. The old check box/slider is replaced with radio buttons |
Performance of database indexes | A few indexes have been changed for performance optimization: IX_Specs_SpecType_Item and IX_SpecsIX_ItemId_SpecType is dropped and IX_SpecsIX_ItemId_SpecType_Language is added. |
OData connections now correctly trim whitespace in URI | Previously an OData remote could fail to load data if the URI contained whitespace characters. This has now been fixed so that any whitespace is automatically trimmed before calling the endpoint. |
Optimization to cleanup of outdated jobs and job loggings | Due to performance/time-out problems in cleanup of outdated jobs and job loggings an optimization has been implemented. |
Support for bosnian language added | Support for bosnian language added. Requires db upgrade. |
OData remotes now also support JSON media type with minimal metadata | Previously OData remotes required the OData service to deliver full metadata descriptions in the responses. Some OData services are not capable of delivering this, which would cause the remotes to fail to load the data. This has now been fixed so that, when using JSON OData services, only minimal metadata are required. |
Item Trigger - New column in ActionImput and more info in the log | In the Item Trigger a new column ChangeType is added to the ActionInput table Coalesced and the Application Server mark actions as “Merged” if the actions is executed in the same action. |
Feature definition import error fixed | The feature definition import had an error when trying to import a new feature with enabled unique values property. This issue was fixed. |
Scheduler task name handling updated | The scheduler task name was limited in size, but the UI allowed to enter more characters than technically allowed. Therefore, part of the task name could be cut off when saving or editing the task. This issue was fixed by limiting the length of the task name to 100 characters in the UI. |
Actions - Executed via the Applications server | Actions executed via the Applications Server or triggered via Item Triggers are from 2023R1 executed by the user who ordered/triggered the action |
License management window updated | The license management window in Perfion did not allow to exit Perfion after an unsuccessful attempt of loading of Perfion license. After this update, the user will now have a choice to continue loading another license file, or to exit Perfion. |
Feature data import updated to validate key feature values | Feature data import uses simple feature validation rules to validate all incoming feature data which is configured to be validated, but the key feature values were excluded from this validation. Now validation will also be applied to the key feature. |
Richtext editor - reintroduce of paste as plain text | During latest update of the Richtext editor the button 'Paste as plain text' was removed. The functionality has been reintroduced - the current 'Paste' button can be toggled to paste with formatting (default) or paste as plain text (toggled using new 'Paste as text' toggle button). |
All Import logs can be viewed by users havning import permissions | Previously users having import permissions could only view import logs for their own import sessions. This has been changed so a user having import log permissions can view all import logs - though they can only stop their own import sessions. |
Message-column in Task- and Job-Log has been extended | The available number of characters in the message-column for both Task- and Job Log Entries were sometimes too small to hold the message. They have both been extended from 200 to 400 characters. In assistance the tables holding Task Log, Job Log and ActionsQueue Log have all been given a right click menu "Show in external editor...", which will open the clicked log entry in the default text editor. |
Media service multi-file ZIP download | Perfion media service was updated to support multi-file ZIP download. The new features:
|
Actions - SELECT.CSV and SELECT.FIXEDWIDTH file encoding | A new parameter @Encoding is added to the commands SELECT.CSV and SELECT.FIXEDWIDTH. It is now possible to define which encoding the commands should use. |
ECommerce API: GetConfiguration-response extended | The abbreviations and help texts are from now on being added to the GetConfiguration-response. |
New options to exclude feature definition from Perfion API query results | A new option _ExcludeFeatureDefinitions_ has been implemented in the Perfion API, to allow for more lean API results. Setting this option will exclude the feature definition element in the API response. Default is, as previously, that the feature definitions are included in the response. |
Perfion Query now supports querying all active languages | New wildcard designator '*' for languages is implemented for Perfion Query to query all active languages. |
Actions - Query with curly brackets and parameters | If a Query use parameters and curly brackets, the curly brackets need to be escape. Use double curly brackets like: <Clause id='*{{ID*' operator='=' value='*{=$Color}*' /> to escape the curly brackets. |
REST API - New endpoints for Execute Action and Get Version | Two new endpoints Execute Action and Get Version added to the REST API. |
User Admin - User roles | New Perfion Users is created without any roles, the administrator must add all the roles the user needs directly or by groups. Former a new Perfion User was created with 6 default roles. |
Simple Active Directory integration | Before it was only possible to handle membership in Active Directory(AD). |
Formulas works in grid, API and reports without used features being present | Formulas using features now can be used without the requirement previously of features used to be present; i.e. the formula features can be used without including features in query. |
Possible to set prefix for groups created in AD | It is now possible to set a custom prefix for the groups being created in Active Directory by Perfion. |
Perfion API supports remote feature columns using json | When using the json syntax in a Perfion API specifying columns for a remote feature was not supported. This can be used now. The returned column values are returned in a new json property called 'remoteValues'. Furthermore wildcard '*' can be used as column to specify all columns should be returned. Also a new query option 'expandClusterQueries' can be used to auto expand all clustered features in query to include all columns. |
Remotes and related values can now be used in formulas | The handling of formulas have been extended with support for remotes and related values in formula expressions. |
Watermarked image handling updated in media services (breaking change) | The watermarked image service will only serve watermarked images. Before, it was serving watermarked images conditionally based on watermark range parameter. |
Memory leak in Perfion Application Server | The Perfion Application Server could seem to leak memory when using script tasks within Actions. This has now been fixed. |
Perfion API Service no longer require .NET 3.5 | The dependency on .NET Framework 3.5 has been removed. It is no longer necessary to install the .NET 3.5 runtime on the servers running the Perfion API services. |
Actions - new FTP commands and option for binary stream in soem SELECT and WRITE commands | Four new commands for FTP (FTP.DOWNLOAD, FTP.UPLOAD, FTP.DELETE and FTP.FILELIST ) is added to Actions. The FTP commands support: File transfer protocol (FTP), File transfer protocol secure (FTPS) and Secure shell file transfer protocol (SFTP). The download command return a PBinaryStream which now can be used directly with e.g. SELECT.EXCEL. The upload takes an PBinaryStream from e.g. WRITE.EXCEL and upload this to the FTP server. WRITE.EXCEL can now generate PBinaryStream directly from the command. See the documentation for more information. |
Feature Definition - Remote query field is disabled | In some cases, the Remote field was not correctly enabled. This was fixed. |
Actions - Write Excel, Csv and fixed width files | A new parameter @WriteFileIfInputIsEmpty is added to the commands Write.Excel, Write.Csv and Write.FixedWidth. If the input to the commands is empty, the parameter can control if you would like to write an empty file or not. |
Feature Definition - Key feature | The Remote Features in the drop down list of Key Features is removed. |
Number of Channels in license is now checked for | Maximum number of channels in license is now checked whenever inserting a new channel. If number of channels is exceeded, Perfion will refuse to insert a new channel. |
Use of Perfion API now requires correct license | The use of the Perfion API, including the eCommerce API, now require that the license include these options as enabled. |
Perfion Office Add-in now supports authentication to Perfion API | Previously, the Perfion Office Add-in did not support proper authentication with the Perfion API. This meant that the Add-in would fail to connect, if the API was configured to require authentication. This has now been fixed so that it's possible to configure the connection including a username and password. |