Inflectra Customer Forums: Need help to build custom report to pull the modified testcases (Thread) Can we build a Custom Report to pull the modified testcases in a given project. We looked into tables for SpiraTestEntities.R_HistoryChangeSets and SpiraTestEntities.R_HistoryDetails but none of the fields are matching to get the modified Testcase id. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/2563.aspxthreadId=2563kiran prasad (kprasad@unfi.com)Need help to build custom report to pull the modified testcases Can we build a Custom Report to pull the modified testcases in a given project. We looked into tables for SpiraTestEntities.R_HistoryChangeSets and SpiraTestEntities.R_HistoryDetails but none of the fields are matching to get the modified Testcase id. Mon, 31 Jan 2022 17:17:54 -05002022-04-19T11:42:36-04:00/Support/Forum/spirateam/reports/2563.aspxmessageId=4259David J (adam.sandman+support@inflectra.com) Hi Kiran The following ESQL custom report query will display a list of all the field changes for t 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 Tue, 01 Feb 2022 10:49:48 -05002022-02-01T10:49:48-05:00/Support/Forum/spirateam/reports/2563.aspx#reply4259messageId=4260kiran prasad (kprasad@unfi.com) Thanks David, Can I filter it further to pull the modified testcases in the past 1 week. Thanks David, Can I filter it further to pull the modified testcases in the past 1 week. Tue, 01 Feb 2022 16:09:55 -05002022-02-01T16:09:55-05:00/Support/Forum/spirateam/reports/2563.aspx#reply4260messageId=4262David J (adam.sandman+support@inflectra.com) Sure just add a where clause on one the date fields.... https://spiradoc.inflectra.com/Reporting/ 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 Wed, 02 Feb 2022 12:47:47 -05002022-02-02T12:47:47-05:00/Support/Forum/spirateam/reports/2563.aspx#reply4262messageId=4263David J (adam.sandman+support@inflectra.com) In this case, CHANGE_DATE. In this case, CHANGE_DATE. Wed, 02 Feb 2022 12:48:03 -05002022-02-02T12:48:03-05:00/Support/Forum/spirateam/reports/2563.aspx#reply4263