[Xray] Can I downgrade from Xray 7.x?

Xray 7.x introduces a series of data structure changes. Every relation pointing to a Test now points to a Test version. This data transformation is done using an Upgrade Task that runs once.

Downgrading from Xray 7.x.x to a previous version may have some side effects, please look into Xray 7.0.0 Release Notes.

When having created data with 7.0.0 and downgraded to the previous version, and created more data, Xray will need to rerun an upgrade task when installing in 7.x.x. To avoid any conflicts when upgrading, you should now follow the following steps (these can and should be executed now):

 - Create a backup of your instance
 - Run the following queries (Note: the following queries should only be done when asked by the Xray team)

delete from "AO_8B1069_TEST_CHANGE";  
truncate "AO_8B1069_GENERIC_DEFINITION";
truncate "AO_8B1069_CUCUMBER_DEFINITION";
UPDATE "AO_8B1069_PARAM" SET "SUB_ENTITY_ID" = null;
UPDATE "AO_8B1069_TEST_STEP" SET "TEST_VERSION_ID" = null;
UPDATE "AO_8B1069_AUTOMATED_STEP_ISSUE" SET "TEST_VERSION_ID" = null;
UPDATE "AO_8B1069_ENTITY_DATASET_SIZE" SET "SUB_ENTITY_ID" = null;
delete from "AO_8B1069_TEST_VERSION";  

select ps.* from propertystring ps
join propertyentry pe on pe.id=ps.id
where property_key like '%xray%';

update propertystring set propertyvalue = 2007000000 where ID in (<ids from the previous query that has the value 2007000001>);

– Re-run this select to validate the values have been changed

select ps.* from propertystring ps join propertyentry pe on pe.id=ps.id where property_key like '%xray%';