[OB2] Add sql queary to migrate old APPROVED DCR state to ACTIVE in OB_DCR_DETAILS table

hasithakn commented 1 year ago

Affected OB version:

OB2

Affected OB specifications:

AU

Existing pages to be updated:

https://docs.wso2.com/display/OB200/Consent+Management+for+Australia

Description (Optional):

With the DCR's performance improvement, There's slight change that happened in the OB_DCR_DETAILS tables STATE value.

This column has being storing the value "APPROVED" for success DCR apps. But now this is changed to "ACTIVE". Therefor we need to migrate the "APPROVED" values in apps to "ACTIVE" state in OB_DCR_DETAILS table.

Please use below query in the openbank_openbankingdb to migrate the APPROVED status to ACTIVE.

UPDATE OB_DCR_DETAILS SET STATUS ='ACTIVE' WHERE STATUS ='APPROVED';

Note: This migration is only needed for the DCR apps created with the product packs older than May 2, 2022 (05-02-2021) or U2 level : wso2-obam-2.0.0.147.full

Instructions:

We can add above description at the end of https://docs.wso2.com/display/OB200/Consent+Management+for+Australia . As this place mention about the configuration of the consent expiry and, this is impacting consent expiry task.