• Item.apply overwriting action, has it always done this?

    After upgrading from version 12 to 31, we started getting an error when saving a certain custom datastructure, developed for us by Minerva back in the day: Failed to execute 'serializeToString' on 'XMLSerializer': parameter 1 is not of type 'Node…
  • Need help with AML query to connect two independent ItemTypes via referencing item

    Hi community, I am working on an AML query but cannot find a proper solution. It contains a lot of custom ItemTypes, but technically the query would work similar like this: START--------> Part ---------------------> Part BOM -------------------…
  • What is the correct syntax of writing "where" statement in AML with C#

    I need to write just write one line of AML wrapped in C# and store the ID of the item in a variable code: Innovator inn = this.getInnovator(); string amlString= @"<AML><Item type='Document' action='get' where='item_number='MADL002828'' select='Document…
  • How to find ECR, ECO, EDR associated with PR using API GET call?

    Hi, I need the data for all the PRs and ECR, ECO, EDR etc associated with the PR. By associated I mean the ones that show in the "where used" section of PR and not the relationships. In other words, what is the "where used' equivalent in a GET call…
  • Query help needed

    Can someone help me with an AML query to find... all of our parts in Innovator that have only one item in the EBOM what revision sequence each part is assigned what the single EBOM item part number is Don
  • Upload missing document relationship in Process Plan. "Add" statement doesn't work

    I need to upload relationship between Operation Document and the Documents. As you can see from the picture below the hierarchy of Process Plan is: Process Plan--> Operation Number (which is `sort_order`, in this case it is 20)-->Document I have an…
  • Get item using multiple Where conditions and edit the item

    I am trying to edit the State of a Part with a specific generation, "1". The output of the following is just "<Result/>" Innovator innovator = this.getInnovator(); string configId = this.getProperty("config_id"); Item itm = this.newItem("Part", "edit…
  • Transfer a property value to another item's property

    Hi, I'm working with AML to update the Data in aras innovator. i'm stuck because i can't seem to transfer a property from one item to another. I have 2 items A and B. let us say that item A is a part and item B is a document. item A has a property…
  • How do I "edit"/"update" a Relationship instance using js or AML.

    All, I am trying to "edit"/"update" the properties on a Non-Related Relationship; "rh_OraMfgMaster_ProdNumNomen". I must be missing something. I tried the following AML from AML Studio: <AML> <Item type="rh_Oracle_Manuf_Master_Item" action=…
  • Is it possible to update an item with AML and not change modified_by_id and modified_on

    Just as the question says. I want to mass update some background properties but not show Super User as the modifier. TIA.
  • How does Aras handle the action(s) on a collection of items in an AML?

    I have written a server method that uses some custom XML-like AML to implement an inventory reconciliation. I would like to pass in a collection of items for this method to act on. When I implement a server call like: <AML> <Item type="Part" id…
  • Where Used Report - Multiple Levels

    Is it possible to generate a Report containing the results from the Where Used function? Other solutions I've seen only contain one level of results - I am looking for a Where Used Report that goes through multiple levels.
  • AML to Update List Property

    Good day. I added a list property to a few ItemTypes with a default value (itemtype, default value is the ItemType ID). When I create an entry the field is populated and identified correctly. When I try to update other entries using AML (Nash or Batchloader…
  • AML = SQL Where (IN)

    Good day all. I have a JavaScript Method that uses the following line to create a list. tdpList.loadAML('<Item type="s_Document" orderBy="id" action="get" where="([s_DOCUMENT].id IN(SELECT RELATED_ID FROM innovator.s_TDP_DOCUMENT WHERE (SOURCE_ID…
  • rest api AML

    Is it possible to send body with AML to rest api and get aml response? I could create a method that accepts string and parse the aml and reply but not sure how that would apply on the rights (trying to get only the items the logged in user can see…
  • What is Export Utility Levels ?

    what is the meaning of the above highlighted line in the EXPORT Utility?
  • How is the AML saved in the database ?

    Is it converted into Sql insert statement. I would also like to know about Odata, how is it implemented in ARAS?
  • Populate the WBS Elements for corresponding Activities2 in a project

    <AML> <Item type="WBS Activity2" action="get" select="name" where="WBS_Activity2.related_id IN (SELECT id FROM INNOVATOR.select_activities('9CB5E2CBBBDB1728B01882'))"> <Relationships> <Item type="Activity2" action="get" select="related_id(name)…
  • Is this possible if get an ItemType inside another query within AML?

    I have two ItemTypes Person and Address . There is a property Person.address_id that stores the config_id of an address, for a particular purpose it is just a string type, not refer ItemType. I use below query to select a person (*) : <Item action …
  • Uploading multiple document revisions with the batchloader

    Hi, I have the following (legacy) structure of documents and files: DOC-0001 Rev 12 State: Superseded File abc_12.dwg File abc_12.pdf DOC-0001 Rev 13 State: Superseded File abc_13.dwg File abc_13.pdf DOC-0001 Rev 14 State:…
  • Custom BOM Quantity Rollout Report

    Hi, I am trying to develop a custom BOM Quantity Rollout report, we have been able to pull in all the information we need from the Parts and Part BOM however, we need help pulling in the Manufacturer Part from the Part AML, I need help in determining…
  • Possible to update source_id? Aras Version 11.0 SP14

    I would like to change a record's "source_id" value using a command like: <Item type="myType" action="edit" id="F54D10BECFC14EAA88D09048A6EFCA1E"> <source_id>07DD8562F5FB43E7BC04DD152268B002</source_id> </Item> Does Aras forbid any "source_id" editing…
  • Accessiong the Values OnBeforeVersion AML Action="Version"

    I have some problem with the OnBeforeVersion trigger, If I try to create a new generation through AML with e.g. <AML> <Item type="Part" id="XXXXX" action=" version " select="id,keyed_name,description,created_on,modified_on,state,generation,config_id…
  • Attribute suppression with multiple parameters

    Hi, I'm looking to add a suppression to my ItemAnalysis.Suppressions xml file using 2 parameters in the same attribute suppression. How do I go about this/is this even possible? Currently we're on Aras 11SP12. We're looking at the following case. We…
  • orderBy itemtype properties with pagination

    Hello community, I am facing a new challenge, I need to sort the answer of a SOAP request but since I have an itemtype property, I only figure to sort on the id of the itemtype used in the property and not on the name of the instances... Datamodel…