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

[Vincent Thoulé _Alkaes_]

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

[Ravi Varma]

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

[Vincent Thoulé _Alkaes_]

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.

[Paolo Bolla]

_