CyL's nOtE

In Aras Innovator, we could execute command "Where Used" to check where the item is used like below picture. And for programming, AML provides an action "getItemWhereUsed" to do this. <AML> <Item type=" Item Type " id=" Item Id " action="getItemWhereUsed" /> </AML> Results will be contained in tag "relatedItems", just use XPath to retrieve.

aras.utils.setClipboardData('Text', Value );

Add reference "Windows Script Host Object Model" to VBA project, and then use below code:

Every time open an item in tab view mode will append an iframe object (hereinafter referred to as window) to body. At the same time, window will be assigned an unique id which consists of opening time and item's id for identifying. Window layout is defined as below picture. If there are many relationship tabs, they will be stored in "iframesCollection" inside relationships window and indexed by RelationshipType's ID. For example, the ID of "Part BOM" is "159C6D88795B4A86864420863466F728"; therefore, the "BOM" tab could be accessed by below code. window.relationships.iframesCollection['159C6D88795B4A86864420863466F728']

We know that everything in Aras Innovator is an item. In order to freely use, particular item could be automatically opened after user login. The main entry of Aras Innovator is "Innovator.aspx", so the system link looks like below: http:// Server Name / Web Alias /Client/X-salt=std_11.0.0.6549-X/scripts/Innovator.aspx The field of query string is "StartItem", and its value consists of ItemType, colon, and item's id. Innovator.aspx?StartItem= ItemType : Item's id Below picture shows a scenario to open a "Part" whose id is "0298334919634D35B718E06DE19642C0". Suppose user doesn't login yet, login page will display while enter a link. After user login, that Part item will open automatically. If user already login, there will be an existing session in browser's window used for first login. So, user will get below message, and the item will be opened in that window.

In "Jus Ask Innoavtor", we could learn some tips for querying data in simple search mode. But I would use those tips with examples to make it easier to understand. Suppose there are 5 records in my database. Exact String Matching Input words or terms without any special symbol will execute exact string matching. Input "A0119B/11101", 1 record returned. Input "A0119B", nothing returned. Input "11101", nothing returned. Approximate String Matching Use "*" or "%" as wildcard character to execute approximate string matching. Input "A0*", 2 records returned. Input "*1", 3 records returned. Input "*ED*", 2 records returned. Input "A*1*1", 1 record returned. Regular Expression Matching Use square brackets with simple regular expression to execute a query is acceptable, all allowed terms (which are tested by myself and refer to this article ) are sh

This article listed various way to implement "foreach" in JavaScript and introduced very clear. If you want to find simplified explanation, you can read this article instead. I personally prefer to use "for-in" loop, let's see examples on array and object. Using for-in to loop through an array var arr = ['val1','val2','val3']; for (var key in arr) { console.log(key+' => '+arr[key]); } //0 => val1 //1 => val2 //2 => val3  Using for-in to loop through an object var obj = {'key1':'val1','key2':'val2','key3':'val3'}; for (var key in obj) { console.log(key+' => '+obj[key]); } //key1 => val1 //key2 => val2 //key3 => val3  Using for-in to loop through objects inside an array var arr = [ {'key11':'val11','key12':'val12','key13':'val13'}, {'key21':'val21','key22&#

Relevant settings are defined in "InnovatorServerConfig.xml". If you didn't change the default installation path, the file should be located in "C:\Program Files (x86)\Aras\Innovator". Open the file, we could find a tag named "UI-Tailoring" and contains 3 attributes which are used to define site name and banner image, including "login_splash", "branding_img", and "product_name". As for "banner_url" and "banner_height", are used for customizing banner. <?xml version="1.0" encoding="UTF-8"?> <Innovator> <UI-Tailoring login_splash="../images/aras-innovator.svg" branding_img="../images/aras-innovator.svg" product_name="Aras Innovator" banner_url="../scripts/banner.aspx" banner_height="50"/> ... </Innovator> Login Form Main Window Banner Customization