The new Groovy API method streamSqlQuery(SqlQuery) executes the given SqlQuery and returns a result, so that one row at a time can be examined. The typical usage is to consume the result row by row and processing it into some accumulating data structure.

PFUN-8686

Charts: Standard table options (sorting, grouping, column resizing, etc.) are available for the Group By and Measure tables.

PFUN-11940

Price Setting: A notification is displayed when calculation or file export finishes.

PFUN-18826

Calculation Grids: Groovy API methods markItemDirty and markItemClean can now have up to 6 keys as parameters.

PFUN-19174

Distributed calculation is supported by Calculation Grids.

PFUN-19467

Actionable Insights: Only measures from the series that are joined are shown in the code editor of the Join Series Measure.

PFUN-20390

Multiple data series can be defined in Data Analyzer Data Tables.

PFUN-20458

Custom Forms: Submit, Revoke and Withdraw buttons are available on the list page when a Custom Form is selected.

PFUN-20683

View preferences in Model Objects are saved for all the steps instead of for each step’s tab separately. It makes them easily deployable as part of an accelerator and simpler to manage for end users.

PFUN-20707

Quotes, Rebate Agreements, Agreements/Promotions, Compensation Plans (React): The Create New Revision button can be hidden using the Groovy API method setRenderInfo.

PFUN-20879

Quotes, Rebate Agreements, Agreements/Promotions, Compensation Plans (React): Text box for workflow comments is now larger to improve the editing experience.

PFUN-21069

Data Change Requests: The existing endpoint has been extended to support asynchronous processing: dcrmanager.submit/${dcr.id}/async. The DCR size threshold from which asynchronous processing is applied is set by the advanced config option asyncSubmitDCRThreshold with the default value of 100.

PFUN-21118

Custom Forms have new fields originCustomForm, originDeleted, originLabel and originUniqueName. These fields are filled when a Custom Form is duplicated from another Custom Form.

PFUN-21134

It is newly possible to add translations for labels in the Add Folder and Move Folder actions’ dialogs.

PFUN-21164

Quotes, Rebate Agreements, Agreements/Promotions, Compensation Plans (React): Possibility to hide the “Copy all items to clipboard” and “Import items from clipboard” buttons using the Groovy API method setRenderInfo.

PFUN-21177

The options in the Set drop-down list are now in alphabetical order, with the 'Default' item on the top in Rebate Records, Rebate Calculations, Compensation Records and Compensation Calculations.

PFUN-21200

Pricing Strategy Designer: Custom dimensions are supported in Strategy Selection.

PFUN-21296

A limit to the number of Actions generated by Groovy or REST APIs during a defined period of time has been introduced to protect the system from overloading. The default limit is 500 Action items created per 5 minutes. The limit can be changed in the pricefx-config.xml configuration file. Note that the limit applies to each cluster pod, so with a cluster with 2 frontend pods, the limit will be twice as much, i.e., 1000 Action items by default.

PFUN-21360

Analytics: A warning is displayed when a Data Table query returns more rows than the limit set by the application property paDataAnalyzerMaxRows.

PFUN-21362

Validation has been added to JSON tab configuration that checks that flexibleLayout, siderAlwaysWithTabs and hideSiderPanel properties have correct Boolean values (e.g., true without quotation marks).

PFUN-21399

Only the following subset of HTML tags is now supported in header notifications in Quotes, Rebate Agreements, Compensation Plans, Agreements/Promotions: <br>, <li>, <b>, <em>, <i>, <strong>. Any other currently used tags will be removed so that they are not displayed as text in the messages.

PFUN-21402

Groovy API support to generate filter from resultMatrix in the UI has been implemented.

PFUN-21622

A confirmation message is displayed when you trigger a mass action (e.g., mass submit) on the Rebate Records and Compensation Records list pages.

PFUN-21667

New REST API endpoint optimization.modelrevoke/{typedId} for revoking Models has been added.

PFUN-21695

Configuration > Publishing Templates: It is not possible to select a value when templates are filtered.

PFUN-13433

Custom Forms list: Error 400 when filtering/sorting by Source ID w/o Revision, Superseded/Invalidated By, Previous Revision columns.

PFUN-15294

Models: Next step is available when calculation is still required in the current step.

PFUN-20044

Localization: Turkish label is displayed instead of the Finnish one in Quote detail > Items tab > Last Update Date column when using Finnish UI language.

PFUN-20616

When a form with Configurator that contains DMQueryBuilder is not valid, i.e. one of its required inputs has empty value, the validation state is not correct at the time when the form is ready (OnFormReady).

PFUN-20815

Global Dimension Filter is not applied for all series in Dashboard.

PFUN-20840

Cannot use customFormApi to updateData of a Custom Form being currently calculated.

PFUN-20958

Actionable Insights Watchers: App crashes when opening a non-existing URL.

PFUN-21000

Access to output element in Rebate Records only by specific group does not work.

PFUN-21091

Custom Form duplication does not trigger recalculation.

PFUN-21144

Workflow > Add Approver dialog: Impossible to set multi-approval for User Group in UI (validation error).

PFUN-21245

Analytics Charts and Rollups > Measure: Not possible to drag and drop rows which have the same fields.

PFUN-21289

Quotes: Option Input field is not able to handle character "." in data.

PFUN-21301

Models: Dropping several tables and creating them afterward in the same calculation logic bugs.

PFUN-21336

TypeError: Cannot read properties of undefined (reading 'inputs') when adding an Item to Rebate Agreements.

PFUN-21375

Action Items detail: User with, for example, Manage Quoting role gets "Not authorized for command: QUOTE_FETCH" when opening Action created in Quote.

PFUN-21395

Quotes (React): Different input types with the same input name are not supported.

PFUN-21405

Groovy API documentation: Example for createUserEntry method is not working.

PFUN-21418

RequiredInput line item missing red highlight at the beginning of the line.

PFUN-21420

Visual Configuration: Invalid expression can be created when block is placed outside of "expression".

PFUN-21429

Visual Configuration: Using of "SQL0" block is breaking the expression.

PFUN-21431

Customize Attribute Extensions menu item should not be available for Module Category list columns as customizing attribute extensions is not supported in Module Categories.

PFUN-21440

api.add/api.addOrUpdate fails when column size is exceeded but error is not shown in application.

PFUN-21442

Strategy Designer: Label containing only a number is not visible in the table field.

PFUN-21470

Data Analyzer: Trash bin disabled when switching to Visual mode for the second time.

PFUN-21472

Charts in Dashboards: When clicking on the “x” icon of one value in the Dim Filter, all values are removed.

PFUN-21483

Quotes, Rebate Agreements, Agreements/Promotions, Compensation Plans: User can select non-existing (null) items when using any dropdown list with magnifying glass.

PFUN-21538

JSTs are not getting processed in the correct order when the cluster-level pod creation rate limit is reached.

PFUN-21582

Quotes: Import of items from clipboard after error - page freezes.

PFUN-21585

The Source tab of an Internal Copy Data Load freezes when it is opened if there is a filter setting or when the user applies a filter in the table.

PFUN-21626

Visual Blockly Component: Syntax error is displayed for the COUNTDISTINCT({field}).

PFUN-21627

Visual Blockly Component: Root element is generated after selecting a new item from Command Templates.

PFUN-21628

The "Job Details" panel on the "Jobs & Tasks" page can't be scrolled.

PFUN-21638

Rename setHideDeleteButton() to setHideRemoveButton().

PFUN-21649

Investigate for support user role cannot access Module Category detail (in read-only mode).

PFUN-21658

Heartbeat: Configured limits are not honoured.

PFUN-21669

Price List product picker filter in preferences are not applied.

PFUN-21724

Analytics Calculation with Row context and Batching enabled is dropping values from field which are not formula outputs or business keys, on Green Plum with batching.

PFUN-21777

Model Class: No confirmation dialog when clicking on Revoke.

PFUN-21804

Unable to export Highmap dashboard portlet to PDF.

PFUN-21815

When you create a scheduled Calculation Flow job and run it manually, it keeps getting run every 2 minutes regardless of the schedule setting.

PFUN-21126

When using api.find with more than 65356 of parameters in filters, the query fails with "org.hibernate.exception.DataException: could not prepare statement".

PFUN-21236

In a Custom Form Objects list, filtering/sorting by rootUniqueName does not work properly.

PFUN-21665

In a Dashboard, hidden input fields are not available in the second run (application of preferences).

PFUN-21792

Data Load Flush to Data Source keeps failing.

PFUN-21837

Groovy Sandbox: list.with with closure(s) is not compilable. 

PFUN-21895

Some notifications are not sent correctly to the Notifications center.

PFUN-21906

When running a DMM model, you get a NullPointerException.

PFUN-21917

Price Grid / Matrix Price Grid parameters return an error during LPG configuration.

PFUN-21932

Job Status Tracker items are not processed in a correct order. 

PFUN-21988

RedisAppender (used by the /servelog endpoint to serve the logs to the UI) does not log errors, instead they are silently dropped.

PFUN-22003

PA Calculation Data Load fails for calculations based on a Rollup source and with batching enabled.

PFUN-22035