How to Change created_on date ?
Hi ,
I am working on a project where I want to migrate data to Aras Innovator . In this case I want to change the created_on date of an object to original date which is present in the data . But I am...
Forum Discussion
Hello,
The only way to change these attributes is directly through SQL. Please note that we don't typically recommend using SQL to update the values of properties as it bypasses the Aras permission model, so these queries should be used only during this initial data load and not during normal use.
You can update these properties either by executing a query like below through SQL Server Management Studio...
update innovator.PART set created_on = '2018-01-24 08:00:00.000' where id = 'YOUR_PART_ID'
... or through Method code (the below sample uses C#) within Aras Innovator like below.
string sql = String.Format("update [PART] set created_on = {0} where id = {1}", yourDate, yourPartId);
Item sqlRes = this.getInnovator().applySQL(sql);
