Lets imagine that I have hierarchy in releases (moreover, Spira supports it). When I select a Relaese in the filter on a list-view of releases not always it will show all of the children. It looks like, it will show only one or two levels under it. So, we may miss some of the requirements or incidents if they are deep in the hierarchy. I have played with the custom reports to investigate what was wrong, looks like a mistake is also there. If I run select ${ReleaseId} as RRelease, R.RELEASE_ID, R.INDENT_LEVEL from SpiraTestEntities.R_Releases as R where R.PROJECT_ID = ${ProjectId} I get many records including next 2392 AABAAI 2393 AABAAIAAAAAA 2394 AABAAIAAAAAB 2395 AABAAIAAAAAC 2454 AABAAIAAAAAD , so it assures me that RELEASE_ID=2392 has many children. But if I run select ${ReleaseId} as RRelease, R.RELEASE_ID, R.INDENT_LEVEL from SpiraTestEntities.R_Releases as R where R.PROJECT_ID = ${ProjectId} and R.RELEASE_ID in {${ReleaseAndChildIds}} With selected release = 2392, I get only itself while expected behavior is to get also its children 2392 2392 AABAAI 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/issues-questions/2470.aspxthreadId=2470Ilia Poliakov (ilya.polyakov@edetek.com)releases Lets imagine that I have hierarchy in releases (moreover, Spira supports it). When I select a Relaese in the filter on a list-view of releases not always it will show all of the children. It looks like, it will show only one or two levels under it. So, we may miss some of the requirements or incidents if they are deep in the hierarchy. I have played with the custom reports to investigate what was wrong, looks like a mistake is also there. If I run select ${ReleaseId} as RRelease, R.RELEASE_ID, R.INDENT_LEVEL from SpiraTestEntities.R_Releases as R where R.PROJECT_ID = ${ProjectId} I get many records including next 2392 AABAAI 2393 AABAAIAAAAAA 2394 AABAAIAAAAAB 2395 AABAAIAAAAAC 2454 AABAAIAAAAAD , so it assures me that RELEASE_ID=2392 has many children. But if I run select ${ReleaseId} as RRelease, R.RELEASE_ID, R.INDENT_LEVEL from SpiraTestEntities.R_Releases as R where R.PROJECT_ID = ${ProjectId} and R.RELEASE_ID in {${ReleaseAndChildIds}} With selected release = 2392, I get only itself while expected behavior is to get also its children 2392 2392 AABAAI Mon, 23 Aug 2021 08:56:19 -04002021-08-23T11:38:03-04:00/Support/Forum/spirateam/issues-questions/2470.aspxmessageId=4086David J (adam.sandman+support@inflectra.com) That filter only gets Releases and Child Iteration/Sprints, which is consistent with how it works on the other graphs/charts. It does not currently include minor releases and their children. There is an open change request for this. Mon, 23 Aug 2021 11:38:03 -04002021-08-23T11:38:03-04:00/Support/Forum/spirateam/issues-questions/2470.aspx#reply4086