Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Qu... > Wrong Spira behaviour for...
Let's 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
<ROW><RELEASE_ID>2392</RELEASE_ID><INDENT_LEVEL>AABAAI</INDENT_LEVEL></ROW><ROW><RELEASE_ID>2393</RELEASE_ID><INDENT_LEVEL>AABAAIAAAAAA</INDENT_LEVEL></ROW><ROW><RELEASE_ID>2394</RELEASE_ID><INDENT_LEVEL>AABAAIAAAAAB</INDENT_LEVEL></ROW><ROW><RELEASE_ID>2395</RELEASE_ID><INDENT_LEVEL>AABAAIAAAAAC</INDENT_LEVEL></ROW><ROW><RELEASE_ID>2454</RELEASE_ID><INDENT_LEVEL>AABAAIAAAAAD</INDENT_LEVEL></ROW>
<ROW>
<RELEASE_ID>2392</RELEASE_ID>
<INDENT_LEVEL>AABAAI</INDENT_LEVEL>
</ROW>
<RELEASE_ID>2393</RELEASE_ID>
<INDENT_LEVEL>AABAAIAAAAAA</INDENT_LEVEL>
<RELEASE_ID>2394</RELEASE_ID>
<INDENT_LEVEL>AABAAIAAAAAB</INDENT_LEVEL>
<RELEASE_ID>2395</RELEASE_ID>
<INDENT_LEVEL>AABAAIAAAAAC</INDENT_LEVEL>
<RELEASE_ID>2454</RELEASE_ID>
<INDENT_LEVEL>AABAAIAAAAAD</INDENT_LEVEL>
, 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 it's children
<RESULTS>
<RRelease>2392</RRelease>
</RESULTS>
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.
And if you have any questions, please email or call us at +1 (202) 558-6885