Need help to build custom report to pull the modified testcases

Hi Kiran

The following ESQL custom report query will display a list of all the field changes for test cases in a specific product/project:

select HC.CHANGESET_ID, HC.ARTIFACT_TYPE_NAME, HC.CHANGE_DATE, HC.ARTIFACT_ID as TEST_CASE_ID, HC.ARTIFACT_DESC as TEST_CASE_NAME, HD.FIELD_NAME, HD.OLD_VALUE, HD.NEW_VALUE
from SpiraTestEntities.R_HistoryChangeSets as HC
join SpiraTestEntities.R_HistoryDetails as HD on HC.CHANGESET_ID = HD.CHANGESET_ID 
where HC.PROJECT_ID = ${ProjectId} and HC.ARTIFACT_TYPE_ID = 2

(Artifact Type = 2 is test cases)

Regards
David

Thanks David, Can I filter it further to pull the modified testcases in the past 1 week.

Sure just add a where clause on one the date fields....

https://spiradoc.inflectra.com/Reporting/Custom-Report-Tables/

History Change-Sets¶

• CHANGESET_ID
• USER_ID
• ARTIFACT_TYPE_ID
• ARTIFACT_ID
• CHANGE_DATE
• CHANGETYPE_ID
• PROJECT_ID
• REVERT_ID
• ARTIFACT_DESC
• CHANGETYPE_NAME
• USER_NAME
• ARTIFACT_TYPE_NAME
• SIGNATURE_HASH
• MEANING

In this case, CHANGE_DATE.