QPR ProcessAnalyzer Release Notes: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
(551 intermediate revisions by 5 users not shown)
Line 1: Line 1:
This page contains new features and fixed issues for each QPR ProcessAnalyzer release.
This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.
 
== Next Release: QPR ProcessAnalyzer 2024.4 (planned release date 2024-05-14) ==
 
'''Features:'''
* B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.
 
'''Fixed issues:'''
* D-14084: Filter rule for first/last event in case couldn't be edited if there were more than one event selected.
* D-14091: Duration multi-unit didn't work in big data chart.
* D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
* D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
* D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed.
* D-14096: Highcharts tooltip square icons were slightly misaliged.
* D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
* D-14099: There was a console warnings when opening the business calendar dialog.
* D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
* D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
* D-14107: Snowflake model that has earlier been in-memory model showed case count and estimated memory incorrectly.
 
== Latest Release: QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04) ==
 
'''Features:'''
* B-08024: [[Design_Diagram|Design diagram]] has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
* B-08242: Script based [[Actions_to_Run_Script_in_Table|actions]] can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
* B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
* B-08288: Added expression language functions to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Start|start and stop]] scripts.
* B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
* B-07906: Implemented cross joins to SQL dataframes.
* B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
* B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
* B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
* B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
* B-03047: Removed support for dashboard panels.
* B-08214: Removed unused columns from the PA_VIEW table.
* B-08254: Frontend components have been updated.
* B-08255: Backend components have been updated.
* B-08233: Language translations have been updated to 2024.3.
 
'''Fixed issues:'''
* D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
* D-14035: In design diagram, BPMN event and gateway symbols are now circular.
* D-14049: Added some missing translations for table column filter and BPMN editor.
* D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
* D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
* D-13976: Fixed issue where gateway-based imports were not synchronous.
* D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
* D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
* D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
* D-14071: Business calendar button press caused error when user didn't have access to any model.
* D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
* D-11268: There were inconsistent button colors in Workspace.
* D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
* D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
* D-14081: Fixed null references error when logging null in expression script.
 
== Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27) ==
 
'''Features:'''
 
* B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.
 
'''Fixed issues:'''
 
* D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.
 
== QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21) ==


== Next Release: QPR ProcessAnalyzer 2023.1 (planned release date 2023-02-07) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be used by SQL scripts (in --#GetAnalysis command), and needs to be changed to use the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). Note that the removal of these analyses don't affect the functionality in the QPR ProcessAnalyzer web UI.
Known issue: Snowflake models and dashboards don't work with Viewer and Analyzer role permisions. The reason is that cache tables created to Snowflake incorrectly require the write permissions. Workaround is to give users the Designer role which will give the needed permissions. Note that the Designer role gives many permissions to the user for the project [[Roles_and_Permissions#Roles_and_Permissions|(more information)]]. This issue has been fixed in the next release (D-14045).
</div>


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<pre>
The legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|Models.Filters]] and [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property.
let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;scr.code?.Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Starting from QPR ProcessAnalyzer 2023.1, the '''.NET Desktop Runtime''' is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ProcessAnalyzer ScriptLauncher, ''.NET Desktop Runtime'' is not needed, but instead install the '''.NET Runtime''' (which is more lightweight). ''.NET Desktop Runtime'' contains the ''.NET Runtime'', so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.
New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).
</div>
</div>


'''Features:'''
'''Features:'''
* B-06997: Expression-based filter rules for Snowflake to allow versatile filtering.
* B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
* B-07383: Improvements to linked settings and on-screen settings.
* B-08232: Entire future eventlogs can be [[Create_Predicted_Eventlog|predicted]] based on generative AI models running in Snowflake.
* B-07623: Expression language function random and hash (in-memory).
* B-08166: Added expression language function [[Generic_Functions_in_QPR_ProcessAnalyzer#OpenAIChatCompletion|OpenAIChatCompletion]] to answer natural language prompts based on OpenAI ChatGPT API.
* B-07595: WeekOfYear property for DateTime in expression language to get the week number of a year (between 1 and 53).
* B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
* B-07538: Backend support: Snowflake-based root causes analysis can find event attribute related root causes.
* B-08196: Conditional formatting rules can be defined for [[QPR_ProcessAnalyzer_Table#Textual_equal_rules_for_background_color|textual and boolean values]].
* B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, Duration.
* B-08213: Big data chart expressions event type selections to be multi-select where applicable.
* B-07228: Remove deprecated analyses (Cases, Events, EventTypes)
* B-08205: Expression language API is available for storing [[Storing_Secrets_for_Scripts|secrets]] for scripts.
* B-07598: Refactor client-side import for SQL scripting to use generic client-side task mechanism
* B-07780: Chart [[QPR_ProcessAnalyzer_Chart#Variable_mappings|variable mappings]] has been removed - use the [[Chart_Linked_Settings|linked settings]] instead. Dashboards using variable mappings are automatically converted to use linked settings.
* B-07652: Make it possible to pipe multi-line expression strings to ScriptLauncher
* B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
* B-07706: SqlExpressionValue filter rules support for roots with Where function
* B-08174: Only non-default parameters values are written to the operation log.
* B-08200: Timestamps in System reports are shown in user workstation local time.
* B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
* B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
* B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
* B-08202: Updated copyright for year 2024.
* B-08199: Frontend components have been updated.
* B-08203: Backend components have been updated.
* B-08209: Translations updated for release 2024.2.


'''Fixed issues:'''
'''Fixed issues:'''
* D-13092: Table conditional formatting didn't work when color code was fetched from other column.
* D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
* D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
* D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
* D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
* D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
* D-12939: Script editor tabs Close buttons didn't work.
* D-13962: System variable values were interpreted incorrectly when used in linked settings.
* D-13154: "Search by case ID" didn't work in in-memory chart.
* D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
* D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
* D-13959: Removed possibility to add datatable columns with the legacy "any" data type.
* D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
* D-13991: Improved drop-down selector component to handle empty strings as variable values.
* D-12928: Pivot table headers were empty when there were two column levels and two values.
* D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
* D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
* D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
* D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
* D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
* D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
* D-13960: Added missing translations for list of permission list and 12-hour clock format.
* D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
* D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
* D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
* D-13969: Datatable column schema export sometimes showed empty for the key column.
* D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
* D-13862: Session token was not accepted when url path capitalization is different.
* D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
* D-13942: Datatable could not be dimensioned if it has column named "CaseId".
* D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
* D-13980: Business calendar dialog crashed when tried to open it for a model without access.
* D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
* D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
* D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
* D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
* D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
* D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
* D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
* D-13977: Multi-select dropdown lists showed some special characters incorrectly.
* D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
* D-13945: Syncfusion toast message didn't work when text contains ${[]}.
* D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
* D-13930: Pivot table throws javascript error when certain clicks.
* D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
* D-13273: Duplicate datatable row count didn't shown correctly.
* D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
* D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
* D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
* D-13985: Models list dots menu had texts misaligned in narrow screens.
* D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
* D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
* D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
* D-13997: Workspace tables column filtering search caused JavaScript errors.
* D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
* D-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
* D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
* D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
* D-12937: Added maximum value limitation to several number input fields in charts.
* D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
* D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
* D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
* D-12948: Defining column setting caused error when Measure Expression was not defined.
* D-14004: Removed empty filters from queries to optimize them.
* D-12946: Filter rule text couldn't be seen entirely from tooltip.
* D-13988: Fixed issue where data grid context menu rendered initially as too high.
* D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
* D-13979: BPMN model editor element settings use now Open Sans font.
* D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
* D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
* D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
* D-13984: Fixed the error of refusing to run the JavaScript URL.
* D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
* D-14031: ThrownObject property was not included to http error response when error came from the script.
* D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
 
* D-13116: BPMN editor had some translations missing.
== QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10) ==
* D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
* D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
* D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
* D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
* D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
* D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
* D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
* D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
* D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.


== Latest Release: Additional release for QPR ProcessAnalyzer 2022.8 (build 1397) (released 2023-01-11) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release fixes an issue where extracting large datasets from SAP increases memory consumption considerably and may lead to out-of-memory error. This release contains packages for both QPR ScriptLauncher and QPR ProcessAnalyzer Server. If SAP extractions are done using QPR ScriptLauncher in client side mode (ExecuteInClientSide=1), it's enough to update QPR ScriptLauncher to fix this issue.
Known issue fixed in QPR ProcessAnalyzer 2024.2: In Big data chart, some measures, dimensions and columns have the filtering option missing. The issue concerns for example Duration between events, Path starting/until between specific events, and Cases where event occurs before other selections. Workaround is to set the filter in the chart json settings: the filter can be configured to another expression and copied to the correct expression.
</div>
</div>


'''Fixed issues:'''
* D-12941: Extracting data from SAP consumed unnecessary lot of memory and may have led to out-of-memory error (both when running using QPR ScriptLauncher and in server side).
== QPR ProcessAnalyzer 2022.8 (build 1396) (released 2022-12-30) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Creating datatables with duplicate names in the same project is prevented, and possible existing duplicate names are automatically changed to unique names with a random suffix. If there are duplicate names, they can be renamed either before updating QPR ProcessAnalyzer (to avoid automatic renaming) or after the update (by changing suffixed names). If the renamed datatables are used by models, the linkage will break because it's based on the datatable name. Creating duplicate datatables has already been prevented in the UI, but the improved method works also in the API level.
QPR ProcessAnalyzer Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime ([[Updating_QPR_ProcessAnalyzer_Server|see more]]). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.
 
Following SQL query can be used to list datatables (and project id) having duplicate names:
SELECT ITA_NAME, ITA_PROJECT_ID
FROM PA_INTEGRATION_TABLE
GROUP BY ITA_NAME, ITA_PROJECT_ID
HAVING Count(*) > 1
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
If trying to use business calendar for a model that doesn't have the business calendar defined, there will now be an error message instead of showing the chart. Either unselect the business calendar checkbox for the measure or dimension, or define a business calendar to the model. In this situation in earlier releases the business calendar was ignored and full time calculation used.
In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.
</div>
</div>


'''Features:'''
'''Features:'''
* B-07498: Automation and Operational Excellence presets and Root causes analysis (for Snowflake), Weighted root causes analysis and Event scattering preset (for Snowflake and in-memory), Root causes for case duration (in-memory).
* B-08019: New component [[Design_Diagram|Design Diagram]] for showing user-created diagrams in dashboards where to visualize process mining metrics.
* B-07177: Flexible mappings, user selectable aggregations and conditional formatting for Pivot table, and flexible mappings for KPI Card.
* B-08087: Generic [[Dropdown_List_Selector|dropdown list selector]] works with Snowflake models allowing to add selection lists for any values.
* B-07518: New function named Query to run call /api/expression/query.
* B-08163: Linked settings support for binding to [[Chart_Linked_Settings#Binding_to_case_attribute_filters_with_attribute_name_and_attribute_values|case attribute filter values without defining case attribute name]].
* B-07294: In Workspace, the left side projects hierarchy can be collapsed and expanded to make more space to project contents.
* B-08170: Snowflake model filters can be [[Filtering_in_QPR_ProcessAnalyzer#Filter_actions|saved as new models]] which can be used to create snapshots of part of models.
* B-06814: In SQL expressions, new function DurationBetweenDates to calculate duration between timestamps precisely.
* B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
* B-07519: Replaced DateDiff function with the new DurationBetweenDates function in big data chart.
* B-08161: Added [[Datatable_in_Expression_Language#Modify|Modify]] function to change datatable properties and improved [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#CreateDatatable|CreateDatatable]] function for creating datatables.
* B-07531: In SQL expressions, new mathematical functions Abs, Log, Mod, Power, Rand, Sign and Sqrt.
* B-08122: Added new system report to list dashboards.
* B-07297: To optimize performance, Snowflake queries are automatically cancelled if they are not needed by UI.
* B-08173: Removed legacy filters that didn't have any filter rules.
* B-07569: To optimize performance, TakeSample function implementation is improved for Snowflake.
* B-07961: In OperationLog, changed parameters to json format and added request id.
* B-07198: Several performance improvements to DataFrame queries (used in Snowflake).
* B-08069: Added DashboardId property to [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog]] in expression language.
* B-07464: Added Lead and Lag functions to SqlDataFrames to support getting previous and next event.
* B-08139: Added [[Datatable_in_Expression_Language#UpdateRows|UpdateRows]] function to update existing rows in datatables with similar logic than SQL update.
* B-07470: New ExtractSap function to fetch data from SAP using expression language.
* B-08115: Added [[Datatable_in_Expression_Language#DeleteRows|DeleteRows]] function to delete rows in datatables with similar logic than SQL delete.
* B-07536: New Pivot function to SqlDataFrames to enable root causes analysis.
* B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
* B-07488: Primary keys can be set to datatables to improve calculation performance (UI will follow later).
* B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
* B-07515: Added RootCauseAnalysis function to SqlDataFrames.
* B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
* B-07546: RootCauseAnalysis function support for complex weighting expressions.
* B-07689: For datatables, [[Datatable_in_Expression_Language#ForeignKeys|foreign keys]] to other datatables can be defined using expression language.
* B-03052: Support for user-defined variables in /api/expression/query.
* B-08176: Translation updates for release 2024.1.
* B-07565: Support for NumberPrecision, DatetimeTruncation and TimespanPrecision properties for Values section in in-memory query.
* B-08175: Workspace should show timestamps in user's local time.
* B-07513: For product activation file handling, replaced mutex based implementation with exclusive file lock.
* B-07480: Expression language support for DataFlows for data extraction.
* B-07613: Removed support for SQL Server based R scripting.
* B-07567: Take datatable primary keys into use in expression builder to improve performance (part 2).
* B-07588: Remove total memory information from log writing and DateDiff function for in-memory.


'''Fixed issues:'''
'''Fixed issues:'''
* D-12715: Snowflake calculated imprecisely some operations containing division and aggregation.
* D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
* D-12761: Progress bar of the CSV import dialog didn't show any progress.
* D-13916: Chart filter could not be defined for some expressions in Big data chart.
* D-12799: Opening datatable contents dialog settings was slow when there were lot of rows in the datatable.
* D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
* D-12089: Include conforming/nonconforming cases made BPMN editor no responding.
* D-13906: In Conformance Analysis, deviating flows were not translated.
* D-12496: Datagrid filter search keyword didn't work for rounded values, so the search was hidden for other than textual data.
* D-13907: Improved translation related to datatable properties dialog "Used by models" field.
* D-12704: Durations as quarters was calculated incorrectly in charts.
* D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
* D-12662: Fixed issue where some special literals in custom expressions didn't work.
* D-13911: Fixed small glitches in the opening and closing of drop-down lists.
* D-12403: Setting Notifications on a model had some visual issues.
* D-13918: Datatable could be configured incorrectly to use table for other datatable.
* D-12859: Dependency wheel visualization crashed with nulls values in From and To mappings.
* D-13932: Duplicating datatable with custom table in datasource losed all data.
* D-12660: Removed unnecessary float conversions in SQL expressions.
* D-11002: Removed legacy in-memory prediction preset.
* D-12653: In-memory datafram OrderByColumns function with mixed values failed.
* D-13912: Added check that array cannot be stored to dashboard Content property.
* D-12657: When trying to use milliseconds period in some presets, frontend frozed.
* D-13936: Query designer default query didn't work with Snowflake models.
* D-12706: Line breaks in data were shown in many places where it's undesired.
* D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
* D-12719: Syncfusion dialog headers showed backslaces incorrectly.
* D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
* D-12372: Refused to run the JavaScript URL because it violated the Content Security Policy directive.
* D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
* D-12730: Logging out when filter selection is in progress, gave javascript error.
* D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.
* D-12705: Header object counts tooltip was sometimes messed after logout.
 
* D-12384: Selected project was not highlighted for whole project name string.
== QPR ProcessAnalyzer 2023.7 (build 4326) (released 2023-11-28) ==
* D-12581: Prevented creating duplicate datatable names in same project in parallel execution.
* D-12722: There was incorrect syntax near '<' when running SqlDataFrame expressions.
* D-12736: Swedish and Finnish translation improvements for object counter tooltips.
* D-12702: For BPMN Editor component "Something went wrong" error was given when switching from in-memory to Snowflake model.
* D-12712: UI gave error: TypeError: Cannot read properties of undefined (reading 'id').
* D-12738: Business calendar showed total business time when calendar configuration was invalid.
* D-12776: Special character filter caused JavaScript SyntaxError.
* D-12785: Unnecessary vertical scrollbar displayed for main header toolbar.
* D-12164: There was unnecessary UnauthorizedAccess errors in logs.
* D-12580: Case duration was not same when comparing Big data chart with in-memory chart for same data.
* D-12768: Data grid links and variable change actions didn't work when grouping was used.
* D-12735: FindRootCauses (in-memory) function filtered out cases with zero contribution.
* D-12763: --#CallWebService didn't work from ScriptLauncher.
* D-12789: There was timeout in SQL queries to scripting sandbox.


== QPR ProcessAnalyzer 2022.7 (build 1331) (released 2022-11-15) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Starting from QPR ProcessAnalyzer 2022.7, to improve security expression language operations that modify data or connect to external datasources are prevented in dashboard custom expressions. The limitation is required, because when a dashboard is opened, its expressions are run with the user's permissions, and the user need to trust the expressions don't perform any unexpected operations, such as delete data. The full functionality of the expression language is available in the scripts and in the Expression Designer.
Limitation for the maximum amount of data (B-07636) causes a behavior change in in-memory charts that have the Maximum rows settings empty and have the sorting defined. In certain cases, the order in which measures are evaluated changes (due to an internal performance optimization). If there are custom expressions that define variables, the variables may not be available in other measures anymore. As a resolution, either redefine the variables in those measure expressions or add those measures secondarily to the sorting.
</div>


The following functions and operations are prevented in dashboards: SendEmail(), CallWebService(), ImportOdbc(), ImportOdbcSecure(), Model.DeletePermanently(), Model.Restore(), Model.TriggerNotifications(), Project.DeletePermanently(), Project.Restore(), Project.CreateDatatable(), Datatable.AddColumn(), Datatable.DeletePermanently(), Datatable.Import(), Datatable.Merge(), Datatable.RemoveColumns(), Datatable.RenameColumns(), Datatable.Truncate(), RecycleBin.DeletePermanently(), and call SQL script. Calling expression scripts is allowed, but in the script all previously mentioned operations are prevented.
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Default query timeout of 30 minutes has been added for --#ImportOdbcQuery, --#ImportSqlQuery and --#ImportOleDbQuery commands. If a query run is taking longer than the timeout, the query is stopped. The timeout can be adjusted using the '''QueryExecutionTimeout''' parameter. Previously, there has been no timeout, so queries that take more than 30 minutes require configuring a longer timeout.
</div>


Following SQL query can be executed in the QPR ProcessAnalyzer metadata database to reveal dashboards that potentially have prevented expressions:
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
SELECT * FROM [PA_UI_ELEMENT] WHERE [UIE_PROPERTIES] LIKE '%SendEmail(%' OR [UIE_PROPERTIES] LIKE '%CallWebService(%' OR [UIE_PROPERTIES] LIKE '%ImportOdbc(%' OR [UIE_PROPERTIES] LIKE '%ImportOdbcSecure(%' OR [UIE_PROPERTIES] LIKE '%DeletePermanently(%' OR [UIE_PROPERTIES] LIKE '%Restore(%' OR [UIE_PROPERTIES] LIKE '%TriggerNotifications(%' OR [UIE_PROPERTIES] LIKE '%CreateDatatable(%' OR [UIE_PROPERTIES] LIKE '%AddColumn(%' OR [UIE_PROPERTIES] LIKE '%DeletePermanently(%' OR [UIE_PROPERTIES] LIKE '%Import(%' OR [UIE_PROPERTIES] LIKE '%Merge(%' OR [UIE_PROPERTIES] LIKE '%RemoveColumns(%' OR [UIE_PROPERTIES] LIKE '%RenameColumns(%'
Incorrectly configured [[Chart_Linked_Settings|linked settings]] in charts (available in the ''Advanced'' tab) give now an error message, if they are referring to non-existing measures, dimensions or columns. Previously, incorrect linked settings were ignored. To fix the error message, remove the incorrect linked settings.
</div>
</div>


'''Features:'''
'''Features:'''
* B-07287: Process Discovery and most important presets for Snowflake.
* B-07511: Datatables have a [[Datatable_Properties_Dialog|dialog]] to view datatable properties, write description, set the Snowflake source table, add/modify/delete columns, and set the datatable key.
* B-07271: "Last Row Aggregates Over-limit Rows" setting for big data chart.
* B-08150: Added setting [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters first]] to determine whether chart filter rules or dashboard filter rules are applied first when chart queries are filtered.
* B-06431: Snowflake datatables support for database views in the datasource.
* B-08091: When filtering charts in Snowflake, case attribute filter is created instead of case id filter.
* B-07266: Security: "limited mode" to prevent data modifications and external calls from dashboard expressions.
* B-08091: [[QPR_ProcessAnalyzer_Chart#Filtering_Settings|New setting]] to define whether cases or events are filtered by default.
* B-07097: Improved flowchart root causes color scales.
* B-08091: New preset "Looping paths" to detect whether there are repeating patterns of events.
* B-07363: SQL LIKE function support for escape character.
* B-08091: Duration between events calculation ignores negative durations in Snowflake.
* B-06877: Improved variation queries performance in Snowflake, part 1.
* B-08091: Chart loading animation has been renewed.
* B-07444: Improved variation queries performance in Snowflake, part 2.
* B-07636: To prevent dashboards from jamming when querying too much data, added [[QPR_ProcessAnalyzer_Chart#Available_Visualizations|limitations]] to the amount of data that charts can visualize. Note that the limitation concerns the aggregated data that is visualized, not the source event log data.
* B-07382: Support for empty strings and nulls in event type names in dataframe processing.
* B-08017: [[Dashboard_in_Expression_Language|Dashboards API]] has been added to expression language, allowing to create, modify and delete dashboards in scripts.
* B-07273: WithRowNumberColumn, WithRankColumn, WithDenseRankColumn support for descending sorting.
* B-08056: Following properties have been added to [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#User.2FGroup|user objects]] in expression language: IsLocked, LastLockedDate, LastLoginDate.
* B-07303: FindRootCauses function support for weighting expression.
* B-08053: [[Navigation_Menu#System_Reports|User rights report]] has been refactored to use [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property in the expression language. The change also simplifies the report as now it only shows the direct role assignments that are visible in the [[Manage_Users_and_Groups|User Management]].
* B-07327: Unpivot function for SqlDataFrames (for root cause analysis).
* B-08151: For Snowflake expressions support for following [[SQL_Expressions#Window_functions|windowing functions]]: sum, average, median, min, and max.
* B-07385: Align token lifetime with SESSION_MAXIMUM_DURATION setting.
* B-08050: When a model is created, the default filter is not created anymore (this is a refactoring that doesn't have any impact on user interface).
* B-07500: ColumnMappings property for IDataFrame and DataTables.
* B-08123: Translation updates for 2023.7.
* B-07499: IDataFrame.ApplyFilter function to filter events data using a JSON-based filter.
* B-08092: Updated backend components.
* B-07469: Translation updates for release 2022.7.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11630: Drag and drop from chart settings to main header was working incorrectly for filter and root cause rules.
* D-13876: In CreateSnowflakeConnection function, ProjectId parameter is optional when OdbcConnectionStringKey is not specified.
* D-12455: Moving a chart filter from one chart to another created a root cause analysis filter.
* D-13898: Snowflake: Exclude case attribute filter didn't work when there was null values and was selecting at least two values.
* D-12266: Root causes analysis showed incorrect results when certain combination of filters.
* D-13890: Fixed XES file import to work.
* D-12525: Numerical values in Excel export in data grid was formatted incorrectly.
* D-13894: Business calendar based duration calculation was incorrect in some durations that spanned to several weeks (for Snowflake and in-memory models).
* D-12534: Restoring item from recycle bin changed project from Bin to previous project.
* D-13899: Using broken OdbcConnectionString in a datatable prevented the datatable from being deleted.
* D-12529: Measure specific datalabel mapping did not work correctly when also mapped to Y-axis.
* D-13883: Script run stucked after running a script with error that uses client-side ODBC import.
* D-12532: Multi-selection options caused layout issue for Chart setting.
* D-13879: SqlExpressionValue filter when excluding events didn't work with filter rule root expression only.
* D-12541: Layout issue for Polish in multiselect list search dialog.
* D-13896: Adding or removing columns to datatable didn't change the LastModifiedDate.
* D-11277: Increase/decrease Icons were missing in the dimension sorting for Mac.
* D-13882: User details weren't written to operation log when creating or modifying users.
* D-12552: Uncaught Error: Diagram.selectCollection given something that is not a Part: null.
* D-13771: User rights system report didn't give error when changing columns.
* D-12567: Tooltip incorrectly showed for label component containing only spaces.
* D-13893: Some event filtering caused null pointer error when primary key had been defined.
* D-12438: Operation was cancelled because it was replaced by a new operation.
* D-13873: Fixed pivot table visual issues after component update.
* D-12551: Some expressions didn't work as calculated case/event attributes.
* D-13900: When adding, renaming or removing columns for Snowflake table fails, operation is now rolled back without any changes.
* D-11720: Chart buttons were not visible in Apple Safari and iPad.
* D-13866: Querying GET api/uielements was quite slow right after server start.
* D-12544: On-screen settings "options" parameter did not work.
* D-13864: Combinations of translatable and hardcoded strings didn't get translated in UI.
* D-12528: Multi-unit time unit selection appeared where it's not applicable.
 
* D-12583: Error message should be provided for invalid settings input  than just  display JS errors.
== Additional release for QPR ProcessAnalyzer 2023.6 (build 3933) (released 2023-10-24) ==
* D-12599: Tooltips didn't show correct measures/dimensions when "Show in tooltip" mappings are used.
* D-12561: Chart settings content was incorrectly drawn outside of the chart dialog.
* D-12568: Reload UI sometimes crashed chart having multiselect on-screen settings.
* D-12572: Main header toolbar lost when refresh maximized PA chart.
* D-12612: Drop Unused Filters After setting incorrectly allowed zero seconds.
* D-12533: Error message keeped blinking in Analysis view.
* D-12608: User could not select or add new case attribute when current select attribute doesn't exist.
* D-12451: Prevented deleting running script.
* D-12516: Windows event viewer warning: Failed to gracefully shutdown application.
* D-12523: Business calendar performance - part 2.
* D-12538: Column with same name could be added multiple times to datatable using expression language.
* D-12582: Improved EMS mutex code to support multiple PA service in one server.
* D-12624: Synchronize new (empty) data table generated failed queries in Snowflake.
* D-12622: Advanced setting page reserved room for the expression editor frame that did not exist.
* D-11295: In on-screen settings, some UI controls were vertically misaligned.
* D-11625: The heights of the parameter option menu in the clustering tab was not well aligned.
* D-12103: Small dropdown list layout issue.
* D-12633: Align issue for Column related Advanced settings.
* D-12505: Search dialog didn't escape % and _ characters correctly in dataframe processing.
* D-12645: Tabs in expression settings dialog were partly hidden when dialog is narrow.
* D-11382: Moving of flowchart was sometimes shaky.
* D-12655: Filter rule tooltips in header were styled incorrectly.
* D-12656: Large integer values in filter jsons were incorrectly presented as small integers.
* D-12661: Some exported filters contained unnecessary "invert" property.
* D-12500: Model with numeric case id's and filtering with the attribute mapped as case id: ERROR [22018] Numeric value <nowiki>''</nowiki> is not recognized.
* D-12509: Filtering null values didn't work in boolean attributes in Snowflake.
* D-12571: In dataframe processing in SQL Server, dividing two integers should not make rounding to integer.
* D-12610: Setting for global DropUnusedFiltersAfter was missing.
* D-12613: Filtering with case/event attributes with null values didn't match in Snowflake models.
* D-12617: Model didn't work when DropUnusedFiltersAfter is 00:00:00.
* D-12618: If model ConfigurationJson is null, Configuration property didn't work.
* D-12620: Filtering didn't work when there are backslaces in attribute names in Snowflake models.
* D-12643: AttributeFunctionCallExpression did not always work properly in array context.
* D-12647: SqlDataFrame with SQL Server: Comparing literals to variant column values failed.
* D-12648: Models that have DropUnusedModelsAfter setting caused "The sliding expiration value must be positive" error.
* D-11526: It was unable to translate Unicode character \uD83D at index 176 to specified code page.
* D-12637: In application startup arised FATAL Application startup exception System.UnauthorizedAccessException: Access to the path 'Global\MutexQPRPAActivation' is denied.


== Additional release for QPR ProcessAnalyzer 2022.6 (build 1262) (released 2022-10-19) ==
'''Features:'''
* B-08055: Error message for locked account has been replaced with generic error message, so that username enumeration is not possible.
 
'''Fixed issues:'''
* D-13884: Attributes dialog crashed with some older model configurations.
* D-13843: In charts, selected case and event attributes switched away when attribute data type was ShortString.
* D-13877: Some Snowflake expressions gave error "exceeds maximum length limit of 255 characters" when selecting lot of items.
* D-13878: Snowflake expression filters for case attribute values didn't accept other than string type of case attributes.
* D-13871: Some statistical calculations with percentages didn't work with Last Row Aggregates Over-limit Rows setting.
* D-13875: Using some case level filters in a model without cases datatable didn't work.
* D-13861: Dashboard opens are now logged to the Task log (i.e., calling GET /api/dashboards/{dashboardid}).
* D-13870: Workspace projects hierarchy focused project showed light grey background making the project name not readable.
* D-13867: When starting datatable refresh and going to other tab, went back to Datatables tab when query completed.
* D-13853: If chart Custom Layout settings had extra series defined, chart may have crashed.
* D-13869: Export as CSV button didn't work in the datatable contents dialog when dialog was still loading.
* D-13872: Main progress spinner had unnecessary small scrollbar on top right.
* D-13863: In the REST API method GET /api/users, password field (that has always been null) has been removed.
 
== QPR ProcessAnalyzer 2023.6 (build 3847) (released 2023-10-17) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
This release contains fixes to following major issues:
Big data chart support of models with local datatables (i.e., SQL Server stored) is removed in this release. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).
* Older QPR ScriptLauncher versions (<=2022.5) don't work with this release, when using the client side import. As a workaround, if updating to QPR ProcessAnalyzer 2022.6, also update QPR ScriptLauncher. Hotfix will be released to recover the backwards compatibility.
* When pressing the Add measure/Add dimension button in the chart settings, the chart settings dialog stop working. The workaround is to add the new measure/dimension to the bottom and use the Move up button to get the desired order of measures/dimensions. This issue will also be fixed in the hotfix.
* ETL scripts run using QPR ScriptLauncher in the client side import mode don't work if there is an import operation taking more than 10 minutes. This is because during the import, QPR ScriptLauncher erroneusly doesn't send the heartbeats to QPR ProcessAnalyzer Server, which then stops the script, believing QPR ScriptLauncher has stopped working. This issue occurs in all QPR ScriptLauncher versions. This issue will be fixed to QPR ProcessAnalyzer Server in the hotfix (i.e., no need to update ScriptLauncher).
</div>
</div>
'''Features:'''
* B-07992: Added 10 new presets including Queue analysis, Four eyes principle, Self-looping events, and Path until selected event. There are also presets for Individual Cases Flow and Range of event type occurrences which use Gantt chart.
* B-08011: Added following date related operations for Snowflake: Day of year, Day of month, Day of week, Week of year, Half-year only, Quarter only, Month only, Hours only, Minutes only, Seconds only, and Milliseconds only. These are available when calculating with date type of data.
* B-08016: [[QPR_ProcessAnalyzer_Table#Table_actions|Table actions to set variables]] can also be opened to a new browser tab. Also improved user interface for table actions.
* B-08018: For Snowflake expressions, added Flows aggregations FromEventType and ToEventType to get starting/ending event type, and FlowOccurrences aggregations FromEvent and ToEvent to get starting/ending event.
* B-08001: Added [[Generic_Functions_in_QPR_ProcessAnalyzer#CallStoredProcedure|CallStoredProcedure]] function to call Snowflake stored procedures. This allows to start ETL transformation in Snowflake orchestrated by QPR ProcessAnalyzer script.
* B-08013: Added [[Generic_Properties_in_Expression_Language#RoleAssignments|RoleAssignments]] property to expression language to replace the legacy UserPermissions analysis (11).
* B-07976: Snowflake [[Filtering_in_QPR_ProcessAnalyzer_Queries#Expression|expression based filter rules]] support additional expression columns allowing more Big data chart expressions to be filterable.
* B-08015: Big data chart doesn't anymore support calculation in SQL Server (using local datatables).
* B-06270: Improved error messages and made them translatable by taking into use exception codes provided by server.
* B-08021: Added possibility to store [[Diagram_in_Expression_Language|designed diagrams]] for models and expression language API for reading and modifying diagrams.
* B-08037: Dropped following unused tables database: PA_IDEA, PA_IDEA_VOTE, PA_REPORT, PA_REPORT_SETTING, PA_SESSION_SERVICE, PA_VIEW_FILTER_RULE, PA_VIEW_FILTER_RULE_PARAMETER.
* B-08052: Language translations have been updated to 2023.6.
* B-08051: Frontend side components have been updated.
* B-08034: Backend side components have been updated.


'''Fixed issues:'''
'''Fixed issues:'''
* D-12586: Scripts using client-side import with older version of QPR ScriptLauncher didn't work.
* D-13830: Object counts indicator in header showed incorrect counts when there was disabled filter rules in Snowflake models.
* D-12597: QPR ScriptLauncher was not sending heartbeats during import, which might have stopped the script prematurely.
* D-13833: In-memory charts didn't work with boolean type of dimensions when filtering with the false value.
* D-12589: Pressing Add measure/Add dimension button crashed chart.
* D-13858: Target value measures didn't update chart when controlled using an on-screen setting.
* D-12558: In chart settings, setting expression to "(none)" gave error.
* D-13827: Calculated attributes data type was incorrectly set as Any by the Attributes dialog.
* D-13849: Multiselect list search didn't allow spaces.
* D-13829: Multiselect dropdown lists height jumped couple of pixels when selecting values.
* D-13835: Deselecting a selected data point didn't remove chart filter rule.
* D-13702: Improved Snowflake query performance in situations when there are lot of filter rules (by decreasing number of CTE's).
* D-13819: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
* D-13820: Fixed incorrect manifest.json file to avoid "not found" errors when fetching web site icon.
* D-13865: Break, continue, and return statements didn't work properly when called from inside a catch block.
* D-13795: There was a Python error in clustering analysis with Snowflake model.
* D-13823: Some tooltips in Workspace project hierarchy didn't work and caused a JavaScript error.
* D-13824: BPMN editor align context menu layout looked strange.
* D-13813: QPR logo button in the top left was misaligned in Firefox.
* D-13797: Snowflake query may have given following error when using sampling: ambiguous column name '_EventType_NotNull_1'.
* D-13774: TakeSample function with certain columns caused SQL compilation error: ambiguous column name 'Case Name'.
* D-13782: Snowflake: Aggregating from variations didn't work when using sampling.
* D-13836: Some tooltips had a strange two-colored background.
* D-13834: Removed Model statistics column from clustering and root causes analysis.
* D-13860: Removed filter button from the custom expressions in Task log analyzed objects.
* D-13838: Removed Split data by filtering column from clustering analysis.
* D-13832: Script and model status updates incorrectly sent next update when previous was still pending.
* D-13839: Charts reset zoom button font size was too small.
* D-13817: Importing data to Snowflake datatable with Append=0 doesn't now drop the underlying Snowflake table.
* D-13825: Some models could not have been deleted from recycle bin.
* D-13852: Recycle bin Projects and Models tab didn't show correct content when Recycle bin only contained either models or projects.
* D-13841: In-memory chart Data type selection type has been corrected to string.
* D-13842: Second time and Third time selections has been hidden in in-memory chart measures.
* D-13850: In Chrome, there were console errors related in incorrect text field autocomplete type and text field without form.
* D-13847: Improved browser side performance by removing unnecessary operations.
* D-13859: Chart without dimensions showed an unnecessary Remove dimension button.
* D-12598: When script is stopped in server, ScriptLauncher could still incorrectly continue to import data.


== QPR ProcessAnalyzer 2022.6 (build 1259) (released 2022-10-05) ==
== Additional release for QPR ProcessAnalyzer 2023.5 (build 3334) (released 2023-09-07) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Fixed issues:'''
QPR ProcessAnalyzer Server and QPR ScriptLauncher use now .NET 6 (instead of legacy .NET Framework). The hardware requirements are same, but the .NET 6 Runtime needs to be installed to machines running QPR ProcessAnalyzer Server and QPR ScriptLauncher. See more on the [[Updating_QPR_ProcessAnalyzer_Server|updating QPR ProcessAnalyzer]] instructions. Note that the IIS deployment script is not available anymore. QPR ScriptLauncher update is not mandatory (i.e., .Net Framework based QPR ScriptLauncher works with the .Net 6 based QPR ProcessAnalyzer Server), but update is recommended due to bug fixes made to the QPR ScriptLauncher.
* D-13826: Measures or dimensions with case or event attribute and value selections incorrectly removed calculated attributes when dashboard was opened or chart settings were changed.
</div>
* D-13821: Font size of some Highcharts tooltips was too small. Issue appeared when there were tooltips mappings in measures or dimensions.
* D-13810: Simplified help links: now all Help buttons go to the QPR ProcessAnalyzer wiki main page.
* D-13822: Snowflake clustering analysis showed empty strings and nulls as case attribute values in an unclear way as just nothing.
 
== QPR ProcessAnalyzer 2023.5 (build 3304) (released 2023-09-05) ==


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following legacy analyses have been removed: Flowchart (analysis number: 0), Variations (8), Duration (9), Profiling (10), and Flows (13). This functionality may have been used in the SQL scripts. Note that this change doesn't affect the functionality available in the QPR ProcessAnalyzer web UI.
In Big Data Chart, the '''Case conformance''' measure and dimension has changed in a way that now it provides boolean values (true/false) instead of integer values (1/0). If [[Measure,_Dimension_and_Column_Settings#Other_settings|colorMappings]] are used for this measure or dimension to set specific colors to visualize conformant and nonconformant cases, the mapped values need to be changed as follows: '''1''' -> '''true''' and '''0''' -> '''false'''. Without the change, the mapped colors are not effective.


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts in the system that likely use the removed analyses:
Exmaple: Old configuration:
<pre>
"colorMappings": {
  "1": "#36d475ff",
  "0": "#f5403bff"
}
</pre>
New configuration:
<pre>
<pre>
let removedAnalyses = Flatten([0,8,9,10,13].(["'AnalysisType','" + _ + "')", "'AnalysisType', '" + _ + "')"]));
"colorMappings": {
OrderByDescending(Flatten(Projects.Scripts).Where({
  "true": "#36d475ff",
   let scr = _;Sum(removedAnalyses.{let num=_;scr.code?.Contains(num)})>0;
   "false": "#f5403bff"
}),LastRunStart).(Project.Name + ": " + name + " (last run: " + (LastRunStart ?? "N/A") + ")");
}
</pre>
</pre>
</div>
</div>


'''Features:'''
* B-06524: Search dialog for finding and selecting multi-select items.
* B-07173: CSV file importing supports date columns for row matching.
* B-07277: Query timeout for dashboards.
* B-06921: Expression language: For loop.
* B-07307: Expression language: DataTable.Synchronize().
* B-07288: SQL expression functions ToLower and ToUpper.
* B-07335: Expression language: Datatable.NameInDataSource-property.
* B-07336: ScriptLauncher client side import heartbeat.
* B-07176: Dataframe queries run in SQL Server are stopped when operation is cancelled.
* B-06986: Support for AggregateOthers setting in dataframe processing.
* B-07342: Improved validation for dashboard import.
* B-07267: Support for Comparison parameter in SQLExpression filter rule.
* B-06533: Timeout to /api/expression/query.
* B-07208: Remove deprecated analyses (part 2).
* B-07295: Frontend components update.
* B-07290: Translation updates for release 2022.6.
* B-07326: .NET 6 migration merge.
* B-07398: Improvements to PA service log writing during client-side import.
'''Fixed issues:'''
* D-12098: Attribute function worked incorrectly inside Switch statement.
* D-12491: Case filter was not shown in header if case id column is integer.
* D-12535: Variables disappeared when going to other dashboard.
* D-12480: ScriptLauncher client side import stucked without error.
* D-12501: Snowflake model gave error: ERROR [42P13] Invalid argument types for function 'SUM': (BOOLEAN).
* D-12112: Added validation for allowed values of standard context variables.
* D-12470: Truncating datatable made it unreadable.
* D-12383: Chart settings export options didn't change when visualization is changed.
* D-11424: Multiselect dropdown lists were shown partly out of screen in smaller screens.
* D-12270: Old version Big data chart didn't show correct error message.
* D-12471: Expression query windowing didn't take Criteria parameter into account.
* D-12461: Several datagrid column menus were incorrectly visible at the same time.
* D-12430: Dashboard gave error: Uncaught SyntaxError occurred: Invalid or unexpected token  at new Function (<anonymous>).
* D-12436: When query specific mapping was used, variations indicate flow that didn't exist in flows query.
* D-12432: SqlExpressionValue filter rule using Datediff function didn't work.
* D-12393: Expression generated with "Show Expression" in query designer did not support column role mappings.
* D-11272: Measure/Dimension/Column settings icon was changed to be more understandable.
* D-12416: Some UI strings were not translated properly.
* D-12153: Removed logging when defining functions.
* D-12485: Business calendar performance issue - part 1.
* D-12537: Variables didn't work in PA opening url when SAML is in use.
* D-12506: Root Analysis gave error "Operations that change non-concurrent collections must have exclude access".
== QPR ProcessAnalyzer 2022.5 (build 1179) (released 2022-08-24) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Datatables can be stored to a separate SQL Server database, i.e., the datatables are not anymore created to the QPR ProcessAnalyzer metadata database. This improves performance as data intensive operations are isolated from metadata operations. To take the feature into use, create a new database in SQL Server and set the [[PA_Configuration_database_table#General_Settings|SqlServerConnectionString]] setting in the configuration table to connect to that database. When the configuration has been made, all new datatables are created to the datatables database. Pre-existing datatables are still located in the metadata database. To get the pre-existing datatables to the new database, they need to be recreated, which can be done by creating a duplicate of the datatable. Support for the metadata database stored datatables is continued, but deprecating the support in future will be considered.
Big data chart support of models with local datatables (i.e., SQL Server stored) is deprecated. Big data chart has allowed to process data both in Snowflake and SQL Server. Now the support for SQL Server is deprecated and the Big data chart will only support calculation in Snowflake. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following legacy analyses have been removed: Variations Chart (analysis number: 1), Event Types Chart (4), Models (17), Model Report (21), Project Report (22), Datatable Report (23), and Script Report (24). To replace these analyses, use the corresponding native functionality in the expression language.
Following legacy analyses have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). The OperationLog analysis is replaced by the [[Generic_Properties_in_Expression_Language#OperationLog|OperationLog function]] and the Infcluencers analysis is replaced by the [[FindRootCauses_Function|FindRootCauses function]].


Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts in the system that likely use the removed analyses:
Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
<pre>
<pre>
let removedAnalyses = Flatten([1,4,17,21,22,23,24].(["'AnalysisType','" + _ + "')", "'AnalysisType', '" + _ + "')"]));
let removedAnalyses = [12, 14, 15, 16, 29];
OrderByDescending(Flatten(Projects.Scripts).Where({
OrderByDescending(Flatten(Projects.Scripts).Where({
   let scr = _;Sum(removedAnalyses.{let num=_;scr.code?.Contains(num)})>0;
   let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (last run: " + (LastRunStart ?? "N/A") + ")");
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</pre>
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Security hardening instructions to set the [[QPR_ProcessAnalyzer_Security_Hardening#Add_Security_Related_HTTP_Headers_in_IIS|Content-Security-Policy]] http header, has changed. In addition, the '''img-src''' directive includes also '''blob:''' urls (this allows to export Highcharts charts).
By default, Snowflake ODBC driver generates quite much logging to files which might unnecessarily fill up the disk space. It's recommended to set the LogLevel parameter to value 0. The path where the logs are created can be seen in Windows registry (key LogPath). More information about configuring Snowflake ODBC parameters: https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters.
</div>
</div>


'''Features:'''
'''Features:'''
* B-06898: In Snowflake models, events can be filtered based on event attribute values.
* B-07971: Machine learning based [[Clustering_Analysis|Clustering analysis]] can be run in Snowflake.
* B-06996: In Snowflake models, event type mapping can be defined for each chart.
* B-07989: In dashboard designer the stacking order of charts can be changed with buttons [[QPR_ProcessAnalyzer_Dashboard_Designer#Viewing_and_Editing_Dashboards|Bring to front, Send to back, Bring forward and Send backward]].
* B-07069: Datatables can be stored to separate SQL Server database to reduce load from metadata database.
* B-07977: For [[Sankey_Chart|sankey diagram]], added Start level and End level mappings to define custom start and end level for the sankey flows. Implemented also color mappings to define specific colors for specific values.
* B-06525: In dashboard editor, the background alignment grid is now better visible with any background color.
* B-08010: To improve performance, charts are loaded and updated only when they are visible in the dashboard.
* B-06844: In script editor, the script status is automatic refreshed.
* B-07975: Added following [[SQL_Expressions#Date_functions|date related functions]] to Snowflake: DayOfYear, DayOfWeek, WeekOfYear, Quarter.
* B-06643: Links in header changed, e.g., the eLearning library link.
* B-07908: When [[QPR_ProcessAnalyzer_Project_Workspace#Duplicating_Model|model is duplicated]], also filters in the model are also duplicated.
* B-06981: Chart settings remember the last opened tab, and the settings are always for the active chart.
* B-07904: Filters and models API for expression language has been completed.
* B-06467: Added SelectDistinct function for dataframes for selecting distinct rows.
* B-07991: In [[Filter_Selectors|case and event type filter selectors]], threshold whether the dropdown list or search dialog is shown can be defined using the ''Maximum Rows'' setting. Also the search dialog filters search results by other filter rules in the dashboard.
* B-06933: Added "Like" function to SQL expressions for string pattern matching.
* B-07999: Filters report has been changed to use the [[QPR_ProcessAnalyzer_Objects_in_Expression_Language#Filter|expression language API for filters]].
* B-06543: Generic Eval function for evaluating an expression given in a string.
* B-07540: Added [[QPR_ProcessAnalyzer_Expressions#Throwing_objects|throw statement]] to expression language.
* B-06944: Truncate function to efficiently delete all rows from datatable.
* B-07813: UI components are updated. There are small visual improvements, such as in flowchart flows are routed a bit differently and in charts the hidden series is shown as strike-through in the legend.
* B-07207: Access to properties CreatedBy, LastModifiedBy and LastImportBy for datatables using expression language.
* B-07963: Following legacy analysis types have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29) (see more information in the note above).
* B-06906: Added Configuration property to Model and Datatable objects to get configuration json as dictionary.
* B-07170: Added ScriptByName and ModelByName functions for project objects and changed behavior for DatatableByName function.
* B-06919: Expression language: Increment (++) and decrement (--) operators.
* B-06829: UI remembers the user's last selected model in next login.
* B-07000: Workspace Models and Scripts tab auto-refresh has been optimized for performance.
* B-06456: Changed icons in chart Visualization selection.
* B-07175: Removed deprecated analyses.
* B-07205: Replaced Scripts analysis (24) with expression language property.
* B-06813: Pacm file support case and event attribute data types.
* B-06907: Define start row for the returned data in dataframe processing.
* B-06879: NumberPrecision and DatetimeTruncation support for dataframe queries Values columns.
* B-06998: Implemented referrer policy HTTP header.
* B-06936: Prevented using outdated caches in dataframe processing.
* B-07066: Snowflake queries has been optimized by removing unnecessary metadata queries.
* B-06900: Backend support for expression filter rules to dataframe processing.
* B-06987: Add caching for Project objects.
* B-06910: Frontend components have been updated.
* B-07117: Translation updates for release 2022.5.


'''Fixed issues:'''
'''Fixed issues:'''
* D-12075: DashboardFilter variable rules were applied in incorrect order.
* D-13777: Filters could not be created in charts when "Update Filter During Selection" setting was disabled.
* D-12351: Pivot table columns headers had unnecessary prefix when there are multiple measures and no dimensions in columns.
* D-13767: Automation per Event Types preset in in-memory incorrectly showed only one event type.
* D-11946: Content security policy violation occurred when exporting Highcharts charts as images.
* D-13756: Changing background color in KPI card didn't have any effect.
* D-12064: Chart pending query was incorrectly cancelled when going to and from Add component mode.
* D-13812: "Exclude events" was incorrectly translated to "Exclure les cas" in French.
* D-11606: Scripts and Projects tab slightly covered the top borderline of workspace datagrid and entire grid was not visible.
* D-13815: Dashboard designer background grid was not visible in entire area in edit mode. Improved also the grid to match to snapping in move and resize.
* D-12389: When using AggregateFrom, filters were always applied on the completely unfiltered set of events even if a "top level" filter existed also.
* D-13674: Business calendar dialog layout was incorrect when a model with a long name was selected to copy holidays.
* D-12324: The visibility stepper counter didn't follow changed variations.
* D-13811: Table actions link to a new window didn't go to dashboard if there were other parameters in the link.
* D-12373: CSV import may have failed when there are line breaks in strings.
* D-13601: Fixed issue where some presets may have given error when attribute value selection and the automatically selected attribute conflicted by the data type.
* D-12045: Column filter was not cleared when user switched to other view in Recycle bin.
* D-13753: While Snowflake model was selected, in Filters and User Rights reports the Columns list could not be opened.
* D-11590: Two context menus were visible at the same time.
* D-13720: Now table column filter and sorting are preserved when resizing or zooming page.
* D-11131: It was not possible to move data grid column Custom filter dialog.
* D-13785: In tables increased number of rows to 20000 that are inspected to get available items shown in Excel-style column filter.
* D-11401: For datatables filter popup menu was opened outside visible dialog and required more scrolling to be seen.
* D-13759: Some statistical calculations had bad performance with large number of rows.
* D-11650: In Workspace, sub context menu for target projects to move items didn't open with latest Syncfusion.
* D-13787: Conformance statistics component didn't have scrollbars when text didn't fit to the visible area.
* D-11651: Multiselect list lost some items when using search.
* D-13788: In-memory "Nonconformance reason" selection caused error when two of them was selected in the same chart.
* D-11657: Combobox autofill was broken.
* D-13783: When Analyzed objects was Generic analysis, column selection incorrectly caused "Analysis has not been selected" error.
* D-11639: User's default model did not behave as it should.
* D-13776: When measure name contained quotation mark, notification preview didn't work.
* D-12085: Filter rules in header were lost when pressing F5.
* D-13747: Filtering with integer type of case id with case attribute value filter caused error in Snowflake.
* D-12142: KPI card value is now visible for non-numeric values.
* D-13791: In Firefox, model selection in chart settings didn't show models in the first open.
* D-12105: Nullable object must have value error displayed  when trying to open Enhanced BPMN dashboard.
* D-11984: Recycle bin buttons didn't fit to the screen when screen width was small.
* D-12157: Root causes analysis in the Conformance Root Causes Analysis didn't work.
* D-13780: Using CaseId case attribute in clustering analysis did not work with Snowflake 106 cases standard model.
* D-12067: Some tooltips, e.g., in BPMN button, didn't disappear at all.
* D-13781: Clustering analysis produced Python error with a certain simple Snowflake model.
* D-12069: User got querying variation error when first time created big data flowchart.
* D-13730: Snowflake: Case attribute filtering didn't work when there are cases without row in cases table.
* D-12177: In models list, search and cancel icons were vertically misaligned.
* D-13803: There was chart configuration validation error in browser console when measures were moved into dimensions in Big data chart.
* D-12116: Add and delete filter rule from Create Filter dialogue did not work.
* D-13758: There was performance issue with the Recent tasks system preset.
* D-11445: When using very large value for border corner roundness, chart settings were not visible.
* D-13793: Snowflake clustering failed when cluster count is larger than case count.
* D-12166: External content presentation object was broken due to too strict content security policy.
* D-13763: SQL expression based filter rule with Where function to filter events didn't filter anything in Snowflake.
* D-12151: KPI card incorrectly showed error "Measure data type needs to be numeric" when numerical measure has null value.
* D-13804: Added missing Millisecond function to Snowflake.
* D-12150: Event data column named "Case ID" mapping to both Case ID and Event Type caused error "An item with the same key has already been added".
* D-13772: Expression EventLog.Cases.Events caused error "Value cannot be null".
* D-12325: Workspace root level had too many New items in context menu.
* D-13755: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
* D-12326: Wrong menu displayed for sub projects if first click create new option for root level from project tree view.
* D-13739: When switching between System reports there was error: "Uncaught Error: 2nd dimension not found. at y.getExpressionConfiguration".
* D-12000: Script log system report default time interval was too long making report very slow.
* D-12109: Sometimes flowcharts showed message "Error in querying event type measures. Input string was not in a correct format".
* D-12119: Uncaught (in promise) TypeError occured: Cannot set properties of undefined (setting 'isAnimate').
* D-12473: Cost Savings by Automation preset gave sometimes error "Unable to cast object of type 'System.Double' to type 'System.String'".
* D-12293: "Cannot read properties of undefined (reading 'id') at o.checkTabNames" error occured.
* D-13750: Snowflake model didn't work with the Case Duration vs. Manual Activities preset.
* D-12294: Term ID was incorrectly translated.
* D-13657: There was error converting data type nvarchar to bigint.
* D-12353: Dialogs broke when there are quotation marks in header.
* D-13796: Some Snowflake operations didn't work with zero rows and columns.
* D-11978: Soft deleted project could incorrectly be queried by admins.
* D-12494: Now when chart size changes, the table column filters and sorting are preserved.
* D-11982: Null reference error when filter contained attribute value with null.
* D-13736: In Performance benchmarking dialog, the Export result button exported wrong benchmark performance analysis result.
* D-11706: Deadlocks during tests in Concurrency test category.
* D-13609: Improved conformance analysis related filter names.
* D-11893: User.Globalpermissions returned incorrectly Hashset for inactive users (should return array).
* D-13594: Recycle bin buttons were not visible when opening recycle bin in a narrow screen.
* D-11892: Project-specific user role could be assigned without project id (as global).
* D-13226: Tooltips in the model properties dialog are now translated.
* D-12114: In-memory core gave now and then error: The given key was not present in the dictionary.
* D-12569: Table incorrectly showed ellipsis for narrow boolean type of columns showing checkboxes.
* D-12138: Timespan function incorrectly assumed 32-bit integers.
* D-13391: Emptying date or datetime picker value was not registered and it didn't trigger functionality.
* D-11548: Removed setting of default model and view.
* D-12621: Value search dialog didn't work with values containing backslashes.
* D-12230: Column mappings didn't work for some dataframe processing operations.
* D-13796: Some Snowflake operation didn't work with zero rows/columns.
* D-12100: Giving project name (possibly id too) for DataFrame.Persist did not work when persisting a SqlDataFrame.
* D-12099: Querying SqlDataFrame for an empty table returned an empty in-memory DataFrame.
* D-12301: Duplicating local datatable didn't create datatable in sqlserver.
* D-12097: Error "Unable to join two tables without specified binding columns", when dimensioning events by two case attributes.
* D-11862: Filter with integer stringifiedvalues raised an exception when running in in-memory.
* D-12087: Error: Ambiguous column name 'CaseId'. The column 'CaseId' was specified multiple times for 'df_5'.
* D-12297: The datediff function resulted in an overflow when using high precision in SQL Server.
* D-12288: Error in querying event type measures: An item with the same key has already been added.
* D-12329: Filters using boolean attributes didn't work in SQL Server/Snowflake.
* D-12054: Backslashes in string literals gave null reference error in dataframe processing.
* D-12065: Case attribute filtering with column mapped to case id didn't work in filters.
* D-12070: PA server incorrectly modified dashboard json.
* D-12046: Expression language DateTime.Ticks was always UTC time.
* D-12102: SQL Expression: Variable-function did not work if the variable has upper-case letters.
* D-11950: Using list aggregation with different orderings in a single select did not work.
* D-12345: Mapping columns and using Columns function caused error 'invalid identifier'.
* D-12082: SourceData definition to events effected case attributes.
* D-12348: DateDiff did not support milliseconds in-memory.
* D-12374: Overflow error occurred when calculating standard deviation for case durations in large model.


== QPR ProcessAnalyzer 2022.4 (build 1001) (released 2022-05-31) ==
== QPR ProcessAnalyzer 2023.4 (build 2628) (released 2023-06-14) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Expression language has new function [[Generic_Functions_in_QPR_ProcessAnalyzer#Data_source_connectors|CallWebService]] for extracting data from web API's and make generic http calls. This function replaces the ReadWebService function which was a pre-production version of the same functionality. The ReadWebService function is thus now deprecated and it will be removed in future.
</div>


'''Features:'''
'''Features:'''
* B-06864: New dashboard component: Big data flowchart that calculates in Snowflake.
* B-07767: Added [[Gantt_Chart|Gantt chart]] to visualize timeline of cases and events divided into swimlanes.
* B-06434: Flowchart has been improved by adding e.g., presets, tabs and title (both in in-memory and big data flowchart).
* B-06383: Added [[Sankey_Chart|Sankey chart]] to visualize flow from one set of values to another.
* B-06515: New setting for chart to prevent applying chart filter to other charts ([[QPR_ProcessAnalyzer_Chart#Filtering_Settings|Apply chart filters to dashboard]]).
* B-07941: Implemented many more presets running in Snowflake models for compliance and operational excellence use cases. There are also presets for the path analysis and process bottlenecks identification.
* B-06450: Log in screen visual layout has been renewed.
* B-07864: Snowflake conformance analysis shows now [[Conformance_Analysis#Top_Deviations_(in-memory)_/_Deviating_Flows_(Snowflake)|reasons for conformance deviations]], such as which event occurrences deviated from the design model.
* B-06876: User management system reports including used license for each user.
* B-07909: Snowflake conformance analysis visualizes [[Conformance_Analysis#Undesired_Events_(Snowflake)|undesired event types]] in table and flowchart.
* B-05981: Expression language function CallWebService for web api and http calls.
* B-07823: Flowchart Bottlenecks preset has been changed to show bottlenecks for event types. Also renewed the [[QPR_ProcessAnalyzer_Logs#Task_Log|Tasks reports]] to use expression language based interface.
* B-06789: Datetime truncation function support for half-year and millisecond time units.
* B-07891: User interface has been [[Languages_and_Localization|translated into Portuguese]].
* B-06497: SqlExpression function for getting string length.
* B-07873: Improved [[QPR_ProcessAnalyzer_Pivot_Table|pivot table]] visual layout to highlight totals and aggregated rows. Also the row titles are now visible in the top left.
* B-06581: SqlExpression function for trimming white spaces from strings (Trim).
* B-07905: Added [[SQL_Expressions#Rank_functions|Rank related functions]] to Snowflake for writing more versatile custom KPI's, e.g., FirstValue, LastValue, NthValue, Lead and Lag.
* B-06630: SqlExpression function to add duration to date (DateAdd).
* B-07912: Added more SQL expression [[SQL_Expressions#Array_functions|array functions ArrayToString and ArrayOverlap]] to Snowflake.
* B-06631: SqlExpression function for getting a substring of a string (Substring).
* B-06449: Added SQL expression functions ToTimestamp and TryToTimestamp for parsing timestamps from strings using provided format.
* B-06860: SqlDataFrame function to remove columns (RemoveColumns).
* B-07959: Added new functions Base64Encode and Base64Decode to help using basic HTTP authentication when calling web services.
* B-06832: When error occurs in script run in client side, error message is shown in script log.
* B-07206: SQL expressions support data [[SqlDataFrame_in_Expression_Language#WithClusterColumn|clustering]] which is an unsupervised machine learning algorithm to group data based on similarities.
* B-06818: Russian language has been removed from UI.
* B-07848: Data can be extracted from SAP using the encrypted [[Importing_Data_from_SAP#SNC_encrypted_connection|SNC connection]].
* B-06445: Datatable row counts are cached to avoid querying the information from Snowflake.
* B-07903: Added expression language API to create and modify filters and models.
* B-06843: Backend support for filter rule to filter events by event attribute values.
* B-03103: [[QPR_ProcessAnalyzer_Logs#Task_Log|Task log]] (operation log) can be accessed in expression language.
* B-06871: Translation updates for 2022.4 release.
* B-07872: List aggregation with Distinct=true orders now items by their value.
* B-07940: Removed "Count" aggregation from textual values in Big data chart (you can use the Case count, Event count, etc. selection instead).
* B-07757: Backend support for datatables linking to user-definable Snowflake database, schema and table.
* B-07825: Improved error message when trying to use non-existing attributes in Snowflake queries.
* B-03101: To expression language, added try-catch-finally statement to handle thrown exceptions.
* B-07861: Removed available and total virtual memory information from User settings dialog.
* B-07902: Optimized sequences of joins in Snowflake queries to improve performance.
* B-07837: Updated backend components.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11802: When closing fullscreen, sometimes main header stayed invisible.
* D-13709: If image width-to-height ratio was lower than container's ratio, image was incorrectly stretched to fit the container.
* D-11947: Dynamic dropdown lists didn't open in first click in certain situations in Firefox.
* D-13660: Disabling filter rules didn't work in Snowflake models.
* D-11783: Flowchart start/end flow measure label showed in incorrect place when there are only one starting/ending flow.
* D-13526: Passing dataframes from SQL scripts to expression scripts didn't work.
* D-11796: Data export in pivot table didn't work.
* D-13661: Snowflake conformance analysis crashed when there was no access to conformance related Snowflake UDF's.
* D-11530: When model is moved to other project, linked datatables are now not moved.
* D-13693: Resolved major Snowflake conformance analysis performance issues in the BPMN model handling.
* D-11714: Scripts list hover buttons didn't work in Firefox.
* D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
* D-11500: Duplicated name check for workspace items was missing.
* D-13707: In SQL Scripting, the datatable analysis (number 18) didn't always copy the data table contents to the target table correctly.
* D-11782: Some in-memory chart expressions gave parse exception: token recognition error at: '\n'.
* D-13653: Big data flowchart Root causes preset showed incorrect legend.
* D-11871: Importing large number of rows to Snowflake could be very slow, as it incorrectly used SQL insert.
* D-13626: Flowchart froze when converting into big data flowchart and vice versa by modifying chart json settings.
* D-11781: Persisting more complicated SqlDataFrames did not work.
* D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
* D-11849: Script log was not generated when running tasks in parallel using AsParallel function.
* D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
* D-11789: Changing expression to "none" crashed UI, and line breaks were incorrectly removed in multiline text fields.
* D-13704: In CSV file import, parsing now allows spaces between column separator and text quotation mark.
* D-11817: Error missing when trying to run --#CallWebService with ExecuteInClientSide=1 in web UI.
* D-13598: Chart gave unclear error message when events datatable was not defined.
* D-11716: Deleted models were incorrectly listed in main header.
* D-13655: Improved error messages for BPMN editor and conformance statistics.
* D-11912: User management dialog showed global roles incorrectly after they have been changed.
* D-13528: Error message for certain erroneous SQL expressions was unclear.
* D-11940: Datatable rows column didn't show all when there is over 1 billion rows.
* D-13677: "Flow occurrences with specific case attribute value" selection didn't work for in-memory chart.
* D-11596: Event count calculated incorrectly using AggregateFrom events.
* D-13663: Pivot table border line was slightly broken in the header area.
* D-11588: EventTypes root dimensioned by case count with AggregateFrom did not work.
* D-13608: There was incorrect alignment of items in the table paging controls.
* D-11778: Variations dimensioned by flow count gave error in SQLDataFrames.
* D-13703: Importing CSV file with some special characters to Snowflake failed (due to incorrect escaping in Snowflake staging files).
* D-11788: User roles did not work in expression language.
* D-13708: Duplicating datatable using user defined table, removed data the source table.
* D-11815: Variation case count showed as too large when there was other value joining events.
* D-13717: Dependency wheel crashed when there were zero weights and showing data labels.
* D-11818: Flow case count calculated incorrectly in dataframes.
* D-13348: There was an unclear error message when Snowflake query had a certain incorrect expression.
* D-11794: Switch statement returned null reference exception when condition expression evaluates to null.
* D-13732: Pivot table Excel export contained headers formatted incorrectly.
* D-11820: Variation duration calculation gave error in dataframes.
* D-13729: There was a JavaScript error when limited user tried to access business calendar.
* D-11867: Variations were not deterministic if there were events with same timestamps.
* D-13662: Percentile function didn't always work with timespan types.
* D-11891: Snowflake data import could fail in SQL insert mode due to too many statements.
* D-13646: Using incorrectly configured model without cases datatable caused null reference error.
* D-11848: Configuration needed to be defined as valid JSON 'null'.
* D-13629: When tried to use chart with a non-existing model, there is now a proper translated error message.
* D-11784: Memorycache root gave errors when measures were used.
 
* D-11913: Root causes icon was missing on the header.
== QPR ProcessAnalyzer 2023.3 (build 1990) (released 2023-05-03) ==
* D-11938: Design model was incorrectly not stored to the dashboard.
* D-11939: Filter rule dialog showed incorrectly case/event attribute datatype in eventlog mode.
* D-12004: Adjustment expression and Custom aggregation expression could not be emptied.
* D-12034: All filter rules were not visible in main header when there are lot of them.
* D-11821: Flow count of variation is incorrectly null for some variations.
* D-11834: Error when dimensioning flows by case count in dataframes.


== QPR ProcessAnalyzer 2022.3 (build 925) (released 2022-04-20) ==
'''Features:'''
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
* B-07818: [[Conformance_Analysis|Conformance analysis]] is supported in Snowflake with following dashboard components: Big data chart, BPMN editor, Conformance statistics, and Design model selector.
In Workspace, dashboards and scripts cannot be created anymore to the Workspace topmost level. All existing dashboards and scripts in the topmost level are moved to a new project named System, where administrators can access them. If dashboards and scripts are moved away from the Workspace level before the QPR ProcessAnalyzer 2022.3 update, the System project is not created.
* B-07833: [[Root_Causes#Root_causes_in_flowchart|Root causes analysis for flowchart]] is available for Snowflake showing how the event and flow occurrences explain selected phenomena.
</div>
* B-07786: Big data chart has more [[Big_Data_Chart#Measure_aggregations|measure aggregations]], such as median, percentile, standard deviation and variance. Also for textual items, unique values can be listed.
* B-07795: [[QPR_ProcessAnalyzer_Table#Conditional_formatting|Conditional formatting]] supports also columns with non-numerical contents.
* B-07830: [[Big_Data_Chart#Measure_aggregations|None and Any aggregations]] for Snowflake and user-friendly formatting for conformance violations.
* B-06527: Error messages in [[Importing_Data_to_Datatable_from_CSV_File|CSV file import]] show also the column number to help working with CSV files with lot of columns.
* B-07747: In-memory conformance checking accepts design models with multiple tasks having same name (same is followed by the Snowflake implementation).
* B-07659: In-memory flowchart preset Case Conformance to visualize conformance checking violations.
* B-07571: Added function IsConformant to backend to check whether cases are conformant.
* B-07863: Added function ConformanceViolationsFlows to backend to return nonconformance reasons for violating cases.
* B-07844: Support for "array" aggregation to return aggregated items as array.
* B-07856: Support for creating and accessing arrays and objects in SQL expressions.
* B-07860: Array handling functions and Tasks property for DesignModel entity.
* B-07847: Added throttling for QPR ScriptLauncher client-side imports to limit memory usage.
* B-07811: Snowflake query optimization to omit columns that are not used by the query.
 
'''Fixed issues:'''
* D-13632: Going from variations to event types led to very poor performance with certain models.
* D-13628: Statistical calculations were incorrectly not applied in chart CSV export.
* D-13575: SQL script may have given error "Operand type clash: nvarchar(max) was incompatible with sql_variant".
* D-13597: UI supports now datatable column type "ShortString" (previously datatable contents preview and CSV import didn't work).
* D-13536: Using business calendar sometimes gave error "System.InvalidOperationException: Collection was modified".
* D-13477: Chart types without y-axis mapping caused an error when series mapping was used.
* D-13453: _model variable was not available for Snowflake expression filter rules.
* D-13527: Checkbox height didn't increase when long label needed to span to multiple lines.
* D-13363: Snowflake query with EvaluateAfterAggregations and IsHidden failed when dimensioning by case id column.
* D-13383: Snowflake query gave error "Invalid column name 'FromCase Name'".
* D-13523: Request id was incorrectly shown as zeros in error messages.
* D-13541: In CSV import, error message for maximum number of columns exceeded is improved (maximum is 300 column for SQL Server).
* D-13583: Objects count in header didn't work for empty Snowflake model.
* D-13553: Larger pacm files can now be imported, as there isn't error "Request body too large. The max request body size is 30000000 bytes".
* D-13306: Stack overflow error was given when using SqlDataFrames.
* D-13487: When Flows root and there was filter in Values expression, some flows were lost.
* D-13540: SqlDataFrame query with 300 columns failed to error "WithExpressionColumn: No name given for the new column".
* D-13429: Ordering in List aggregation couldn't find columns in dataframe query.
* D-13406: Dataframe query with root FlowOccurrences and get value from cases caused error.
* D-13538: There was incorrect handling of escaping characters in column names used in dimensions.
* D-13633: Fixed ordering in List aggregation with null and empty values.
* D-13636: Query that dimensions by numeric case attribute with AggregateOthers true, caused error.
* D-13589: Creating Snowflake datatable did not connect to Snowflake.
* D-13623: Value expressions without aggregation didn't work with AggregateOthers setting.
* D-13554: In in-memory chart, percentile function might have return both Int64 and Double type of objects which cannot be sorted.
* D-13481: Improved error message when trying to use deleted model.
* D-13621: Dynamic value search dialog had incorrect font in lists.
* D-13610: Some invalid BPMN files crashed BPMN editor.
* D-13614: Checkbox label texts overflowed to right.
* D-13520: Removed excessive parameters from the Query Designer for generic context queries.
* D-12998: QPR icon was incorrectly positioned in header in Safari.
* D-13480: Import to duration data type is removed from Snowflake datatables, and for local datatables duration type maximum size is checked.
* D-13517: In Highcharts-based visualizationsm conditional formatting didn't work for other than the first y-axis mapping.
* D-13529: In some presets containing several on-screen settings, when chart showed in error message, on-screen settings showed invalid selection.
* D-13530: Opening dropdown list caused JavaScript error when the list contents should be empty after it previously contained items.
* D-13486: Removed unreachable error message in CSV import.
* D-13524: Fixed in-memory chart flow occurrences root measures "Event attribute (text)" and "Event attribute (number)" that caused error.


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
== QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22) ==
In QPR ProcessAnalyzer 2022.3, the legacy ''SAP NetWeaver RFC'' library for SAP connections has been removed, and now SAP connections use the new ''SAP NetWeaver RFC'' library. Also the related SapProvider setting in the SAP import command is not anymore in use.
</div>


'''Features:'''
'''Features:'''
* B-06310: [[Big_Data_Chart|Big data chart]] to perform calculation in Snowflake.
* B-07755: [[Business_Calendar|Business calendar]] for duration calculation is available for Snowflake models.
* B-06654: Dashboards, models, datatables and scripts are removed from Workspace level.
* B-07719: In Snowflake dashboards, [[Big_Data_Chart#Using_measure_variables|measures can be assigned to variables]] and use the variables in other measures to create combined measures.
* B-05763: Possibility to set SAML service provider signing certificate.
* B-07746: Changed in-memory conformance checking to not show invalid flow violations where starting or ending event type is invalid.
* B-06765: Remove legacy library for the SAP data connector.
* B-07743: [[PA_Configuration_database_table#General_Settings|Default datasource]] can be configured for datatables created by scripts, allowing to set Snowflake as default.
* B-06812: Make it possible to overwrite existing SqlDataFrame columns.
* B-07740: System memory indicator moved from the header to User settings Version information dialog.
* B-06554: Support for IN operator in SQL expressions.
* B-07776: New SQL expressions functions Unicode, Char and Regexp, as a basis for future rule-based process mining.
* B-06779: SQLDataFrame IN function support for null values.
* B-07741: Backend support for aggregation operations Median, Percentile, Stdev, Stdevp, Var and Varp to Snowflake.
* B-06553: Round and TruncateDate functions for SQL expressions.
* B-07742: Backend support for aggregation operation to list unique items in Snowflake.
* B-06776: Support for NumberPrecision and DatetimeTruncation parameters in dataframe processing dimensions.
* B-07770: Optimized Snowflake SQL generation by combining consecutive WithColumn function calls into one select.
* B-06759: Migrate root level dashboards and scripts to new project.
* B-06569: Frontend components have been updated.
* B-06794: Translation updates for 2022.3 release.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11642: Sometimes dashboard charts showed loading animation forever.
* D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
* D-11708: Text filters did not work correctly in dashboard tables.
* D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
* D-11565: Delete icon showed incorrectly in dashboard properties and session variables.
* D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
* D-11537: Script run failed to session expiration error when running in ScriptLauncher and try to perform client side operation after session expiration.
* D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
* D-11196: Table column filtering context menu didn't show when table was in full screen.
* D-13405: Images take now always all available space in image component area.
* D-11591: It was not possible to import csv file having numbers with exponential notation.
* D-13417: KPI card without title was slightly misaligned vertically.
* D-11543: Sometimes it was not possible to scroll to last row for workspace tabs.
* D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
* D-11338: When filtering in the flowchart, the include/exclude selection didn't show when flowchart was in full screen.
* D-13350: Task log and Script log default filter end date is now empty by default.
* D-11605: Implemented datatables metadata caching, as opening models list was too slow in some environments.
* D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
* D-11564: "Given key was not present in the dictionary" when all mandatory but useless values were not defined in script launcher config file.
* D-13347: Improved performance for in-memory business calendar calculation.
* D-11572: BPMN model tooltips was hidden behind the bpmn editor.
* D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
* D-11586: KPI Card crashed when showing string values.
* D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
* D-11599: KPI card could not display very large values properly.
* D-13451: Exported filter file is now named based on selected filter name.
* D-11496: UI didn't work well in situation where there were no models available for user.
* D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
* D-11575: Column/bars were not visible for exported polar charts.
* D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
* D-11593: When creating user, error message about exists username didn't remind about inactive users.
* D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
* D-11600: Settings button was not visible in Process Discovery when KPI Card was used.
* D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
* D-11570: Slice into dimension didn't work for Root causes for Attributes preset.
* D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
* D-11589: Context menu that was not related to the recycle bin was incorrectly shown in Workspace.
* D-13456: Improved error messages for incorrectly configured on-screen settings.
* D-11622: Expression filter rules with different periods (DateGranularity) were handled incorrectly.
* D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
* D-11465: Add tooltip to effective permission table in Manage users dialog.
* D-13421: Improved error messages when trying to use model having some column mappings missing.
* D-11623: Tabs in model properties dialog didn't show correctly in narrow screens.
* D-13485: Snowflake business calendar gave error when calendar contained Sunday.
* D-11638: Changing include/exclude state of existing filter rule showed incorrect filter rule parameter selections.
* D-13218: Windows event viewer incorrectly contained log entries that are not errors.
* D-11654: Two popup menus sometimes incorrectly shown for Design Model Selector.
* D-12634: Multiline text boxes width is set to non-changeable.
* D-11517: In Workspace first column "Name" was not visible if window was not wide enough to show all columns.
* D-13034: Confirmation dialog to delete items permanently has been updated.
* D-11619: Query Designer and chart multiline text boxes didn't accept non-breaking spaces.
* D-13288: In dialogs, the Create button didn't show the disabled state correctly.
* D-11645: Column data type was missing in the setting of Datatable view.
* D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
* D-11554: Dataframe expressions were incorrectly executed by default in-memory.
* D-13483: In Workspace, the new items menu was too narrow for Spanish texts.
* D-11585: Error text was misleading when SAP dll missing during import in server.
* D-11583: Error about Maximum Rows message was not displayed in analysis result but instead {} was displayed.
* D-11610: Event count showed incorrectly when including cases based on event types (in dataframe processing).
* D-11549: Column mappings script did not work with specific model.
* D-11634: Dashboard Properties/Variables had the wrong checkbox icon.


== QPR ProcessAnalyzer 2022.2 (build 854) (released 2022-03-09) ==
== Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
 
SAML 2.0 authentication has been renewed, changing related urls as follows: SAML authentication is initiated from path '''/saml2''' (previously it was /api/saml). In addition, the redirect back url is now '''/saml2/acs''' (previously it was /api/samlsignin). These changes need to be made to the identity provider and taken into use during the QPR ProcessAnalyzer 2022.2 update. In addition, the redirection to the SAML authentication initialization path, that has possibly been set to IIS, need to be changed.
'''Features:'''
</div>
* B-07690: System setting [[PA_Configuration_database_table#General_Settings|DatabaseId]] can be defined by administrator to get more simple table names in Snowflake.
* B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
* B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
* B-07663: In [[Chart_On-screen_Settings|on-screen settings]], when case/event attribute is selected, related attribute values list are reset.
* B-07570: Backend support for [[Business_Calendar|business calendars]] in Snowflake.
* B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
* B-07610: Memory counter related technical properties have been removed from expression language.


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
'''Fixed issues:'''
[[SQL_Scripting_Commands#--.23ImportSapQuery|SAP connector]] has been changed to use the newer SAP NetWeaver RFC Library provided by SAP. Due to this change, additional installation steps for [[QPR_ProcessAnalyzer_ScriptLauncher#Installing%20SAP%20NetWeaver%20RFC%20Library|QPR ScriptLauncher]] and [[Install_QPR_ProcessAnalyzer_Server_Manually#Installing%20SAP%20NetWeaver%20RFC%20Library|QPR ProcessAnalyzer Server]] need to be done. The changes only affect environments where the SAP connector is enabled.
* D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
</div>
* D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
* D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
* D-13358: Calculation results caching works also across different user sessions.
* D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
* D-13230: SAP import did not automatically create columns to use the correct column types.
* D-12857: Deeply recursive functions caused a crash without any trace.
* D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
* D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
* D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
* D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
* D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
* D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
* D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
* D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
* D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
* D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
* D-12991: Dropdown list texts had some translations missing.


== QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
The WCF API has been removed from QPR ProcessAnalyzer 2022.2. Before updating, all customized integrations and other solutions that use WCF API need to be converted to use [[QPR_ProcessAnalyzer_API|Web API]]. Note that there may also exist scripts that contact the WCF API using the [[SQL_Scripting_Commands#--.23CallWebService|--#CallWebService]] command. The used API can be distinguished from the url: if it contains "/MainService.svc" the connection is to the WCF API and changes are required. Note also that if QPR ProcessAnalyzer Excel client has still been in use, from now on it will not work.
This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing <pre>"preset": "RootCauses"</pre> and the comma from the preceding line.
</div>
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Due to the WCF removal, [[Installing QPR ProcessAnalyzer Server|installing]] QPR ProcessAnalyzer Server is now easier, as there is only one web.config file (i.e., no separate web.config files for http and https). Note also that the contents of the web.config file is changed, so settings contained by the file need to be migrated manually.
Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in [[SQL_Scripting_Commands#--.23GetAnalysis|--#GetAnalysis]] command), and thus needs to be changed to the [[SQL_Scripting_Commands#--.23RunQuery|--#RunQuery]] command (see the [[RunQuery_Script_Examples|examples page]] how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.
</div>


<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Following script can be run in the [[Navigation_Menu#Expression_Designer|Expression Designer]] to show whether there are scripts that use the removed analyses (and thus require migration):
[[SQL Scripting Commands#--.23ImportSalesforceQuery|Salesforce connector]] has been changed to use Salesforce REST API, and the API version is changed from 38 to 54. Due to the change, there might be slight differences in the Salesforce connector behavior.
<pre>
let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");
</pre>
</div>
</div>


'''Features:'''
*
* B-06441: Snowflake stored datatables and models can be managed in [[QPR ProcessAnalyzer Project Workspace#Datatables|Workspace]].
* B-06495: In the out-of-the box dashboards, chart and flowchart settings are now remembered during the user session.
* B-06314: In Workspace, Models and Scripts tabs refresh automatically to show the current models and scripts status.
* B-06551: New [[Measure, Dimension and Column Settings#Statistical calculations|statistical calculations]] for charts and other statistical calculations improvements.
* B-06362: Expression language: [[QPR ProcessAnalyzer Expressions#Conditional statement .28switch.29|switch-case-default-break statement]].
* B-05802: Support for encrypted SAML 2.0 assertions.
* B-06259: SAML 2.0 authentication library has been changed.
* B-06428: Removed limitation from SAP connector to allow multiple SAP extractions simultaneously.
* B-05837: Root causes calculation is available in the expression language.
* B-06526: When ComparisonEventLog is used in an expression, it's initialized automatically.
* B-06303: WCF client has been dropped.
* B-06563: All WCF related functionalities has been removed.
* B-06558: Salesforce connector has been changed to use Salesforce REST API.
* B-06514: In Workspace, scripting and model permission restrictions are better reflected in the UI.
* B-05960: Distributed computing: All datatable columns are made available in dataframe processing method.
* B-06500: When empty, DatabaseId is generated automatically in PA_CONFIGURATION table on startup.
* B-06567: Translation updates for 2022.2 release.
'''Fixed issues:'''
* D-11484: Scripts incorrectly stayed in stopping state, when system was shut down while the script was running.
* D-11537: Script failed to session expiration error when running in ScriptLauncher and performed a client side operation after session idle timeout.
* D-11495: Model specific DropUnusedModelsAfter setting is removed in server side as it didn't work as intended.
* D-11507: Removed "Drop unused model after" setting from UI, as it didn't work as originally intended.
* D-11497: Running script in web UI having ExecuteInClientSide=1 never completed.
* D-11523: Chart tooltip showed incorrect series when some series was hidden.
* D-11489: Percentage character (%) was lost from file name when exporting a filter to a json file.
* D-11557: Highcharts based charts were not disposed correctly on redraw causing out-of-memory error.
* D-11490: Stored filter rules were lost from default public filter when setting "All cases" to default public.
* D-11498: Trying to import empty csv file caused JavaScript error.
* D-11499: Trying to import csv file with header line only, correctly suggests now strings as datatype (instead of integers).
* D-11494: Flow Duration Distribution report had JavaScript error in the Enhanced BPMN dashboard.
* D-11501: Hiding event type name from flowchart caused error.
* D-11502: Right click didn't work when user opened BPMN editor from measures settings.
* D-11506: BPMN editor could not be opened in the Notification rules editor when creating measure.
* D-11478: Model properties window stayed visible in login page after session expiration.
* D-11491: JPG format file export had incorrect black background color.
* D-11513: Multi-select list item removal using the X button didn't work.
* D-11505: Changed new wiki location to the Help buttons.
* D-11486: Untranslated strings and translation inconsistencies for Finnish language fixed.
* D-11479: Selection list for new task could not display properly in BPMN editor.
* D-11508: Console error occurred when selecting Case conformance level in Notification rules editor.
* D-11510: Adjusting Object sample size caused error for Top violations chart.
* D-11144: Workspace scripts grid permissions was not checked when showing items context menu.
* D-11234: Creating new model option was incorrectly enabled when user had only view or analyst role for project.
* D-11520: In workspace, changing project with drag-and-drop takes now user permissions better into account.
* D-11521: Title could not display properly for datatable properties when using Finnish UI.
* D-11536: Translation support was missing for "Running" in Script Editor.
* D-11450: Export filter button was enabled in not possible state.
* D-11444: All duplicated dashboards had same identifier.
* D-11483: Unnecessary scrollbar was sometimes displayed in System reports dialog.
* D-11402: Rename icon was using wrong graphic.
* D-11558: Icons in UI had small vertical alignment problem.
* D-11559: UI used incorrect icon for Export functionality.
* D-11544: Datatable column names starting with lower case showed incorrectly in upper case.
* D-11482: Importing table to itself using SqlDataFrame caused the SQL Server to get partially stuck.
* D-11458: There was null reference error when ProcessingMethod is dataframe, ContextType is generic, and root is Cases.
* D-11487: ScriptById function did not return Access denied error if script didn't exist.
* D-11461: Filtering didn't work in dataframe mode when StringifiedValues was used.
* D-11540: Column mappings didn't work with WithRowNumberColumn function in SqlDataFrames.
* D-11231: In the Enhanced BPMN editor screen, import/open icon was wrong.
== QPR ProcessAnalyzer 2022.1 (build 774) (released 2022-01-24) ==
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
<div style="border:1px solid #dfdfdf;padding:0.5em 1em 0.5em 1em;background-color:#E7EAEC;margin:10px 0px 0px 10px;">
Known issue: If the "Drop Unused Model After" setting is specified for a model, the model may incorrectly be dropped from the memory when the memory consumption is high. As a workaround, set this setting to empty, so that the model is not dropped by itself. This incorrectly behaving setting will be removed from the software in the next release (D-11507).
Starting from QPR ProcessAnalyzer 2023.1, the '''.NET Desktop Runtime''' is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, ''.NET Desktop Runtime'' is not needed, but instead install the '''.NET Runtime''' (which is more lightweight). ''.NET Desktop Runtime'' contains the ''.NET Runtime'', so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.
</div>
</div>


'''Features:'''
'''Features:'''
* B-06334: New dashboard component: textual labels can be added to dashboards.
* B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
* B-06324: Chart settings icon can be hidden in preview mode, and also icons visual layout has been improved.
* B-07383: Improvements to linked settings to allow binding to variables, tags and filter rules [[Chart_Linked_Settings|(more information)]].
* B-06494: Expression language: break and continue statements.
* B-07508: Flowchart preset colors have been renewed to be more intuitive.
* B-06435: Web UI web page title in browser header simplified.
* B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
* B-06535: Copyright year updated to 2022.
* B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace [[QPR_ProcessAnalyzer_Project_Workspace#Datatables|(more information)]].
* B-06466: Updated to Angular 13.
* B-07440: Date when the release was made is now shown in User settings.
* B-06521: Frontend components have been updated.
* B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
* B-06448: Optimized Snowflake data import using Put command.
* B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
* B-06481: Added support for project description field to expression language and Web API.
* B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
* B-06491: Improvements for taking into use new SAP library.
* B-07637: Language selector now shows the language options in local languages.
* B-03053: Backend support for expression scripts permissions.
* B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
* B-06501: Translation updates for release 2022.1.
* B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
* B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
* B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
* B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
* B-07716: ShortString columns are now properly detected in SQL Server queries.
* B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
* B-07688: AddColumns function for Datatables to create multiple columns in one call.


'''Fixed issues:'''
'''Fixed issues:'''
* D-11462: Model notifications were not visible if there was notification containing dimensions.
* D-13092: Table conditional formatting didn't work when color code was fetched from other column.
* D-11435: Links in model description showed "&" characters incorrectly.
* D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
* D-11447: Linked settings and variable mappings didn't work with flowchart.
* D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
* D-11454: ScriptLauncher didn't work when only hostname was specified in ServiceURL.
* D-13104: In BPMN model editor, context menus to edit elements didn't appear.
* D-11419: In CSV import, row number showed incorrectly in column count mismatch error message when file size was over 10MB.
* D-12939: Script editor tabs Close buttons didn't work.
* D-11425: In chart, Statistical calculation "Show change from previous" didn't show empty for first row.
* D-13154: "Search by case ID" didn't work in in-memory chart.
* D-11307: Transparent color was not working for chart layout setting.
* D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
* D-11439: Date format was changed in workspace when changing only the language.
* D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
* D-11423: Dropdown lists were shown partly out of screen in smaller screens.
* D-12928: Pivot table headers were empty when there were two column levels and two values.
* D-11477: Maximum rows in Root causes didn't have maximum limitation.
* D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
* D-11167: Removed unnecessary "_." structures from chart expressions.
* D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
* D-11470: Catch function failed with a constant expression and non-constant resultIfException expression.
* D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
* D-11429: There existed Undefined % and NaN value in Root Causes Analysis result.
* D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
* D-11343: Script log was written to wrong script when expression script calls SQL script.
* D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
* D-11377: Stdevp function incorrectly returned zero for array of one element.
* D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
* D-11255: Train function didn't work with only one case in training set.
* D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
* D-11413: Color picker cancel button didn't work.
* D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
* D-11414: Clicking context menu icon in projects hierarchy tree in Workspace to open sub menu, didn't do anything.
* D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
* D-11245: Removed not needed fonts.
* D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
* D-11453: Wrong font used for System reports.
* D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
* D-11455: Red color error message didn't use Open Sans font.
* D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
* D-11180: Workspace contextual menu icons vertical alignment was incorrect.
* D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
* D-11475: BPMN context menu hidden behind other frame when webpage zoom setting was bigger than 110%.
* D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
* D-11416: Context menu in projects hierarchy didn't open in Cypress tests.
* D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
* D-11115: Title of event type filter didn't display "&" character properly.
* D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
* D-11097: When clicking data grid input validation message, JS error appeared: TypeError: Cannot read property 'data' of null  at Gs.getRowInfo  at Gs.mouseClickHandler.
* D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
* D-11267: Unable to use datatables with columns names having square brackets.
* D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
* D-11243: Project LastModifiedDate and LastModifiedBy are now updated when project properties are changed.
* D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
* D-11457: There was useless error message when HTML error is get via Web API.
* D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
* D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
* D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
* D-12937: Added maximum value limitation to several number input fields in charts.
* D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
* D-12948: Defining column setting caused error when Measure Expression was not defined.
* D-12946: Filter rule text couldn't be seen entirely from tooltip.
* D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
* D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
* D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
* D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
* D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
* D-13116: BPMN editor had some translations missing.
* D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
* D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
* D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
* D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
* D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
* D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
* D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
* D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
* D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
* D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.


== Old Releases ==
== Old Releases ==

Revision as of 08:39, 24 April 2024

This page lists all new features and fixed issues for each QPR ProcessAnalyzer release.

Next Release: QPR ProcessAnalyzer 2024.4 (planned release date 2024-05-14)

Features:

  • B-08264: Workspace is now showing child projects in the top level when there is no access to parent project.

Fixed issues:

  • D-14084: Filter rule for first/last event in case couldn't be edited if there were more than one event selected.
  • D-14091: Duration multi-unit didn't work in big data chart.
  • D-14085: Measure/dimension/column settings dialog didn't open for Event attribute when drop-down list values weren't selected.
  • D-14095: Flowchart sometimes crashed with color mapping in use to an event type measure with null values.
  • D-14094: Measure unit was incorrectly shown for textual values and the unit could not be changed.
  • D-14096: Highcharts tooltip square icons were slightly misaliged.
  • D-14100: In Workspace, project bread crumbs didn't update when moving the selected project.
  • D-14099: There was a console warnings when opening the business calendar dialog.
  • D-14097: In Workspace, added progress spinner to prevent starting a new operation while the previous is still in progress.
  • D-14105: Snowflake root causes analysis showed incorrect row count when Contribution was Contributing or Impeding.
  • D-14107: Snowflake model that has earlier been in-memory model showed case count and estimated memory incorrectly.

Latest Release: QPR ProcessAnalyzer 2024.3 (build 5801) (released 2024-04-04)

Features:

  • B-08024: Design diagram has now swimlanes and BPMN expanded subprocesses. Also indirect flows can be included when calculating flow measures.
  • B-08242: Script based actions can be started from dashboard table context menu, extending dashboard functionality to e.g., create tickets, trigger automation, and fetch external information.
  • B-08268: (1) In Overview flowchart preset, flow width visualizes now case volumes instead of flow duration. (2) When converting Snowflake expression into custom, the expression filter is preserved and not embedded into the custom expression.
  • B-08288: Added expression language functions to start and stop scripts.
  • B-08252: When Analyzed objects is cases, event attribute values are filtered with the native event attribute filter rules instead of expression based filter rules.
  • B-07906: Implemented cross joins to SQL dataframes.
  • B-08267: Simplified Task log additional parameters by moving query parameters to the root level.
  • B-08221: Snowflake query performance has been improved by using cached filters to build new filters.
  • B-08231: Snowflake performance improved by splitting object counts (shown in header) query into two, so that the filtered object count query uses eventlog caching.
  • B-08250: Business calendar calculation also takes into account calendars with overlapping periods.
  • B-03047: Removed support for dashboard panels.
  • B-08214: Removed unused columns from the PA_VIEW table.
  • B-08254: Frontend components have been updated.
  • B-08255: Backend components have been updated.
  • B-08233: Language translations have been updated to 2024.3.

Fixed issues:

  • D-14048: Fixed issue where in-memory root causes analysis for case attributes didn't show attributes with ShortString data type.
  • D-14035: In design diagram, BPMN event and gateway symbols are now circular.
  • D-14049: Added some missing translations for table column filter and BPMN editor.
  • D-14021: FindRootCauses function WeightingExpression was run in incorrect context for in-memory model.
  • D-14020: Query which goes from EventTypes to Cases did not show the error when using GetValueFrom function.
  • D-13976: Fixed issue where gateway-based imports were not synchronous.
  • D-13689: Fixed JavaScript error in Highcharts polar chart with tooltips.
  • D-12614: Highcharts gives "Maximum call stack size exceeded" error in bar chart with polar and data labels.
  • D-14060: Highcharts custom layout translatable properties incorrectly changed chart configuration by translating the labels.
  • D-14071: Business calendar button press caused error when user didn't have access to any model.
  • D-14041: Manager Users dialog "Has password" field filter shows now Yes/No texts instead of true/false.
  • D-11268: There were inconsistent button colors in Workspace.
  • D-12264: Disabled stacked and polar charts for donut, packed bubble, sankey, dependency wheel, word cloud, and gantt charts.
  • D-14066: Fixed issue when EventTypes, Events.IncomingFlowOccurrence fails because there is event type filtering in in-memory model.
  • D-14081: Fixed null references error when logging null in expression script.

Additional release for QPR ProcessAnalyzer 2024.2 (build 5509) (released 2024-02-27)

Features:

  • B-06280: User management dialog shows whether users have password defined and unnecessary passwords can be removed to improve security.

Fixed issues:

  • D-14045: Fixed issue where users with Viewer or Analyzer role couldn't create filters in Snowflake models.

QPR ProcessAnalyzer 2024.2 (build 5438) (released 2024-02-21)

Known issue: Snowflake models and dashboards don't work with Viewer and Analyzer role permisions. The reason is that cache tables created to Snowflake incorrectly require the write permissions. Workaround is to give users the Designer role which will give the needed permissions. Note that the Designer role gives many permissions to the user for the project (more information). This issue has been fixed in the next release (D-14045).

The legacy User permissions report (analysis number 11) and Filters report (analysis number 30) used in SQL scripts have been removed. Use instead the expressions language to query filters and user permissions, e.g., Models.Filters and RoleAssignments property.

New version of the Design diagram component has been improved with object-specific measures, and the previous common measures are not migrated into object-specific measures. Thus, the measures need to be configured again, or manually edit the chart json settings (if needed please ask instructions from QPR CustomerCare).

Features:

  • B-08022: Design diagram supports now BPMN notation, elbow style flows and object-specific measures.
  • B-08232: Entire future eventlogs can be predicted based on generative AI models running in Snowflake.
  • B-08166: Added expression language function OpenAIChatCompletion to answer natural language prompts based on OpenAI ChatGPT API.
  • B-08177: Snowflake query performance has been improved by introducing caching of filtered eventlogs using Snowflake tables.
  • B-08196: Conditional formatting rules can be defined for textual and boolean values.
  • B-08213: Big data chart expressions event type selections to be multi-select where applicable.
  • B-08205: Expression language API is available for storing secrets for scripts.
  • B-07780: Chart variable mappings has been removed - use the linked settings instead. Dashboards using variable mappings are automatically converted to use linked settings.
  • B-08117: Added ToSqlDataFrame function to convert in-memory dataframe into SQL dataframes.
  • B-08174: Only non-default parameters values are written to the operation log.
  • B-08200: Timestamps in System reports are shown in user workstation local time.
  • B-08171: Dashboard id has been added to queries, to track from which dashboard queries are originating.
  • B-07144: Remove legacy User permissions report (analysis number 11) and Filters report (analysis number 30) in SQL scripts (see note above).
  • B-08193: Added retry mechanism to QPR ScriptLauncher to recover if connection to server breaks.
  • B-08202: Updated copyright for year 2024.
  • B-08199: Frontend components have been updated.
  • B-08203: Backend components have been updated.
  • B-08209: Translations updated for release 2024.2.

Fixed issues:

  • D-13972: Some measures/dimensions/columns in Big data chart didn't show the expressions level filtering.
  • D-14015: Fixed business calendar incorrect calculation when business period covered entire day.
  • D-14014: Fixed issue where Snowflake business calendar could not have end time as 00:00.
  • D-13962: System variable values were interpreted incorrectly when used in linked settings.
  • D-13971: HiddenInNavigation and SortOrder variables didn't work in navigation menu dashboards list.
  • D-13959: Removed possibility to add datatable columns with the legacy "any" data type.
  • D-13991: Improved drop-down selector component to handle empty strings as variable values.
  • D-13965: Datatable column name length was validated incorrectly which may have caused error in saving with too long column names.
  • D-13958: Project names showed unnecessary html escaping in the "Move to" menu.
  • D-13964: Model attributes and notifications dialogs gave error when trying to use dashboard tags.
  • D-13960: Added missing translations for list of permission list and 12-hour clock format.
  • D-13966: Fixed issue were root causes chart tooltip sometimes didn't disappear.
  • D-13969: Datatable column schema export sometimes showed empty for the key column.
  • D-13862: Session token was not accepted when url path capitalization is different.
  • D-13942: Datatable could not be dimensioned if it has column named "CaseId".
  • D-13980: Business calendar dialog crashed when tried to open it for a model without access.
  • D-13983: Notifications dialog didn't validate situation when same name was used in a measure and dimension.
  • D-13981: Dashboard import set incorrect model id to dashboard if there was no access to any model.
  • D-11276: Translations were missing for 12-hour clock dates (AM and PM) in dashboards.
  • D-13977: Multi-select dropdown lists showed some special characters incorrectly.
  • D-13945: Syncfusion toast message didn't work when text contains ${[]}.
  • D-13930: Pivot table throws javascript error when certain clicks.
  • D-13273: Duplicate datatable row count didn't shown correctly.
  • D-13994: There was an error in the in-memory chart with some flow related measures about duplicate variable names when same measure was defined twice.
  • D-13985: Models list dots menu had texts misaligned in narrow screens.
  • D-13995: In Workspace, wrong datatable was selected after duplication when non-default sorting was applied.
  • D-13997: Workspace tables column filtering search caused JavaScript errors.
  • D-13978: In table Excel export, the last row representing other items appeared incorrectly for in-memory chart.
  • D-14007: In System reports, model related selections are hidden from the Analyzed objects lists.
  • D-14005: In big data chart, changing to custom expression caused crash with some expressions having case/event attribute.
  • D-14003: When dimensioning was not used, pivot table values were incorrectly rounded in the server side.
  • D-14004: Removed empty filters from queries to optimize them.
  • D-13988: Fixed issue where data grid context menu rendered initially as too high.
  • D-13979: BPMN model editor element settings use now Open Sans font.
  • D-14013: Fixed incorrect expression "Duration between first and last occurrence" in big data chart event types.
  • D-13984: Fixed the error of refusing to run the JavaScript URL.
  • D-14031: ThrownObject property was not included to http error response when error came from the script.

QPR ProcessAnalyzer 2024.1 (build 4784) (released 2024-01-10)

Known issue fixed in QPR ProcessAnalyzer 2024.2: In Big data chart, some measures, dimensions and columns have the filtering option missing. The issue concerns for example Duration between events, Path starting/until between specific events, and Cases where event occurs before other selections. Workaround is to set the filter in the chart json settings: the filter can be configured to another expression and copied to the correct expression.

QPR ProcessAnalyzer Server and QPR ScriptLauncher are now using .Net 8 (previous was .Net 6). When updating to this release, install the .Net 8 Runtime (see more). The .Net 6 doesn't need to be uninstalled immediately because .Net 6 and .Net 8 work side-by-side, but due to security reasons, the unused .Net 6 should eventually be uninstalled.

In this release, all filters that don't contain any filter rules, are removed. These are legacy filters which have not been visible in the UI.

Features:

  • B-08019: New component Design Diagram for showing user-created diagrams in dashboards where to visualize process mining metrics.
  • B-08087: Generic dropdown list selector works with Snowflake models allowing to add selection lists for any values.
  • B-08163: Linked settings support for binding to case attribute filter values without defining case attribute name.
  • B-08170: Snowflake model filters can be saved as new models which can be used to create snapshots of part of models.
  • B-08093: Multiple dashboards can be exported to same file, and model can be set for imported dashboards.
  • B-08161: Added Modify function to change datatable properties and improved CreateDatatable function for creating datatables.
  • B-08122: Added new system report to list dashboards.
  • B-08173: Removed legacy filters that didn't have any filter rules.
  • B-07961: In OperationLog, changed parameters to json format and added request id.
  • B-08069: Added DashboardId property to OperationLog in expression language.
  • B-08139: Added UpdateRows function to update existing rows in datatables with similar logic than SQL update.
  • B-08115: Added DeleteRows function to delete rows in datatables with similar logic than SQL delete.
  • B-08149: QPR ProcessAnalyzer has been updated to .Net 8.
  • B-08054: Changed Scripts property in generic context to return all scripts, instead of legacy system level scripts.
  • B-08138: Changed Synchronize function to remove all columns when no Snowflake table exists.
  • B-07689: For datatables, foreign keys to other datatables can be defined using expression language.
  • B-08176: Translation updates for release 2024.1.
  • B-08175: Workspace should show timestamps in user's local time.

Fixed issues:

  • D-13913: Datatable properties dialog incorrectly showed linked models from other projects.
  • D-13916: Chart filter could not be defined for some expressions in Big data chart.
  • D-13933: Navigation menu selected item wasn't highlighted when used Snowflake models.
  • D-13906: In Conformance Analysis, deviating flows were not translated.
  • D-13907: Improved translation related to datatable properties dialog "Used by models" field.
  • D-13904: There was an unclear error message in Snowflake, as exception code 1 was returned without AttributeName and ModelName properties when non-existing attribute was in filter.
  • D-13911: Fixed small glitches in the opening and closing of drop-down lists.
  • D-13918: Datatable could be configured incorrectly to use table for other datatable.
  • D-13932: Duplicating datatable with custom table in datasource losed all data.
  • D-11002: Removed legacy in-memory prediction preset.
  • D-13912: Added check that array cannot be stored to dashboard Content property.
  • D-13936: Query designer default query didn't work with Snowflake models.
  • D-13938: There was an incorrect logging with some operations related to ScriptLauncher.
  • D-13923: Snowflake expressions didn't work with Where function in root referring to case attribute.
  • D-13939: ApplyFilter function gave null reference error for non-existing attribute name.
  • D-13931: There were issues with AllowExternalDatasources and EnableFullFunctionality settings.

QPR ProcessAnalyzer 2023.7 (build 4326) (released 2023-11-28)

Limitation for the maximum amount of data (B-07636) causes a behavior change in in-memory charts that have the Maximum rows settings empty and have the sorting defined. In certain cases, the order in which measures are evaluated changes (due to an internal performance optimization). If there are custom expressions that define variables, the variables may not be available in other measures anymore. As a resolution, either redefine the variables in those measure expressions or add those measures secondarily to the sorting.

Default query timeout of 30 minutes has been added for --#ImportOdbcQuery, --#ImportSqlQuery and --#ImportOleDbQuery commands. If a query run is taking longer than the timeout, the query is stopped. The timeout can be adjusted using the QueryExecutionTimeout parameter. Previously, there has been no timeout, so queries that take more than 30 minutes require configuring a longer timeout.

Incorrectly configured linked settings in charts (available in the Advanced tab) give now an error message, if they are referring to non-existing measures, dimensions or columns. Previously, incorrect linked settings were ignored. To fix the error message, remove the incorrect linked settings.

Features:

  • B-07511: Datatables have a dialog to view datatable properties, write description, set the Snowflake source table, add/modify/delete columns, and set the datatable key.
  • B-08150: Added setting Apply chart filters first to determine whether chart filter rules or dashboard filter rules are applied first when chart queries are filtered.
  • B-08091: When filtering charts in Snowflake, case attribute filter is created instead of case id filter.
  • B-08091: New setting to define whether cases or events are filtered by default.
  • B-08091: New preset "Looping paths" to detect whether there are repeating patterns of events.
  • B-08091: Duration between events calculation ignores negative durations in Snowflake.
  • B-08091: Chart loading animation has been renewed.
  • B-07636: To prevent dashboards from jamming when querying too much data, added limitations to the amount of data that charts can visualize. Note that the limitation concerns the aggregated data that is visualized, not the source event log data.
  • B-08017: Dashboards API has been added to expression language, allowing to create, modify and delete dashboards in scripts.
  • B-08056: Following properties have been added to user objects in expression language: IsLocked, LastLockedDate, LastLoginDate.
  • B-08053: User rights report has been refactored to use RoleAssignments property in the expression language. The change also simplifies the report as now it only shows the direct role assignments that are visible in the User Management.
  • B-08151: For Snowflake expressions support for following windowing functions: sum, average, median, min, and max.
  • B-08050: When a model is created, the default filter is not created anymore (this is a refactoring that doesn't have any impact on user interface).
  • B-08123: Translation updates for 2023.7.
  • B-08092: Updated backend components.

Fixed issues:

  • D-13876: In CreateSnowflakeConnection function, ProjectId parameter is optional when OdbcConnectionStringKey is not specified.
  • D-13898: Snowflake: Exclude case attribute filter didn't work when there was null values and was selecting at least two values.
  • D-13890: Fixed XES file import to work.
  • D-13894: Business calendar based duration calculation was incorrect in some durations that spanned to several weeks (for Snowflake and in-memory models).
  • D-13899: Using broken OdbcConnectionString in a datatable prevented the datatable from being deleted.
  • D-13883: Script run stucked after running a script with error that uses client-side ODBC import.
  • D-13879: SqlExpressionValue filter when excluding events didn't work with filter rule root expression only.
  • D-13896: Adding or removing columns to datatable didn't change the LastModifiedDate.
  • D-13882: User details weren't written to operation log when creating or modifying users.
  • D-13771: User rights system report didn't give error when changing columns.
  • D-13893: Some event filtering caused null pointer error when primary key had been defined.
  • D-13873: Fixed pivot table visual issues after component update.
  • D-13900: When adding, renaming or removing columns for Snowflake table fails, operation is now rolled back without any changes.
  • D-13866: Querying GET api/uielements was quite slow right after server start.
  • D-13864: Combinations of translatable and hardcoded strings didn't get translated in UI.

Additional release for QPR ProcessAnalyzer 2023.6 (build 3933) (released 2023-10-24)

Features:

  • B-08055: Error message for locked account has been replaced with generic error message, so that username enumeration is not possible.

Fixed issues:

  • D-13884: Attributes dialog crashed with some older model configurations.
  • D-13843: In charts, selected case and event attributes switched away when attribute data type was ShortString.
  • D-13877: Some Snowflake expressions gave error "exceeds maximum length limit of 255 characters" when selecting lot of items.
  • D-13878: Snowflake expression filters for case attribute values didn't accept other than string type of case attributes.
  • D-13871: Some statistical calculations with percentages didn't work with Last Row Aggregates Over-limit Rows setting.
  • D-13875: Using some case level filters in a model without cases datatable didn't work.
  • D-13861: Dashboard opens are now logged to the Task log (i.e., calling GET /api/dashboards/{dashboardid}).
  • D-13870: Workspace projects hierarchy focused project showed light grey background making the project name not readable.
  • D-13867: When starting datatable refresh and going to other tab, went back to Datatables tab when query completed.
  • D-13853: If chart Custom Layout settings had extra series defined, chart may have crashed.
  • D-13869: Export as CSV button didn't work in the datatable contents dialog when dialog was still loading.
  • D-13872: Main progress spinner had unnecessary small scrollbar on top right.
  • D-13863: In the REST API method GET /api/users, password field (that has always been null) has been removed.

QPR ProcessAnalyzer 2023.6 (build 3847) (released 2023-10-17)

Big data chart support of models with local datatables (i.e., SQL Server stored) is removed in this release. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).

Features:

  • B-07992: Added 10 new presets including Queue analysis, Four eyes principle, Self-looping events, and Path until selected event. There are also presets for Individual Cases Flow and Range of event type occurrences which use Gantt chart.
  • B-08011: Added following date related operations for Snowflake: Day of year, Day of month, Day of week, Week of year, Half-year only, Quarter only, Month only, Hours only, Minutes only, Seconds only, and Milliseconds only. These are available when calculating with date type of data.
  • B-08016: Table actions to set variables can also be opened to a new browser tab. Also improved user interface for table actions.
  • B-08018: For Snowflake expressions, added Flows aggregations FromEventType and ToEventType to get starting/ending event type, and FlowOccurrences aggregations FromEvent and ToEvent to get starting/ending event.
  • B-08001: Added CallStoredProcedure function to call Snowflake stored procedures. This allows to start ETL transformation in Snowflake orchestrated by QPR ProcessAnalyzer script.
  • B-08013: Added RoleAssignments property to expression language to replace the legacy UserPermissions analysis (11).
  • B-07976: Snowflake expression based filter rules support additional expression columns allowing more Big data chart expressions to be filterable.
  • B-08015: Big data chart doesn't anymore support calculation in SQL Server (using local datatables).
  • B-06270: Improved error messages and made them translatable by taking into use exception codes provided by server.
  • B-08021: Added possibility to store designed diagrams for models and expression language API for reading and modifying diagrams.
  • B-08037: Dropped following unused tables database: PA_IDEA, PA_IDEA_VOTE, PA_REPORT, PA_REPORT_SETTING, PA_SESSION_SERVICE, PA_VIEW_FILTER_RULE, PA_VIEW_FILTER_RULE_PARAMETER.
  • B-08052: Language translations have been updated to 2023.6.
  • B-08051: Frontend side components have been updated.
  • B-08034: Backend side components have been updated.

Fixed issues:

  • D-13830: Object counts indicator in header showed incorrect counts when there was disabled filter rules in Snowflake models.
  • D-13833: In-memory charts didn't work with boolean type of dimensions when filtering with the false value.
  • D-13858: Target value measures didn't update chart when controlled using an on-screen setting.
  • D-13827: Calculated attributes data type was incorrectly set as Any by the Attributes dialog.
  • D-13849: Multiselect list search didn't allow spaces.
  • D-13829: Multiselect dropdown lists height jumped couple of pixels when selecting values.
  • D-13835: Deselecting a selected data point didn't remove chart filter rule.
  • D-13702: Improved Snowflake query performance in situations when there are lot of filter rules (by decreasing number of CTE's).
  • D-13819: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
  • D-13820: Fixed incorrect manifest.json file to avoid "not found" errors when fetching web site icon.
  • D-13865: Break, continue, and return statements didn't work properly when called from inside a catch block.
  • D-13795: There was a Python error in clustering analysis with Snowflake model.
  • D-13823: Some tooltips in Workspace project hierarchy didn't work and caused a JavaScript error.
  • D-13824: BPMN editor align context menu layout looked strange.
  • D-13813: QPR logo button in the top left was misaligned in Firefox.
  • D-13797: Snowflake query may have given following error when using sampling: ambiguous column name '_EventType_NotNull_1'.
  • D-13774: TakeSample function with certain columns caused SQL compilation error: ambiguous column name 'Case Name'.
  • D-13782: Snowflake: Aggregating from variations didn't work when using sampling.
  • D-13836: Some tooltips had a strange two-colored background.
  • D-13834: Removed Model statistics column from clustering and root causes analysis.
  • D-13860: Removed filter button from the custom expressions in Task log analyzed objects.
  • D-13838: Removed Split data by filtering column from clustering analysis.
  • D-13832: Script and model status updates incorrectly sent next update when previous was still pending.
  • D-13839: Charts reset zoom button font size was too small.
  • D-13817: Importing data to Snowflake datatable with Append=0 doesn't now drop the underlying Snowflake table.
  • D-13825: Some models could not have been deleted from recycle bin.
  • D-13852: Recycle bin Projects and Models tab didn't show correct content when Recycle bin only contained either models or projects.
  • D-13841: In-memory chart Data type selection type has been corrected to string.
  • D-13842: Second time and Third time selections has been hidden in in-memory chart measures.
  • D-13850: In Chrome, there were console errors related in incorrect text field autocomplete type and text field without form.
  • D-13847: Improved browser side performance by removing unnecessary operations.
  • D-13859: Chart without dimensions showed an unnecessary Remove dimension button.
  • D-12598: When script is stopped in server, ScriptLauncher could still incorrectly continue to import data.

Additional release for QPR ProcessAnalyzer 2023.5 (build 3334) (released 2023-09-07)

Fixed issues:

  • D-13826: Measures or dimensions with case or event attribute and value selections incorrectly removed calculated attributes when dashboard was opened or chart settings were changed.
  • D-13821: Font size of some Highcharts tooltips was too small. Issue appeared when there were tooltips mappings in measures or dimensions.
  • D-13810: Simplified help links: now all Help buttons go to the QPR ProcessAnalyzer wiki main page.
  • D-13822: Snowflake clustering analysis showed empty strings and nulls as case attribute values in an unclear way as just nothing.

QPR ProcessAnalyzer 2023.5 (build 3304) (released 2023-09-05)

In Big Data Chart, the Case conformance measure and dimension has changed in a way that now it provides boolean values (true/false) instead of integer values (1/0). If colorMappings are used for this measure or dimension to set specific colors to visualize conformant and nonconformant cases, the mapped values need to be changed as follows: 1 -> true and 0 -> false. Without the change, the mapped colors are not effective.

Exmaple: Old configuration: 

"colorMappings": {
  "1": "#36d475ff",
  "0": "#f5403bff"
}

New configuration: 

"colorMappings": {
  "true": "#36d475ff",
  "false": "#f5403bff"
}

Big data chart support of models with local datatables (i.e., SQL Server stored) is deprecated. Big data chart has allowed to process data both in Snowflake and SQL Server. Now the support for SQL Server is deprecated and the Big data chart will only support calculation in Snowflake. If there are big data charts using SQL Server calculation, either migrate data to Snowflake or switch to in-memory charts (requiring to load data in-memory).

Following legacy analyses have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29). This functionality may be in use in SQL scripts (in --#GetAnalysis command), and thus needs to be changed to the --#RunQuery command (see the examples page how each legacy analysis can be replaced). The OperationLog analysis is replaced by the OperationLog function and the Infcluencers analysis is replaced by the FindRootCauses function.

Following script can be run in the Expression Designer to show whether there are scripts that use the removed analyses (and thus require migration): 

let removedAnalyses = [12, 14, 15, 16, 29];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");

By default, Snowflake ODBC driver generates quite much logging to files which might unnecessarily fill up the disk space. It's recommended to set the LogLevel parameter to value 0. The path where the logs are created can be seen in Windows registry (key LogPath). More information about configuring Snowflake ODBC parameters: https://docs.snowflake.com/en/developer-guide/odbc/odbc-parameters.

Features:

  • B-07971: Machine learning based Clustering analysis can be run in Snowflake.
  • B-07989: In dashboard designer the stacking order of charts can be changed with buttons Bring to front, Send to back, Bring forward and Send backward.
  • B-07977: For sankey diagram, added Start level and End level mappings to define custom start and end level for the sankey flows. Implemented also color mappings to define specific colors for specific values.
  • B-08010: To improve performance, charts are loaded and updated only when they are visible in the dashboard.
  • B-07975: Added following date related functions to Snowflake: DayOfYear, DayOfWeek, WeekOfYear, Quarter.
  • B-07908: When model is duplicated, also filters in the model are also duplicated.
  • B-07904: Filters and models API for expression language has been completed.
  • B-07991: In case and event type filter selectors, threshold whether the dropdown list or search dialog is shown can be defined using the Maximum Rows setting. Also the search dialog filters search results by other filter rules in the dashboard.
  • B-07999: Filters report has been changed to use the expression language API for filters.
  • B-07540: Added throw statement to expression language.
  • B-07813: UI components are updated. There are small visual improvements, such as in flowchart flows are routed a bit differently and in charts the hidden series is shown as strike-through in the legend.
  • B-07963: Following legacy analysis types have been removed: Operation log (analysis number: 12), Root causes (14), Correlations (15), Idea feed (16) and Duration influence (29) (see more information in the note above).

Fixed issues:

  • D-13777: Filters could not be created in charts when "Update Filter During Selection" setting was disabled.
  • D-13767: Automation per Event Types preset in in-memory incorrectly showed only one event type.
  • D-13756: Changing background color in KPI card didn't have any effect.
  • D-13812: "Exclude events" was incorrectly translated to "Exclure les cas" in French.
  • D-13815: Dashboard designer background grid was not visible in entire area in edit mode. Improved also the grid to match to snapping in move and resize.
  • D-13674: Business calendar dialog layout was incorrect when a model with a long name was selected to copy holidays.
  • D-13811: Table actions link to a new window didn't go to dashboard if there were other parameters in the link.
  • D-13601: Fixed issue where some presets may have given error when attribute value selection and the automatically selected attribute conflicted by the data type.
  • D-13753: While Snowflake model was selected, in Filters and User Rights reports the Columns list could not be opened.
  • D-13720: Now table column filter and sorting are preserved when resizing or zooming page.
  • D-13785: In tables increased number of rows to 20000 that are inspected to get available items shown in Excel-style column filter.
  • D-13759: Some statistical calculations had bad performance with large number of rows.
  • D-13787: Conformance statistics component didn't have scrollbars when text didn't fit to the visible area.
  • D-13788: In-memory "Nonconformance reason" selection caused error when two of them was selected in the same chart.
  • D-13783: When Analyzed objects was Generic analysis, column selection incorrectly caused "Analysis has not been selected" error.
  • D-13776: When measure name contained quotation mark, notification preview didn't work.
  • D-13747: Filtering with integer type of case id with case attribute value filter caused error in Snowflake.
  • D-13791: In Firefox, model selection in chart settings didn't show models in the first open.
  • D-11984: Recycle bin buttons didn't fit to the screen when screen width was small.
  • D-13780: Using CaseId case attribute in clustering analysis did not work with Snowflake 106 cases standard model.
  • D-13781: Clustering analysis produced Python error with a certain simple Snowflake model.
  • D-13730: Snowflake: Case attribute filtering didn't work when there are cases without row in cases table.
  • D-13803: There was chart configuration validation error in browser console when measures were moved into dimensions in Big data chart.
  • D-13758: There was performance issue with the Recent tasks system preset.
  • D-13793: Snowflake clustering failed when cluster count is larger than case count.
  • D-13763: SQL expression based filter rule with Where function to filter events didn't filter anything in Snowflake.
  • D-13804: Added missing Millisecond function to Snowflake.
  • D-13772: Expression EventLog.Cases.Events caused error "Value cannot be null".
  • D-13755: Model.CaseAttributes sometimes gave incorrectly Any datatype for all attributes.
  • D-13739: When switching between System reports there was error: "Uncaught Error: 2nd dimension not found. at y.getExpressionConfiguration".
  • D-12109: Sometimes flowcharts showed message "Error in querying event type measures. Input string was not in a correct format".
  • D-12473: Cost Savings by Automation preset gave sometimes error "Unable to cast object of type 'System.Double' to type 'System.String'".
  • D-13750: Snowflake model didn't work with the Case Duration vs. Manual Activities preset.
  • D-13657: There was error converting data type nvarchar to bigint.
  • D-13796: Some Snowflake operations didn't work with zero rows and columns.
  • D-12494: Now when chart size changes, the table column filters and sorting are preserved.
  • D-13736: In Performance benchmarking dialog, the Export result button exported wrong benchmark performance analysis result.
  • D-13609: Improved conformance analysis related filter names.
  • D-13594: Recycle bin buttons were not visible when opening recycle bin in a narrow screen.
  • D-13226: Tooltips in the model properties dialog are now translated.
  • D-12569: Table incorrectly showed ellipsis for narrow boolean type of columns showing checkboxes.
  • D-13391: Emptying date or datetime picker value was not registered and it didn't trigger functionality.
  • D-12621: Value search dialog didn't work with values containing backslashes.
  • D-13796: Some Snowflake operation didn't work with zero rows/columns.

QPR ProcessAnalyzer 2023.4 (build 2628) (released 2023-06-14)

Features:

  • B-07767: Added Gantt chart to visualize timeline of cases and events divided into swimlanes.
  • B-06383: Added Sankey chart to visualize flow from one set of values to another.
  • B-07941: Implemented many more presets running in Snowflake models for compliance and operational excellence use cases. There are also presets for the path analysis and process bottlenecks identification.
  • B-07864: Snowflake conformance analysis shows now reasons for conformance deviations, such as which event occurrences deviated from the design model.
  • B-07909: Snowflake conformance analysis visualizes undesired event types in table and flowchart.
  • B-07823: Flowchart Bottlenecks preset has been changed to show bottlenecks for event types. Also renewed the Tasks reports to use expression language based interface.
  • B-07891: User interface has been translated into Portuguese.
  • B-07873: Improved pivot table visual layout to highlight totals and aggregated rows. Also the row titles are now visible in the top left.
  • B-07905: Added Rank related functions to Snowflake for writing more versatile custom KPI's, e.g., FirstValue, LastValue, NthValue, Lead and Lag.
  • B-07912: Added more SQL expression array functions ArrayToString and ArrayOverlap to Snowflake.
  • B-06449: Added SQL expression functions ToTimestamp and TryToTimestamp for parsing timestamps from strings using provided format.
  • B-07959: Added new functions Base64Encode and Base64Decode to help using basic HTTP authentication when calling web services.
  • B-07206: SQL expressions support data clustering which is an unsupervised machine learning algorithm to group data based on similarities.
  • B-07848: Data can be extracted from SAP using the encrypted SNC connection.
  • B-07903: Added expression language API to create and modify filters and models.
  • B-03103: Task log (operation log) can be accessed in expression language.
  • B-07872: List aggregation with Distinct=true orders now items by their value.
  • B-07940: Removed "Count" aggregation from textual values in Big data chart (you can use the Case count, Event count, etc. selection instead).
  • B-07757: Backend support for datatables linking to user-definable Snowflake database, schema and table.
  • B-07825: Improved error message when trying to use non-existing attributes in Snowflake queries.
  • B-03101: To expression language, added try-catch-finally statement to handle thrown exceptions.
  • B-07861: Removed available and total virtual memory information from User settings dialog.
  • B-07902: Optimized sequences of joins in Snowflake queries to improve performance.
  • B-07837: Updated backend components.

Fixed issues:

  • D-13709: If image width-to-height ratio was lower than container's ratio, image was incorrectly stretched to fit the container.
  • D-13660: Disabling filter rules didn't work in Snowflake models.
  • D-13526: Passing dataframes from SQL scripts to expression scripts didn't work.
  • D-13661: Snowflake conformance analysis crashed when there was no access to conformance related Snowflake UDF's.
  • D-13693: Resolved major Snowflake conformance analysis performance issues in the BPMN model handling.
  • D-13716: Snowflake root causes analysis incorrectly bypassed Snowflake cache.
  • D-13707: In SQL Scripting, the datatable analysis (number 18) didn't always copy the data table contents to the target table correctly.
  • D-13653: Big data flowchart Root causes preset showed incorrect legend.
  • D-13626: Flowchart froze when converting into big data flowchart and vice versa by modifying chart json settings.
  • D-13656: Root causes for attribute gave error "Failed to compare two elements in the array" in some situations.
  • D-11563: Pivot table had a minimum height of 300px, which caused bottom part of it to be out of view.
  • D-13704: In CSV file import, parsing now allows spaces between column separator and text quotation mark.
  • D-13598: Chart gave unclear error message when events datatable was not defined.
  • D-13655: Improved error messages for BPMN editor and conformance statistics.
  • D-13528: Error message for certain erroneous SQL expressions was unclear.
  • D-13677: "Flow occurrences with specific case attribute value" selection didn't work for in-memory chart.
  • D-13663: Pivot table border line was slightly broken in the header area.
  • D-13608: There was incorrect alignment of items in the table paging controls.
  • D-13703: Importing CSV file with some special characters to Snowflake failed (due to incorrect escaping in Snowflake staging files).
  • D-13708: Duplicating datatable using user defined table, removed data the source table.
  • D-13717: Dependency wheel crashed when there were zero weights and showing data labels.
  • D-13348: There was an unclear error message when Snowflake query had a certain incorrect expression.
  • D-13732: Pivot table Excel export contained headers formatted incorrectly.
  • D-13729: There was a JavaScript error when limited user tried to access business calendar.
  • D-13662: Percentile function didn't always work with timespan types.
  • D-13646: Using incorrectly configured model without cases datatable caused null reference error.
  • D-13629: When tried to use chart with a non-existing model, there is now a proper translated error message.

QPR ProcessAnalyzer 2023.3 (build 1990) (released 2023-05-03)

Features:

  • B-07818: Conformance analysis is supported in Snowflake with following dashboard components: Big data chart, BPMN editor, Conformance statistics, and Design model selector.
  • B-07833: Root causes analysis for flowchart is available for Snowflake showing how the event and flow occurrences explain selected phenomena.
  • B-07786: Big data chart has more measure aggregations, such as median, percentile, standard deviation and variance. Also for textual items, unique values can be listed.
  • B-07795: Conditional formatting supports also columns with non-numerical contents.
  • B-07830: None and Any aggregations for Snowflake and user-friendly formatting for conformance violations.
  • B-06527: Error messages in CSV file import show also the column number to help working with CSV files with lot of columns.
  • B-07747: In-memory conformance checking accepts design models with multiple tasks having same name (same is followed by the Snowflake implementation).
  • B-07659: In-memory flowchart preset Case Conformance to visualize conformance checking violations.
  • B-07571: Added function IsConformant to backend to check whether cases are conformant.
  • B-07863: Added function ConformanceViolationsFlows to backend to return nonconformance reasons for violating cases.
  • B-07844: Support for "array" aggregation to return aggregated items as array.
  • B-07856: Support for creating and accessing arrays and objects in SQL expressions.
  • B-07860: Array handling functions and Tasks property for DesignModel entity.
  • B-07847: Added throttling for QPR ScriptLauncher client-side imports to limit memory usage.
  • B-07811: Snowflake query optimization to omit columns that are not used by the query.

Fixed issues:

  • D-13632: Going from variations to event types led to very poor performance with certain models.
  • D-13628: Statistical calculations were incorrectly not applied in chart CSV export.
  • D-13575: SQL script may have given error "Operand type clash: nvarchar(max) was incompatible with sql_variant".
  • D-13597: UI supports now datatable column type "ShortString" (previously datatable contents preview and CSV import didn't work).
  • D-13536: Using business calendar sometimes gave error "System.InvalidOperationException: Collection was modified".
  • D-13477: Chart types without y-axis mapping caused an error when series mapping was used.
  • D-13453: _model variable was not available for Snowflake expression filter rules.
  • D-13527: Checkbox height didn't increase when long label needed to span to multiple lines.
  • D-13363: Snowflake query with EvaluateAfterAggregations and IsHidden failed when dimensioning by case id column.
  • D-13383: Snowflake query gave error "Invalid column name 'FromCase Name'".
  • D-13523: Request id was incorrectly shown as zeros in error messages.
  • D-13541: In CSV import, error message for maximum number of columns exceeded is improved (maximum is 300 column for SQL Server).
  • D-13583: Objects count in header didn't work for empty Snowflake model.
  • D-13553: Larger pacm files can now be imported, as there isn't error "Request body too large. The max request body size is 30000000 bytes".
  • D-13306: Stack overflow error was given when using SqlDataFrames.
  • D-13487: When Flows root and there was filter in Values expression, some flows were lost.
  • D-13540: SqlDataFrame query with 300 columns failed to error "WithExpressionColumn: No name given for the new column".
  • D-13429: Ordering in List aggregation couldn't find columns in dataframe query.
  • D-13406: Dataframe query with root FlowOccurrences and get value from cases caused error.
  • D-13538: There was incorrect handling of escaping characters in column names used in dimensions.
  • D-13633: Fixed ordering in List aggregation with null and empty values.
  • D-13636: Query that dimensions by numeric case attribute with AggregateOthers true, caused error.
  • D-13589: Creating Snowflake datatable did not connect to Snowflake.
  • D-13623: Value expressions without aggregation didn't work with AggregateOthers setting.
  • D-13554: In in-memory chart, percentile function might have return both Int64 and Double type of objects which cannot be sorted.
  • D-13481: Improved error message when trying to use deleted model.
  • D-13621: Dynamic value search dialog had incorrect font in lists.
  • D-13610: Some invalid BPMN files crashed BPMN editor.
  • D-13614: Checkbox label texts overflowed to right.
  • D-13520: Removed excessive parameters from the Query Designer for generic context queries.
  • D-12998: QPR icon was incorrectly positioned in header in Safari.
  • D-13480: Import to duration data type is removed from Snowflake datatables, and for local datatables duration type maximum size is checked.
  • D-13517: In Highcharts-based visualizationsm conditional formatting didn't work for other than the first y-axis mapping.
  • D-13529: In some presets containing several on-screen settings, when chart showed in error message, on-screen settings showed invalid selection.
  • D-13530: Opening dropdown list caused JavaScript error when the list contents should be empty after it previously contained items.
  • D-13486: Removed unreachable error message in CSV import.
  • D-13524: Fixed in-memory chart flow occurrences root measures "Event attribute (text)" and "Event attribute (number)" that caused error.

QPR ProcessAnalyzer 2023.2 (build 1478) (released 2023-03-22)

Features:

  • B-07755: Business calendar for duration calculation is available for Snowflake models.
  • B-07719: In Snowflake dashboards, measures can be assigned to variables and use the variables in other measures to create combined measures.
  • B-07746: Changed in-memory conformance checking to not show invalid flow violations where starting or ending event type is invalid.
  • B-07743: Default datasource can be configured for datatables created by scripts, allowing to set Snowflake as default.
  • B-07740: System memory indicator moved from the header to User settings Version information dialog.
  • B-07776: New SQL expressions functions Unicode, Char and Regexp, as a basis for future rule-based process mining.
  • B-07741: Backend support for aggregation operations Median, Percentile, Stdev, Stdevp, Var and Varp to Snowflake.
  • B-07742: Backend support for aggregation operation to list unique items in Snowflake.
  • B-07770: Optimized Snowflake SQL generation by combining consecutive WithColumn function calls into one select.

Fixed issues:

  • D-13491: QPR ProcessAnalyzer server crashed now and then when sorting was in progress and the query was cancelled.
  • D-13380: Dimensioning integers in in-memory core calculation didn't work correctly as 0 and -1 were put to same bucket.
  • D-13385: In Workspace Bin, Delete Forever and Restore from Bin buttons were misaligned.
  • D-13332: Conformance checking didn't show in violations when there were multiple undesired events in same case.
  • D-13405: Images take now always all available space in image component area.
  • D-13417: KPI card without title was slightly misaligned vertically.
  • D-13438: Clicking selected event type or flow in flowchart didn't cancel the filter selection.
  • D-13350: Task log and Script log default filter end date is now empty by default.
  • D-13381: Disabled browser auto-complete from flowchart variation stepper and Workspace create/rename object dialog.
  • D-13347: Improved performance for in-memory business calendar calculation.
  • D-13335: In in-memory chart, filtering didn't work in "Flow occurrences" root "Flow occurrences with specific event attribute value" dimension.
  • D-13367: Percentage value wasn't displayed properly with German or Spanish language when event types were shown in object counts indicator.
  • D-13451: Exported filter file is now named based on selected filter name.
  • D-13378: In Big data chart, prevented error "Unable to aggregate from level RootCauses to level Custom".
  • D-13293: DataFrame query with root Flows and IncludeEvents and ExcludeEvents filter rules failed.
  • D-13370: Fixed issue where on-screen settings that didn't have any selectable items, showed a strange selection.
  • D-13392: Clustering analysis was incorrectly shown when originally in-memory chart was converted into big data chart by changing chart json settings.
  • D-12784: Some Snowflake queries incorrectly bypassed Snowflake caching because they used unique object names.
  • D-13456: Improved error messages for incorrectly configured on-screen settings.
  • D-13445: Conformance violations related translated terms have been fine-tuned for better translations into different languages.
  • D-13421: Improved error messages when trying to use model having some column mappings missing.
  • D-13485: Snowflake business calendar gave error when calendar contained Sunday.
  • D-13218: Windows event viewer incorrectly contained log entries that are not errors.
  • D-12634: Multiline text boxes width is set to non-changeable.
  • D-13034: Confirmation dialog to delete items permanently has been updated.
  • D-13288: In dialogs, the Create button didn't show the disabled state correctly.
  • D-13427: When dropdown lists didn't have any selectable items, the "N/A" text appeared and the list incorrectly took more space vertically.
  • D-13483: In Workspace, the new items menu was too narrow for Spanish texts.

Additional release for QPR ProcessAnalyzer 2023.1 (build 1449) (released 2023-02-24)

Features:

  • B-07690: System setting DatabaseId can be defined by administrator to get more simple table names in Snowflake.
  • B-07737: In flowchart Bottlenecks preset, originally used flow colors has been recovered.
  • B-07748: For Analyzed objects "Conformance checking findings" in charts, terminology has been revised and issue with the case count calculation fixed.
  • B-07663: In on-screen settings, when case/event attribute is selected, related attribute values list are reset.
  • B-07570: Backend support for business calendars in Snowflake.
  • B-07660: Backend support for conformance checking to show also the last event index and event type in NotCompleted reason.
  • B-07610: Memory counter related technical properties have been removed from expression language.

Fixed issues:

  • D-13349: Opening dashboard containing Root causes preset with default settings jammed the system by generating lot of calculations (for more information, see previous release notes).
  • D-13277: Stacked charts with date type of data as series did incorrectly show gaps in columns/bars.
  • D-13270: Flowchart conditional formatting didn't work with duration multi-unit format.
  • D-13358: Calculation results caching works also across different user sessions.
  • D-13250: Dashboard with two charts connected with linked settings using variables ended up to to a never ending loop.
  • D-13230: SAP import did not automatically create columns to use the correct column types.
  • D-12857: Deeply recursive functions caused a crash without any trace.
  • D-12994: In Workspace, some buttons were not clickable due to breadcrumb covering them.
  • D-13249: In Workspace, there was incorrect error message for duplicate datatable names when there were items with only letter capitalization was different.
  • D-13232: In-memory chart Top variations preset is now sorted secondarily by average duration descending.
  • D-13300: Setting DashboardFilter variable to empty value didn't have any effect in dashboard but old value was incorrectly used.
  • D-12834: Limited the maximum number of dimensions to 20, to avoid too demanding queries for SQL Server.
  • D-12917: Changed visual indication of missing items in dropdown lists (it's no longer showing "***").
  • D-13111: In Root causes preset, there is now error message when trying to use weighting related columns when weighting isn't in use.
  • D-13124: SQLDataFrame query containing filter rule EventTypes aggregating from cases failed.
  • D-13207: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed.
  • D-13292: Dataframe query with AggregateOthers, AggregationFunctionForOthersRow and EvaluateAfterAggregations failed (rev.2).
  • D-12991: Dropdown list texts had some translations missing.

QPR ProcessAnalyzer 2023.1 (build 1433) (released 2023-02-07)

This release contains a potentially severe issue, where some dashboards completely jam the system by generating lot of calculations. The issue may appear in dashboards that have been created in earlier releases and containing the Root causes preset with default settings. The issue will be fixed by the next release. The issue can be worked around by exporting the affected dashboard, modifying the dashboard file manually and importing the dashboard back. The required modification is to remove line(s) containing 
"preset": "RootCauses"
and the comma from the preceding line.

Following legacy analyses have been removed: Cases (analysis number: 5), Events (6), and EventTypes (7). This functionality may be in use in SQL scripts (in --#GetAnalysis command), and thus needs to be changed to the --#RunQuery command (see the examples page how each legacy analysis can be replaced). Note that the legacy analyses removal don't affect the dashboarding functionality.

Following script can be run in the Expression Designer to show whether there are scripts that use the removed analyses (and thus require migration): 

let removedAnalyses = [5, 6, 7];
OrderByDescending(Flatten(Projects.Scripts).Where({
  let scr = _;Sum(removedAnalyses.("'AnalysisType','" + _ + "')").{let num=_;(scr.code ?? "").Replace(" ", "").Replace("\t", "").Replace("\n", "").Replace("\r\n", "").Replace("\r", "").Contains(num)})>0;
}),LastRunStart).(Project.Name + ": " + name + " (id: " + id + ") (last run: " + (LastRunStart ?? "N/A") + ")");

Starting from QPR ProcessAnalyzer 2023.1, the .NET Desktop Runtime is not needed anymore for QPR ProcessAnalyzer Server, so it can be uninstalled. Also for QPR ScriptLauncher, .NET Desktop Runtime is not needed, but instead install the .NET Runtime (which is more lightweight). .NET Desktop Runtime contains the .NET Runtime, so the actions are not mandatory when updating to QPR ProcessAnalyzer 2023.1.

Features:

  • B-06997: Expression-based filter rules for Snowflake dashboards to allow versatile filtering and filtering from custom expressions.
  • B-07383: Improvements to linked settings to allow binding to variables, tags and filter rules (more information).
  • B-07508: Flowchart preset colors have been renewed to be more intuitive.
  • B-07184: Automation preset in flowchart has now options for selecting the Automation attribute and value.
  • B-07512: Changed datatable metadata can be refreshed from Snowflake, and all rows in the datatable can be deleted easily in Workspace (more information).
  • B-07440: Date when the release was made is now shown in User settings.
  • B-07595: WeekOfYear property for DateTime objects in expression language to get the week number of a year (between 1 and 53).
  • B-07623: In-memory expression language functions Random (to get random numbers) and Hash (to get hash value of string).
  • B-07612: Breadcrumb in Workspace has now a Home button to quickly navigate to the top level of the projects hierarchy.
  • B-07637: Language selector now shows the language options in local languages.
  • B-07228: Remove following deprecated analyses: Cases, Events, and EventTypes (see the release note above).
  • B-07538: Backend support: Snowflake root causes analysis can find event attribute related root causes.
  • B-07706: Backend support: Snowflake expression-based filter rules support for roots containing Where function.
  • B-07611: Removed following legacy filter rules: CaseAttributeTrend, EventAttributeTrend, EventTypeTrend, and Duration.
  • B-07598: Refactored client-side import for SQL scripting to use generic client-side task mechanism.
  • B-07716: ShortString columns are now properly detected in SQL Server queries.
  • B-07652: Now it's possible to pipe multiline expression strings to QPR ScriptLauncher.
  • B-07688: AddColumns function for Datatables to create multiple columns in one call.

Fixed issues:

  • D-13092: Table conditional formatting didn't work when color code was fetched from other column.
  • D-13105: Some charts created in earlier release referring to non-existing presets names appeared as empty after software update.
  • D-13107: Flowcharts crashed and showed loading animation forever when setting color or flow thickness to non-numerical measure.
  • D-13104: In BPMN model editor, context menus to edit elements didn't appear.
  • D-12939: Script editor tabs Close buttons didn't work.
  • D-13154: "Search by case ID" didn't work in in-memory chart.
  • D-12933: CSV columns with only empty values were incorrectly auto-detected as integers.
  • D-12929: In-memory chart Root causes for case duration and Root causes for case attributes (weighted) had Custom expression missing.
  • D-12928: Pivot table headers were empty when there were two column levels and two values.
  • D-12924: Pivot table columns with Count and Distinct Count aggregations are now numeric and aligned right.
  • D-13033: Changing colors in chart settings Color palette caused "Item already exists" error and prevented changing colors.
  • D-12996: Tags referring to dashboard variables didn't work in Additional root expression.
  • D-12877: UI gave error in some situations: Uncaught TypeError: Cannot read properties of undefined (reading 'min').
  • D-13071: Prevented selecting two or more of the Y-axis, X-axis and series mappings at the same time for the same measure or dimension.
  • D-12895: Big data chart crashed when on-screen setting contained event type selector and there were no event type filter set.
  • D-13231: Tooltips for dashboard name, model selector and filter selector in header show now the content text instead of generic instruction.
  • D-13139: There was an error when tried to create filter for a custom expression where selected data type didn't match with the actual type of data.
  • D-12988: Chart presets selection in chart settings showed unnecessary tooltip.
  • D-12901: When set sampling over 1 million, Snowflake models gave error: parameter value out of range: size of fixed sample. Must be between 0 and 1,000,000.
  • D-12904: Creating expression filter having lower/greater logic with root objects sampling failed.
  • D-12923: Chart schema didn't accept pivotAggregation in dimensions/columns.
  • D-12926: Root causes columns Selected weight, Compared weight and Total weight have now correct float data type.
  • D-12880: In out-of-the box dashboards, chart titles and subtitles were not translated.
  • D-12916: Improved filter rule description text in Filter rule editor dialog for expression filter rules.
  • D-12889: No clear error message was given when user tried to export corrupted model from .pacm file.
  • D-12869: Date selector in on-screen settings had inconsistent vertical alignment.
  • D-12938: When creating a filter with lasso and selecting a single data point only, "equals" kind of filter rule is now created.
  • D-12989: "Running tasks as specific time" system report may have ended up in loop causing following error: Maximum call stack size exceeded error.
  • D-13010: Pivot table sometimes ended up to never-ending resizing loop when browser zoom was more than 100%.
  • D-12790: Expression language: DataFrame.SetColumns: Initializing and using variables defined in closure of SetColumns function parameter didn't work
  • D-12927: All on-screen settings were not be visible in narrow charts having several on-screen settings.
  • D-12937: Added maximum value limitation to several number input fields in charts.
  • D-12947: Message dialog didn't show line breaks correctly (e.g., in CSV file import).
  • D-12948: Defining column setting caused error when Measure Expression was not defined.
  • D-12946: Filter rule text couldn't be seen entirely from tooltip.
  • D-12983: When range filtering using integer values in Highcharts chart, filter is now shown as integer value.
  • D-12984: When range filtering in Highcharts charts and there is category axis, filter rule is now based on individual (category) values.
  • D-12930: When creating filters from charts using date type of X-axis with lasso, "greater than or equal" and "less than or equal" filter rules are not created.
  • D-12920: "Where" function in DataFrame lost column data types of the original DataFrame.
  • D-13048: Model notifications failed with certain measures that define variables in root expression leading to error: Variable "sampleSize" already exists in this context.
  • D-13116: BPMN editor had some translations missing.
  • D-13019: Datatable and script selectors show now datatable/script name instead of id, when opening selector having existing selections.
  • D-12951: Changing additional root expression in flowchart didn't refresh the flowchart.
  • D-13147: Filter rule boxes in header had different widths, and Add filter rule button vertical alignment was incorrect.
  • D-12907: Sometimes case attribute selection showed incorrect attribute name for empty model.
  • D-13148: Filters and Datatables system reports loaded unnecessarily twice which could be seen as blinking.
  • D-12844: In dataframe query, FlowOccurrences in root and GetValueFrom Cases with filter gave null reference exception
  • D-12915: Repeating certain query twice with aggregations in Events root generated invalid SQL
  • D-12728: Was huge amount logs in server during client side import (manual testing required as identification)
  • D-13156: Persist function failed to snowflake: Invalid unicode escape sequence '\u0027ACCE'; should be at most '\u0010FFFF'.
  • D-12876: Flows/FlowOccurrences in root didn't work with SqlExpressionValue filtering.

Old Releases

See older releases in QPR ProcessAnalyzer Release Archive

Retrieved from "https://wiki.onqpr.com/pa/index.php?title=QPR_ProcessAnalyzer_Release_Notes&oldid=24557"