Skip to main content

Change Keyed Name Length in Aras Innovator

The "Keyed Name" value normally follows "Name" value, and the value may be very long in some special scenarios. Default length of "Keyed Name" Property is 128, but it can't be modified due to system restrictions (see Restriction on Modifying System Property).
All operations on Aras Innovator will be validated before executing command in database. Therefore, it is impossible to modify with AML or configure on system interface. The alternative way is to modify column definition in database directly.
Use below the SQL command to achieve:

ALTER TABLE [Table Name] ALTER COLUMN [keyed_name] NVARCHAR(New Length) NULL;
UPDATE [Property] SET [stored_length]=New Length WHERE [id]='Property ID';
※Please use the command very carefully because there is no any system check for it.
標籤：

Comments

Post a Comment

Popular posts from this blog

Account and Password Policy in Aras Innovator

Aras Innovator has prepared security policy for account and password and very simple to set up. Account Policy There are two system variables could handle account policy: AccountLockoutThreshold_triesNum: The maximum trying number of login, user account will be locked if exceed. AccountLockoutDuration_minutes: User account locking duration after reach maximum trying number. ※Account policy will only be effective when values of above two variables are greater than zero. Password Policy There are two system variables could handle password policy: User_pwd_symbols_min_number: The minimum characters that must be contained when user set new password. User_pwd_digits_min_number: The minimum digits that must be contained when user set new password.
Post a Comment
Read more

aras.uiShowItemEx Method (aras Object)

aras.uiShowItemEx Method Shows Item with Item node. Syntax aras.uiShowItem( itemNd , viewMode , isOpenInTearOff ) Parameters Name Type Description itemNd Object Required. Item node. viewMode String Optional. Unknown purpose but only supports the following values: tab view (Default) openFile new ※Each supported value will get same result. Therefore, call method and pass undefined for this parameter is OK. isOpenInTearOff Boolean Optional. Specifies whether show Item with tear-off window. true - open in a tear-off window. false - open in a tab. (Default) Return Value An AsyncResult object or a Boolean. Returns AsyncResult object if the Item winodw is opened successfully, otherwise returns false. See Also aras Object Aras Innovator Client Framework
Post a Comment
Read more

aras.uiShowItem Method (aras Object)

aras.uiShowItem Method Gets Item by Item ID and then shows the Item. Syntax aras.uiShowItem( itemTypeName , itemID , viewMode ) Parameters Name Type Description itemTypeName String Required. Name of the ItemType. itemID String Required. ID of the Item. viewMode String Optional. Unknown purpose but only supports the following values: tab view - This is default. openFile new ※Each supported value will get same result. Therefore, call method without this parameter is OK. Return Value An AsyncResult object or a Boolean. Returns AsyncResult object if the Item winodw is opened successfully, otherwise returns false. See Also aras Object Aras Innovator Client Framework
Post a Comment
Read more