• Replies 3 replies
  • Subscribers 13 subscribers
  • Views 6622 views
  • Users 0 members are here
Options
Related

How to Change created_on date ?

Former Member
Former Member
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 !
Parents
  • Former Member
    Former Member
    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.
Reply
  • Former Member
    Former Member
    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.
Children
No Data

Copyright © 2025 Aras. All rights reserved.