Skip Navigation LinksHome Page > Forums > SpiraTest Forums > SpiraTest Issues & Questi... > Incident - How Many Times...
select H.ARTIFACT_ID as RequirementID, R.NAME as RequirementName, X.VERSION_NUMBER as ReleaseVersionNumber, count(H.ARTIFACT_ID) as ModifiedCount from SpiraTestEntities.R_HistoryChangeSets as H inner join SpiraTestEntities.R_Requirements as R on R.REQUIREMENT_ID = H.ARTIFACT_ID inner join SpiraTestEntities.R_Releases as X on X.RELEASE_ID = R.RELEASE_ID where H.PROJECT_ID = ${ProjectId}
and H.ARTIFACT_TYPE_ID = 1 group by H.ARTIFACT_ID, R.NAME, X.VERSION_NUMBER
And if you have any questions, please email or call us at +1 (202) 558-6885