Massive Update without changing "Last Date Modified" nor "Last User Modified" ?

Question

Hi All

I prepared a procedure in order to append the macro "Properties Pages" more than one thousand pages using the JAVA APIs.

Is there a way to perform this update without changing the "Last Date Modified" nor "Last User Modified" ?

Users need to keep the previous Date and Modifier.

Vincent

Paolo Bolla · Answer

_

Vincent Thoulé _Alkaes_ · Answer

Hi Ravi,

Thanks for advising on this details.

I will try to perform it without changing it in Database.

I will at least change the modified by switching the User Authentication Context.

V.

Ravi Varma · Answer

Hi @Vincent Thoulé _Alkaes_,

Both Confluence and JIRA by design do not allow modifying Last Date Modified through APIs.

Atlassian does not recommend modifying the data at the database level.

Please note that

* "Last Date Modified" is preserved in content table lastmoddate column 
* Value stored in  content table lastmoddate column is time zone sensitive
* "Last User Modified" is preserved in content table lastmodifier column 
*  Value stored in  content table lastmodifier column is an alphanumeric and has a foreign key relation with user_mapping table

Though we do not recommend, you can try out the following:

* Preserve the lastmoddate and lastmodifier before modifying pages
* Modify the pages
* Update the lastmoddate and lastmodifier for respective pages by looking up the data that was preserved earlier

Please execute the solution for a few records and validate the results before applying it on a large data set.

Regards,

Ravi Varma