Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
9 years ago

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 not able to change this date . Is there any way I can change the date ? Similar to date there are various attributes which cannot be modified . How to change these attributes  ? Thanks for reply !

3 Replies

  • eli_donahue's avatar
    eli_donahue
    Community Manager
    9 years ago
    Hi Ketan, The created_on date is a system property in Aras and cannot be updated via AML/IOM. If you need to update the dates after loading your data, you will need to use SQL to do so. Some other system properties include (but are not limited to) modified_on, created_by_id, modified_by_id, state, and current_state.
    Eli Donahue Aras Labs Software Engineer
  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi Eli, Thanks a lot for reply ! I tried it using SQL and it's working .   -Ketan.
  • Former_Member's avatar
    Former_Member
    Accelerator III
    9 years ago
    Hi Eli, The system properties can be updated using SQL. I tried following comand: <sql>Update innovator.Part set created_on = '2016-05-16T13:08:25' where ID='item_id'</sql> But in this case I need to know the name of the table(innovator.Part). I found that table name is same as Object name. Is it always true for all objects ? If it is not the case then how can I get the name of table for different objects at runtime? Thanks ! -Ketan.