New Feature Request

Wednesday, July 17, 2024
Avatar

My client has a couple of multi-year projects with a large number of defects (thousands). I have just added some custom fields to help with analysis and populated them with the respective values (via the Bulk Edit capability).

Some of the defects have not been touched in a significant time, but unfortunately, adding the analysis values has set the "Last Updated" field to yesterday (when I applied the field).

I would like a way of updating records in a way that does not update the "Last Updated" field, or to reset it after I have made the change. This could be, for example, by adding an attribute to custom fields to indicate that they are not to update "Last Updated" (they fall into a "non-core" category, perhaps).

5 Replies
Wednesday, July 17, 2024
Avatar
re: colinmain Wednesday, July 17, 2024

Hi Colin

I'm afraid for audit purposes that is not possible through the UI or the API.

You would need to make any such updates directly in the database (which is not officially supported, but would work in this case).

Regards

David

Wednesday, August 21, 2024
Avatar
re: colinmain Wednesday, July 17, 2024

You can execute raw SQL queries to update the fields directly without affecting the timestamps. This method bypasses the ORM and its automatic timestamp handling:

UPDATE your_table
SET custom_field = 'value'
WHERE condition

space waves
 

 

Wednesday, August 21, 2024
Avatar
re: colinmain Wednesday, July 17, 2024

I have similar problem.

We have some technical fields that are updated from git/quality control tools.

  1. First of all, they brake Spira's entity history as it becomes not readable.
  2. Second, yes, I wish "Last Updated" field not to be changed.

So, I would like to be able to exclude some custom fields from being tracked in a history and from changing "Last Updated" field.

Tuesday, October 29, 2024
Avatar
re: colinmain Wednesday, July 17, 2024

It is possible to update the record in a way that does not update the "Last Updated" field or reset the field after making changes but the history may still be retained fish eat fish

Tuesday, October 29, 2024
Avatar
re: elliotzucker Tuesday, October 29, 2024

Hi Elliot,

As David said, for audit purposes that is not possible through the UI or the API.

You would need to make any such updates directly in the database (which is not officially supported, but would work in this case).

Regards,

Kat

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: Wednesday, July 17, 2024
  • Last Reply: Tuesday, October 29, 2024
  • Replies: 5
  • Views: 389