Infrastructure updates

Prev Next

Explore this page to stay updated on IQ Interface infrastructure updates, which we introduce to enhance the stability and performance of our platform.

Note

Access to linked detail information is restricted. For additional information about a specific change or fix, contact your Zilliant representative.

Q4 2024

12.12.2024

  • ZPPS-124015 Worksheet User Settings - Create POST /api/v4/user/settings/workbook/:id/worksheet/:id endpoint (Including validation)
  • ZPPS-124025 Organization Settings - GET /api/v4/organization/settings endpoint
  • ZPPS-124026 Organization Settings - PATCH /api/v4/organization/settings endpoint (Including validation)
  • ZPPS-124027 Source Data - Create POST /api/v4/workbook/:id/worksheet/:id/sourceData endpoint (Including validation)
  • ZPPS-124028 Source Data - Create PATCH /api/v4/workbook/:id/worksheet/:id/sourceData endpoint (Including validation)
  • ZPPS-124030 Source Data - Create DELETE /api/v4/workbook/:id/worksheet/:id/sourceData endpoint
  • ZPPS-124034 Global User Settings - Create GET /api/v4/user/settings/global endpoint
  • ZPPS-124035 Global User Settings - Create POST /api/v4/user/settings/global endpoint (Including schema creation and validation)
  • ZPPS-124036 Global User Settings - Create PATCH /api/v4/user/settings/global endpoint (Including schema creation and validation)
  • ZPPS-126439 v4 Folder User Settings QA Automation
  • ZPPS-126441 v4 Global User Settings QA Automation
  • ZPPS-126610 Add $primary parameter on KPI Cards LEDS calls
  • ZPPS-126611 Add $primary parameter on Single Cell Update GET LEDS calls
  • ZPPS-126612 Add $primary parameter on Bulk edit GET LEDS calls
  • ZPPS-126614 Add $primary parameter on Mass Update GET LEDS calls
  • ZPPS-126615 Add $primary parameter on Insert and Deletion GET LEDS calls
  • ZPPS-126899 Documentation for Configurable Parameter for Tableau URLs
  • ZPPS-126910 v4 Organization Settings QA Automation

11.19.2024

  • ZPPS-122857 Fix Grid.js skipped test
  • ZPPS-123318 Add schema validation to PATCH /api/v4/workbook/{workbookId}/worksheet/{worksheetId}/customButtons/externalLink
  • ZPPS-123319 Add schema validation to PATCH /api/v4/workbook/{workbookId}/worksheet/{worksheetId}/customButtons/externalLink/{externalLinkId}
  • ZPPS-124013 Worksheet User Settings - Create GET /api/v4/user/settings/workbook/worksheet endpoint
  • ZPPS-124014 Worksheet User Settings - Create GET /api/v4/user/settings/workbook//worksheet/ endpoint
  • ZPPS-124019 Folder User Settings - Create GET /api/v4/user/settings/folder/ endpoint
  • ZPPS-124021 Folder User Settings - Create GET /api/v4/user/settings/folder/children endpoint
  • ZPPS-124022 Folder User Settings - Create POST /api/v4/user/settings/folder/ endpoint (Including validation)
  • ZPPS-124023 Folder User Settings - Create PATCH /api/v4/user/settings/folder/ endpoint (Including validation)
  • ZPPS-124024 Folder User Settings - Create DELETE /api/v4/user/settings/folder/ endpoint
  • ZPPS-124187 Organization Repository
  • ZPPS-125388 Add success alert message when setting worksheet settings as default
  • ZPPS-125775 Developer Documentation: Worksheet User Settings
  • ZPPS-125776 Developer Documentation: Folder User Settings
  • ZPPS-125777 Developer Documentation: Organization Settings
  • ZPPS-125779 Developer Documentation: Source Data
  • ZPPS-126303 Create Common Error Messages File for API Responses
  • ZPPS-126351 Modify Analytics Worksheet Schema
  • ZPPS-126352 Modify Analytics Navigation Schema
  • ZPPS-126353 Modify Analytics Worksheet Wizard
  • ZPPS-126354 Modify Analytics Worksheet Property Page
  • ZPPS-126355 Modify Analytics Navigation Property Page
  • ZPPS-126589 Add false positives to .gitleaksignorea

10.17.2024

  • ZPPS-122402: Created a POST endpoint (/api/v4/folder/) for folder creation, including validation.
  • ZPPS-122731: Added Confluence documentation for user creation and assignment permissions using Rundeck and Postman.
  • ZPPS-122739: Replaced the usage of headerHeight across the application with autoHeaderHeight and wrapHeaderText properties.
  • ZPPS-123210: Created a DELETE endpoint (/api/v4/folder/:id) for folder deletion.
  • ZPPS-123211: Developed QA Automation for v4 folders.
  • ZPPS-123314: Added schema validation to the PATCH endpoint for custom row buttons in workbooks.
  • ZPPS-123317: Added schema validation to the POST endpoint for external link custom buttons in workbooks.
  • ZPPS-123384: Disabled the "Go back" link in workbook scenarios when the user lacks sufficient permissions.
  • ZPPS-123891: Removed the "filters" and "shouldDeleteView" properties from Analytics Worksheets.
  • ZPPS-123892: The "worksheetId" property is now sent when patching worksheet general properties.
  • ZPPS-124005: Created a GET endpoint (/api/v4/workbook/:id) for retrieving workbook data.
  • ZPPS-124006: Created a POST endpoint (/api/v4/workbook/) for workbook creation, including validation.
  • ZPPS-124007: Created a PATCH endpoint (/api/v4/workbook/:id) for workbook updates, including validation.
  • ZPPS-124008: Created a DELETE endpoint (/api/v4/workbook/:id) for workbook deletion.
  • ZPPS-124009: Created a GET endpoint (/api/v4/folder/:id) for retrieving folder data.
  • ZPPS-124018: Created a GET endpoint (/api/v4/user/folder/all) for retrieving all folder user settings.
  • ZPPS-125170: Performed GitHub branching clean-up.
  • ZPPS-125773: Updated documentation related to workbooks.
  • ZPPS-125975: Developed QA Automation for v4 workbooks.

Q3 2024

09.19.2024

  • ZPPS-123984 [PES-6892] Cell editor is closed after editing a row with calculated columns
  • ZPPS-124282 API - Add style schema validations for worksheets(v4)
  • ZPPS-124284 Implement row styling for String(String, Resource link, Dropdown, Typeahead) fields conditions.
  • ZPPS-124285 Implement row styling for Numeric(Currency, Percetager, Integer, Float) fields conditions.
  • ZPPS-124286 Implement row styling for Date and Datetime fields conditions.
  • ZPPS-124289 Add row styling for Aggregate worksheets.
  • ZPPS-124293 Implement row styling for Boolean columns
  • ZPPS-124943 Row-Level Highlighting Developer Documentation

08.29.2024

  • ZPPS-122259 Remove WorksheetExportData permission from application.
  • ZPPS-123315 Add schema validation to PATCH /api/v4/workbook/{workbookId}/worksheet/{worksheetId}/customButtons/row/{rowActionButtonLabel}
  • ZPPS-123355 Add schema validation to PATCH api/v4/workbook/:workbookId/worksheet/:worksheetId/fields.
  • ZPPS-124258 Allow null values for fields properties.

07.24.2024

  • ZPPS-123717 Resolved bugs in v4 validations around fields.
  • ZPPS-123722 v4 endpoints allow users to specify id or viewName.
  • ZPPS-123739 v4 endpoints allow some properties for grid worksheets.
  • ZPPS-121738 Improved error messaging when adding a row with a duplicate business key.
  • ZPPS-121745 Improved error messaging when adding a value that exceeds the field length.
  • ZPPS-122669 Built in Cell Editor for Number
  • ZPPS-122673 SPIKE: Investigate about Rich Select Editor
  • ZPPS-123313 Added schema validation to POST /api/v4/workbook/{workbookId}/worksheet/{worksheetId}/customButtons/row

07.10.2024

  • ZPPS-120694 Implement POST api/v4/workbook/:workbookId/worksheet for GRID type Worksheet
  • ZPPS-120697 Implement GET api/v4/workbook/:workbookId/worksheet/:worksheetId
  • ZPPS-120699 Implement PATCH api/v4/workbook/:workbookId/worksheet/:worksheetId for GRID type Worksheet
  • ZPPS-120702 Implement DELETE api/v4/workbook/:workbookId/worksheet/:worksheetId for GRID type Worksheet
  • ZPPS-120703 Implement PATCH api/v4/workbook/:workbookId/worksheet
  • ZPPS-120704 Implement PATCH api/v4/workbook/:workbookId/worksheet/:worksheetId/fields for GRID type Worksheet
  • ZPPS-120706 Implement POST api/v4/workbook/:workbookId/worksheet/:worksheetId/field for GRID type Worksheet
  • ZPPS-120707 Implement PATCH api/v4/workbook/:workbookId/worksheet/:worksheetId/field/:systemName for GRID type Worksheet
  • ZPPS-120708 Implement DELETE api/v4/workbook/:workbookId/worksheet/:worksheetId/field/:systemName for GRID type Worksheet
  • ZPPS-121382 Update the "axios" package within ZPMS to the latest version
  • ZPPS-121608 Remove cloneDeep from getSheetsOfSelectedWorkbook selector
  • ZPPS-121922 Create v4 "/row" and "/externalLink" endpoints.
  • ZPPS-122202 Ticket 3 - Remove cloneDeep from getSheetsOfSelectedWorkbook selector
  • ZPPS-123041 QA Automation for v4 tabOrder endpoint
  • ZPPS-123367 Fixes for Playwright/Integration builds

Q2 2024

06.06.2024

  • ZPPS-122732: Automated the testing process for the new validated v4 endpoints.
  • ZPPS-121092: Automated API testing process for Aggregate worksheets.
  • ZPPS-121767: Updated dev branches to Node v20 and confirmed tests are passing.
  • ZPPS-121164: Removed duplicated /query calls.
  • ZPPS-121066, ZPPS-121067, ZPPS-121068: Upgraded AG Grid to v30.
  • ZPPS120701: Added v4 DELETE API route for analytics worksheets.
  • ZPPS-120700: Added v4 PATCH API route for analytics worksheets.
  • ZPPS-120696: Added v4 POST API route for analytics worksheets.

05.06.2024

  • Extended the PATCH validation for the worksheet KPI Card schema. (ZPPS-120333)
  • Extended the PATCH validation for the worksheet external links schema. (ZPPS-120335)
  • Implemented the PATCH validation for aggregate worksheets. (ZPPS-120705)
  • Aggregate worksheets underwent automated testing and we removed feature flags (ZPPS-120956)
  • Disabled unnecessary column settings in aggregate worksheets. (ZPPS-122404)

04.18.2024

  • Unit tests now run on Node v20. (ZPPS-121765)
  • Extended the PATCH validation for the worksheet source data schema. (ZPPS-120336)
  • Extended the PATCH validation for the worksheet custom action button schema. (ZPPS-120334)
  • Extended the PATCH validation for the worksheet filter schema. (ZPPS-120331)
  • Extended the PATCH validation for the worksheet user settings schema. (ZPPS-120328)

Q1 2024

03.18.2024

  • Extended the schema validation for the Load Filters schema. (ZPPS-120327)
  • Added server validations for aggregate worksheets. (ZPPS-118352)
  • Aggregate worksheets support user settings and management capabilities. (ZPPS-118201)
  • Aggregate worksheets support related columns. (ZPPS-118197)
  • Aggregate worksheets support filtering capabilities. (ZPPS-118198)
  • Aggregate worksheets use the new v4 endpoint for properties and settings. (ZPPS-120491, ZPPS-120489)
  • Investigated an issue with exporting aggregate worksheets. (ZPPS-121428)
  • Resolved errors and warnings as a part of our efforts to upgrade AG Grid to the latest version. (ZPPS-121063)
  • Removed @reduxjs/toolkit and updated unit tests. (ZPPS-118992)
  • Updated unit tests to use the latest version of Node. (ZPPS-118991, ZPPS-118990)
  • Updated the ZPMS docker image to reference a stable build. (ZPPS-117455)

02.22.2024

  • IQ Interface users without proper permissions don't trigger calls to SLEMS. (ZPPS-120625)
  • You can now disable the client-side grid. (ZPPS-121124)
    Note

    This implementation is available only to certain tenants.

  • Unique columns are no longer duplicated in worksheets. (ZPPS-120810)
  • Extended the worksheet PATCH validation for analytics worksheets. (ZPPS-120325)
  • Extended the worksheet PATCH validation for grid worksheets. (ZPPS-120324)
  • Created DELETE, PATCH, and POST v4 endpoints for workbooks, worksheets, and fields. (ZPPS-118351, ZPPS-118350, ZPPS-118349, ZPPS-118348, ZPPS-118347)

01.24.2024

  • Enhanced the Filter schema for the JSON validation. (ZPPS-119856)
  • Enhanced the Source Data schema for the JSON validation. (ZPPS-119855)
  • Enhanced the Custom Actions and Scenario schema for the JSON validation. (ZPPS-119854)
  • Enhanced the Analytics Worksheet schema for the JSON validation. (ZPPS-119850)
  • Created a mock for the PermissionsProvider. (ZPPS-119665)
  • The ArrayInput component receives different properties for each row. (ZPPS-119428)

01.10.2024

  • Removed secrets and leaks from the IQ Interface repository and commit history. (ZPPS-120071)
  • Updated the UniversalMiddlePane component to receive a property to validate the workbook and worksheet permissions. (ZPPS-119407)
  • The /dependent endpoint returns additional relationship data. (ZPPS-119908)
  • The ResourceId property of the PermissionsProvider can only be an array. (ZPPS-119667)
  • Upgraded the react-tabs package. (ZPPS-120381)
  • Schema validation enhancements:
  • Added recent Polish translations into the internationalization file. (ZPPS-119927)
  • Migrated files to the TypeScript. (ZPPS-119669, ZPPS-119668, ZPPS-118520, ZPPS-118519)

Previous releases

Q4 2023

12.13.2023

  • Stopped preloading workbook and worksheet data:
    • Removed uses of allWorkbookWorksheets in WorkbookTabs. (ZPPS-119476)
    • Removed uses of allWorkbookWorksheets in SourceworksheetSelector. (ZPPS-119475)
    • Removed uses of allWorkbookWorksheets in ScenarioForm. (ZPPS-119474)
    • Removed uses of allWorkbookWorksheets in WorksheetSourceDataForm. (ZPPS-119469)
    • Removed uses of allWorkbookWorksheets in WorksheetMasterDetailForm. (ZPPS-119455)
    • Removed uses of allWorkbookWorksheets in WorkbookSourceDataScopeFormLogic. (ZPPS-119454)
  • Server-side schema validation for Price Manager API:
    • Created shared custom keyword to validate the field existence. (ZPPS-119940)
    • Created shared custom keyword to validate the worksheet existence. (ZPPS-119939)
    • Created schema validation for the user settings worksheet. (ZPPS-119032)

11.29.2023

  • Removed allWorkbookWorksheets from AddRowForm. (ZPPS-119477)
  • Removed allWorkbookWorksheets from MasterDetailMiddlePane. (ZPPS-119473)
  • Refactored the getJoinConditionsInputData function and split it into two different functions. (ZPPS-119456)
  • Created JSON schema validation for custom buttons. (ZPPS-119033)
  • Created JSON schema validation for worksheets. (ZPPS-119031)

11.16.2023

  • Installed ajv library on the server side for the schema validation for the workbook JSON. (ZPPS-119030)
  • The getWorksheetsForWorkbook action and the getAllWorkbooksWorksheets request now call the v4 endpoint. (ZPPS-119147, ZPPS-119146)
  • The getAllWorkbooksWorksheets request now calls the v4 endpoint. (ZPPS-119142)
  • Navigation.ts uses the v4 endpoint for the workbookworksheet requests.
  • The /api/v4/workbook is now used in Workbook. (ZPPS-119133)
  • The /api/v4/workbook endpoint is now used in WorkbookGeneralPropertiesForm. (ZPPS-119131)
  • The /api/v4/folder/:folderId/children endpoint is now used in WorkbookList. (ZPPS-119130)
  • The /api/v4/folder/:folderId/children endpoint is now used in FolderTwoColumnMenu. (ZPPS-119129)
  • Refactored the code from api/v3/workbook to api/v4/workbook in the GET request. (ZPPS-118963)
  • Refactored the code from api/v3/folder to api/v4/folder in the GET request. (ZPPS-118962)

11.01.2023

10.19.2023

  • Completed conversion of class-based components to utility functions. (ZPPS-118669)
  • Muted unhelpful alerts from DataDog monitors. (ZPPS-118608)
  • Identified the server-side code coverage for the PM application. (ZPPS-118518)
  • Implemented DataDog logging in the client package. (ZPPS-118325)
  • Streamlined OPA integrations with IQ Interface. (ZPPS-118303, ZPPS-118301)
  • Migrated tests to RTL and removed enzyme helper functions. (ZPPS-117584, ZPPS-117583)

10.04.2023

  • Centralized UUID assignments for a worksheet's endpoints. (ZPPS-116935)
  • Refactored default action attributes of DataDog RUM. (ZPPS-118323)
  • Updated configuration of the RUM provider to enrich default actions. (ZPPS-118327)
  • Extended the RUM Context to track views manually. (ZPPS-118328)
  • Upgraded the RUM SDK client dependency. (ZPPS-118329)
Q3 2023

09.20.2023

  • Removed Yup.addMethod implementations. (ZPPS-117510)
  • Added DatadogRUM analytics tracking for the Help Links feature. (ZPPS-117429)
  • Added DatadogRUM analytics tracking for the Column Highlighting feature. (ZPPS-117254)
  • LEVS now uses a JWT token to make API calls. (ZPPS-117428)
  • SLEMS now uses a JWT token to make API calls. (ZPPS-117422)
  • Now, when you create a master-detail relationship, null values in Boolean fields are interpreted as FALSE. (ZPPS-116961)

08.23.2023

07.26.2023

07.12.2023

Q2 2023

06.28.2023

06.14.2023

  • In the Price Manager client/package.json file, the @storybook/react package exists under the devDependencies object. (ZPPS-115579)
  • Unit tests migrated to React Testing Library (ZPPS-113947, ZPPS-113945)

05.25.2023

  • Skipped tests are detected with Git hooks. (ZPPS-115414)
  • Date inputs in the workbook properties have locale formatting. (ZPPS-115378)
  • The execution log date column correctly formats based on locale. (ZPPS-115376)
  • KPI cards configured with a view other than the worksheet do not make extra LEDS calls. (ZPPS-114655)
  • Refactored the analyticsSideBar component to use the new generic analytics view component. (ZPPS-101966)