Page History
...
Xray 7. x introduced a major bug that would result in the loss of precondition links in specific conditions.
To recover the majority of the links, we'll be using the mementos from past test runs created.
...
Info |
---|
This solution is not perfect and will not consider some situations:
|
The Based on the Test Runs data, the following query will insert all the missing links into the Test ↔ Pre-condition link table based on the Test Runs data. We recommend executing only the select first to validate the data and add more filters in case. you would like to recover the precondition links by project, date of test run or other.
...
Code Block |
---|
select pt."ID", pt."SOURCE_ISSUE" as test_id, pt."TARGET_ISSUE" as precond_id, CFO.CUSTOMVALUE as precondtype, CFO2.customvalue as test_type from "AO_8B1069_TEST_PRE_COND_LINK" pt join customfieldvalue cfv on cfv.issue= pt."TARGET_ISSUE" join customfield cf on cfv.customfield= cf.id and cf.CUSTOMFIELDTYPEKEY like '%com.xpandit.plugins.xray:precondition-test-type-custom-field%' JOIN customfieldoption CFO ON CFO.ID=CAST (cfv.stringvalue AS INTEGER) join customfieldvalue cfv2 on cfv2.issue= pt."SOURCE_ISSUE" join customfield cf2 on cfv2.customfield= cf2.id and cf2.CUSTOMFIELDTYPEKEY like '%com.xpandit.plugins.xray:test-type-custom-field%' JOIN customfieldoption CFO2 ON CFO2.ID=CAST (cfv2.stringvalue AS INTEGER) where CFO.CUSTOMVALUE <> CFO2.customvalue; |
These queries are built for PostgresSQL.
Page properties | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
...