Have PROJECT_ID, IS_DELETED field in more report tables

Thursday, October 17, 2024
Avatar

Hello,

According to Available Report Tables - SpiraDocs (inflectra.com)

PROJECT_ID is missing in many tables.

Examples:

  1. R_Comments
  2. R_HistoryDetails

And it requires more merges. Will it be a big database degradation to add it to those tables?

For example, for comments it is really many merges to see comments for some particular project. It is as I need to do union all for entities (tasks, requirements, etc.) after inner join.

 

And if the impact to database is low, let's try to have PROJECT_ID almost everywhere.

 

More or less the same situation is with IS_DELETED flag. To get information that comment belongs to an entity that was deleted - many merges needed. But this request has lower priority.

2 Replies
Thursday, October 17, 2024
Avatar
re: ilyapolyakov Thursday, October 17, 2024

Hi Ilya

We've logged this as an enhancement, with incident iD: [IN:10213]

Regards

David

Friday, October 18, 2024
Avatar
re: inflectra.david Thursday, October 17, 2024

Thank you very much!

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

 

Statistics
  • Started: Thursday, October 17, 2024
  • Last Reply: Friday, December 6, 2024
  • Replies: 2
  • Views: 231