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.

3 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!

Wednesday, April 23, 2025
Avatar
re: inflectra.david Thursday, October 17, 2024
inflectra.david

Hi geometry dash meltdown,

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

Regards

David

Thank you!

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: Wednesday, April 23, 2025
  • Replies: 3
  • Views: 535