Report on requirements changed from date

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, you'd 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