Changelog

[3.0.3] - 07-11-2023

• Introduced a new library dependency to facilitate Oracle connections.

[3.0.2] - 07-11-2023

• Fixed collaboration not showing data

[3.0.1] - 07-11-2023

• Added a variable to change the data fetching pagination size. Add db.pagination_size=# to your config.yaml file to adjust the pagination size. Default is 1000 (rows).
• Added a variable to log queries for easy debugging.
• Removed support for Auto incremented ID's for Amazon Redshift driver.
• Improved fetching correct auto incremented ID for Snowflake & Teradata driver.
• Improved issue with zip file appearing empty on Windows, despite containing data.
• Improved rollback of a record when using SQLServer as repository database.
• Cleaned up api requests to extension.
• Improved domain/host part of the installation procedure
• Improved SAML error handling when using a faulty configuration
• Added automatic worker refresh after 1h to prevent database session timeouts
• Added automatic server restart upon saving in configuration panel

[3.0.0] - 20-09-2023

• Release of WritebackExtreme 3.0
• Removed SSO providers, only Manual option is available!
• Improved encryption of tableau sync configuration

[2.4.3] - 19-07-2023

• Improved fetching correct auto incremented ID for Snowflake & Teradata driver
• Added support for Auto incremented ID's for Amazon redshift driver
• Improved zip file for system logs
• Improved Rollback of a record when using SQLServer as repository database

[2.4.2] - 13-07-2023

• Fixed snowflake connecting issue in php7.4

[2.4.1] - 06-07-2023

• Fixed an issue where WritebackExtreme did not have the proper permissions when updating the LICENSE.
• Enhanced the Snowflake driver to support QUOTED_IDENTIFIERS_IGNORE_CASE=true and added a connection setting to enforce QUOTED_IDENTIFIERS_IGNORE_CASE=false by default.
• Fixed snowflake compatibility with PHP 8
• Fixed workflows not sending the ID on record create

[2.4.0] - 26-06-2023

• Resolved an issue that prevented the creation of a database table that had been previously created.
• Fixed bug for PostgreSQL. Workflows could not be saved due to a mismatch in colum type.
• Fixed error on missing access token with workflows.

[2.3.1] - 24-05-2023

• Fixed issue where inactive users could still use WriteBackExtreme

[2.3.0] - 03-05-2023

• Fixed numbers become a 0 after updating a row without changing numbers.

[2.2.1] - 27-03-2023

Upgraded extension to version 2.2.1.

[2.2.0] - 27-03-2023

• Added support for creating separate records when selecting multiple datapoints.

[2.1.1] - 23-02-2023

• Fix: System Audits table throwing error for SQL Server.
• Fix: Casting primary keys for existing tables (datacorrect).

[2.1.0] - 21-02-2023

• Added audits for tracking management console changes.
• Added support for downloading log files as zip.
• Added BigQuery database driver.
• Added Teradata database driver.
• Schema names can now have a length of 1 character.
• Fix: FORCE_HTTPS was not working, causing errors.
• Fix: Fixed configuration issue in workflows Salesforce integration.

[2.0.4] - 15-02-2023

• Updated Tableau extension to version 2.0.1.

[2.0.3] - 02-02-2023

• Fix: Row level security entitlements were not saved.
• Fix: Postgresql has issues with grouping on json columns.
• Fix: Check if there is a token available when logout. Prevent logging.
• Fix: Fixed an error in custom Primary key fields

[2.0.2] - 27-01-2023

• Fix: SQL Server, RLS tables fix.
• Fix: Edit mode for RLS policy not showing proper policy type.

[2.0.1] - 23-01-2023

• Fix: SQL Server migrations table fix.
• Fix: Force the JWT token to be updated on every update command.

[2.0.0] - 16-01-2023

• Added workflows for multiple providers out-of-the-box.
• Added Row-level security for schema's.
• Adding SQL Server custom connection parameters control via .env.
• Fix: schema detection is not showing multiple fields, when multiple tables with the same names in different databases.
• Removed migration status API endpoint, because we moved to virtual migrations.

[1.7.3] - 12-12-2022

• Fix: mismatching mapping records with datapoints due to upper/lowercase id's.
• Fix: casting for group id's before attaching to users.
• Fixed error AADSTS75011 when authenticating through SAML.
• Updated dependencies for SAML issue.

[1.7.2] - 14-11-2022

• Added schema support for SQL Server.
• Improved data-fetching for each schema. Paginate all data instead of single bulk request.
• Fix: Tableau paginated requests sync.
• Fix: Trex author URL and added version of the extension.

[1.7.1] - 20-10-2022

• Fixed issue with an extension not loading when using SQL Server as repository database.
• Improved Tableau-Sync: using "Display name" instead of username for the display name in Writeback.

[1.7.0] - 06-10-2022

• Fix: SSO App shortcut in the IdP dashboard (Okta, Azure etc.) to the management console.
• Fix: Suspended users are really blocked.
• API loading schema's to the extension, satisfies the schema permissions properly.
• Improve mapping worksheet-column lookup for existing schema if they might exist.

[1.6.6] - 13-09-2022

• Fix: Tableau-sync nullable contentUrl for site tableau-server.
• Fix: Bug for testing content or URL for Okta/Azure provider.
• SSO: Changed attribute exchange via the request to RelayState. Added support for SSO Providers like Ping ID that do not allow dynamic ASC (Assertion Consumer Service)
• Added pagination to sync Tableau users and groups.

[1.6.5] - 19-08-2022

• Fix: using CDN icons in the management console. Updated management console to 1.6.5.

[1.6.4] - 22-07-2022

• Fix: Tableau Server with Default site bug.

[1.6.3] - 12-07-2022

• Fixed 'invalid SAML response' bug with specific deployments.

[1.6.2] - 23-06-2022

• Fixed a bug where adding/removing groups to a user was not working properly.

[1.6.1] - 21-06-2022

• Fix: bulk data updates for new schemas are not updating fixed fields.
• SSO Polling mechanism defaults to the max of 30 seconds.

[1.6.0] - 13-06-2022

• Improved Tableau Sync - added PAT option and "no site" for Tableau server.
• Added manual configuration for SAML SSO.

[1.5.4] - 25-05-2022

• Fix for schema detection primary field is not the first field.
• Snowflake workaround for constraints query issues.

[1.5.3] - 12-05-2022

• Fixed retrieving mapping rows for big tables throwing a database error.
• Added support for Okta as SAML SSO provider

[1.5.2] - 19-04-2022

• Fix: issue with typecasting where the zeros were being stripped out from the beginning of the string in the data-correct module.
• Fix: DataCorrect boolean fields are always set to false if they are not updated in the form update.
• Added 'auto_created' and 'auto_updated' feature for Datetime fields in existing schema's (mainly used for data-correction).

[1.5.1] - 03-03-2022

• Backwards compatibility improvements.

[3.0.0] - 20-09-2023

• Writeback To The Max - The All-in-one Application that rules them all
• Removed SSO providers, only Manual option is available!
• Improved encryption of tableau sync configuration

[2.4.3] - 19-07-2023

• Improved fetching correct auto incremented ID for Snowflake & Teradata driver
• Added support for Auto incremented ID's for Amazon redshift driver
• Improved zip file for system logs
• Improved Rollback of a record when using SQLServer as repository database

[2.4.2] - 13-07-2023

• Fixed snowflake connecting issue in php7.4

[2.4.1] - 06-07-2023

• Fixed an issue where WritebackExtreme did not have the proper permissions when updating the LICENSE.
• Enhanced the Snowflake driver to support QUOTED_IDENTIFIERS_IGNORE_CASE=true and added a connection setting to enforce QUOTED_IDENTIFIERS_IGNORE_CASE=false by default.
• Fixed snowflake compatibility with PHP 8
• Fixed workflows not sending the ID on record create

[2.4.0] - 26-06-2023

• Resolved an issue that prevented the creation of a database table that had been previously created.
• Fixed bug for PostgreSQL. Workflows could not be saved due to a mismatch in colum type.
• Fixed error on missing access token with workflows.

[2.3.1] - 24-05-2023

• Fixed issue where inactive users could still use WriteBackExtreme

[2.3.0] - 03-05-2023

• Fixed numbers become a 0 after updating a row without changing numbers.

[2.2.1] - 27-03-2023

Upgraded extension to version 2.2.1.

[2.2.0] - 27-03-2023

• Added support for creating separate records when selecting multiple datapoints.

[2.1.1] - 23-02-2023

• Fix: System Audits table throwing error for SQL Server.
• Fix: Casting primary keys for existing tables (datacorrect).

[2.1.0] - 21-02-2023

• Added audits for tracking management console changes.
• Added support for downloading log files as zip.
• Added BigQuery database driver.
• Added Teradata database driver.
• Schema names can now have a length of 1 character.
• Fix: FORCE_HTTPS was not working, causing errors.
• Fix: Fixed configuration issue in workflows Salesforce integration.

[2.0.4] - 15-02-2023

• Updated Tableau extension to version 2.0.1.

[2.0.3] - 02-02-2023

• Fix: Row level security entitlements were not saved.
• Fix: Postgresql has issues with grouping on json columns.
• Fix: Check if there is a token available when logout. Prevent logging.
• Fix: Fixed an error in custom Primary key fields

[2.0.2] - 27-01-2023

• Fix: SQL Server, RLS tables fix.
• Fix: Edit mode for RLS policy not showing proper policy type.

[2.0.1] - 23-01-2023

• Fix: SQL Server migrations table fix.
• Fix: Force the JWT token to be updated on every update command.

[2.0.0] - 16-01-2023

• Added workflows for multiple providers out-of-the-box.
• Added Row-level security for schema's.
• Adding SQL Server custom connection parameters control via .env.
• Fix: schema detection is not showing multiple fields, when multiple tables with the same names in different databases.
• Removed migration status API endpoint, because we moved to virtual migrations.

[1.7.3] - 12-12-2022

• Fix: mismatching mapping records with datapoints due to upper/lowercase id's.
• Fix: casting for group id's before attaching to users.
• Fixed error AADSTS75011 when authenticating through SAML.
• Updated dependencies for SAML issue.

[1.7.2] - 14-11-2022

• Added schema support for SQL Server.
• Improved data-fetching for each schema. Paginate all data instead of single bulk request.
• Fix: Tableau paginated requests sync.
• Fix: Trex author URL and added version of the extension.

[1.7.1] - 20-10-2022

• Fixed issue with an extension not loading when using SQL Server as repository database.
• Improved Tableau-Sync: using "Display name" instead of username for the display name in Writeback.

[1.7.0] - 06-10-2022

• Fix: SSO App shortcut in the IdP dashboard (Okta, Azure etc.) to the management console.
• Fix: Suspended users are really blocked.
• API loading schema's to the extension, satisfies the schema permissions properly.
• Improve mapping worksheet-column lookup for existing schema if they might exist.

[1.6.6] - 13-09-2022

• Fix: Tableau-sync nullable contentUrl for site tableau-server.
• Fix: Bug for testing content or URL for Okta/Azure provider.
• SSO: Changed attribute exchange via the request to RelayState. Added support for SSO Providers like Ping ID that do not allow dynamic ASC (Assertion Consumer Service)
• Added pagination to sync Tableau users and groups.

[1.6.5] - 19-08-2022

• Fix: using CDN icons in the management console. Updated management console to 1.6.5.

[1.6.4] - 22-07-2022

• Fix: Tableau Server with Default site bug.

[1.6.3] - 12-07-2022

• Fixed 'invalid SAML response' bug with specific deployments.

[1.6.2] - 23-06-2022

• Fixed a bug where adding/removing groups to a user was not working properly.

[1.6.1] - 21-06-2022

• Fix: bulk data updates for new schemas are not updating fixed fields.
• SSO Polling mechanism defaults to the max of 30 seconds.

[1.6.0] - 13-06-2022

• Improved Tableau Sync - added PAT option and "no site" for Tableau server.
• Added manual configuration for SAML SSO.

[1.5.4] - 25-05-2022

• Fix for schema detection primary field is not the first field.
• Snowflake workaround for constraints query issues.

[1.5.3] - 12-05-2022

• Fixed retrieving mapping rows for big tables throwing a database error.
• Added support for Okta as SAML SSO provider

[1.5.2] - 19-04-2022

• Fix: issue with typecasting where the zeros were being stripped out from the beginning of the string in the data-correct module.
• Fix: DataCorrect boolean fields are always set to false if they are not updated in the form update.
• Added 'auto_created' and 'auto_updated' feature for Datetime fields in existing schema's (mainly used for data-correction).

[1.5.1] - 03-03-2022

• Backwards compatibility improvements.