Hi, I would like to create a report that generates a list of requirements that have their name or Description modified since a certain date. How can I proceed? 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/spiraplan/issues-questions/2867.aspxthreadId=2867Carlo Tuzi (carlo.tuzi@leicabiosystems.com)report requirements. change Hi, I would like to create a report that generates a list of requirements that have their name or Description modified since a certain date. How can I proceed? Fri, 10 Nov 2023 15:23:22 -05002023-11-13T12:02:43-05:00/Support/Forum/spiraplan/issues-questions/2867.aspxmessageId=6225David J (adam.sandman+support@inflectra.com) Hi The simplest way to get the list of requirements that have any field changed is to run the standard requirements report and filter by Last Update Date. If you want to only get the ones that have a change to the Name or Description field, youd need to run a custom report using this ESQL: select HC.ARTIFACT_ID as REQUIREMENT_ID, HC.ARTIFACT_DESC as REQUIREMENT_NAME, MAX(HC.CHANGE_DATE) as CHANGE_DATE, RQ.REQUIREMENT_TYPE_NAME, RQ.REQUIREMENT_STATUS_NAME, RQ.IMPORTANCE_NAME from SpiraTestEntities.R_HistoryChangeSets as HC inner join SpiraTestEntities.R_HistoryDetails as HD on HC.CHANGESET_ID = HD.CHANGESET_ID inner join SpiraTestEntities.R_Requirements as RQ on HC.ARTIFACT_ID = RQ.REQUIREMENT_ID where (HD.FIELD_NAME = 'Name' or HD.FIELD_NAME = 'Description') and HC.ARTIFACT_TYPE_ID = 1 and HC.PROJECT_ID = ${ProjectId} and RQ.IS_DELETED = False group by HC.ARTIFACT_ID, HC.ARTIFACT_DESC, RQ.REQUIREMENT_TYPE_NAME, RQ.REQUIREMENT_STATUS_NAME, RQ.IMPORTANCE_NAME order by CHANGE_DATE DESC, HC.ARTIFACT_ID Regards David Mon, 13 Nov 2023 12:02:43 -05002023-11-13T12:02:43-05:00/Support/Forum/spiraplan/issues-questions/2867.aspx#reply6225