Wrong Spira behaviour for indent Relaeses.

Monday, August 23, 2021
Avatar

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>

, 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>

<ROW>

<RRelease>2392</RRelease>

<RELEASE_ID>2392</RELEASE_ID>

<INDENT_LEVEL>AABAAI</INDENT_LEVEL>

</ROW>

</RESULTS>

1 Replies
Monday, August 23, 2021
Avatar
re: ilyapolyakov Monday, August 23, 2021

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.

Statistics
  • Started: Monday, August 23, 2021
  • Last Reply: Monday, August 23, 2021
  • Replies: 1
  • Views: 282