Is it converted into Sql insert statement. I would also like to know about Odata, how is it implemented in ARAS?

<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)…

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 …

I'm having issues uploading a local file to an instance of Innovator using the Batch Loader. I have the following XML: <Item type="Document File" action="add"> <related_id> <Item type="File" action="add"> <actual_filename>C:\some\file\path\@1</actual_filename…

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:…

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…

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…

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…

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…

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…

I have a requirement like Main Phase can have relationship with Activities and Phases, also Phases can have child phases eg: i want to get the id of all activity (itemtype2) if i provide id of main phase is provided ? A phase can have no activity…

Hello, AML works in Nash. When an user is created i want to put his identity into another identity. This method is plugged on after add event of identity item type. Could you tell me id i missed someting ? Should i put an apply somewhere ? …

Hi, I use ConsoleUpgrade.exe to export a package from a DEVELOPMENT aras environment and to import this package in a PRODUCTION aras environment. After the import, I need to execute some specific AML to clean some ItemType or execute some methods…

hello, i post that here as a reminder because i was not able to find information about this : <AML> <Item type="ItemType" id="0E4B48B11212429DB971*BFB026ADB97" action=" edit "> Add / Delete <allow_private_permission>1</allow_private_permission…

Hi community, I am trying to modify a property on all the generation of an item. Thus I am trying to merge those two requests 1) Modify the latest generation without changing the generation : <AML> <Item action='merge' type='Part' where="[Part…

Hello Aras Community, i am would like to perform this SQL request but in using AML : Innovator _innovator = this.getInnovator(); StringBuilder sql = new StringBuilder(); sql.AppendLine("SELECT ID, ***_code, config_id, state, Major_Rev, Generation…

Hello, not sure if anyone is having this problem but I seem to not be able to do a bulk item creation with AML. I'm using Nash which has worked before but when I put this code in for example: <AML> <Item type ='Part' action ='add' > <item_number>…

Why aren't my RelationshipTypes on my custom ItemType exported when I run Aras's export.exe program? It renders it useless if it doesn't include *everything*.

Hi community, I am trying to transform a where condition based on id into a where condition based on the keyed name or item_number Outside a where condition it would be < source _id> <Item type="Part" action="get" select="id"> <keyed_name…

Hi, I would like to create a web form application ASP.NET to comunicate with Aras throught the IOM api. In Aras I created a query that I use for the tree grid view. The tree grid view contains the menu structure (with the main menu items and all levels…

Hi community, I have a request to get from an AML request only the number of item corresponding to the AML request. In Odata and SQL it is ok but I cannot find the equiavlent. I precise that I do not want to create a method to count the items…

Hi I am facing a problem with an AML expression. <AML> <Item action='update' type='myItem' where="[myItem]._title='myItemName' and [myItem].generation='1' "> <myItemProperty> <Item type="myItemProperty" action="get" select="id"> <keyed_name>myItemPropertyName…

Hi I am trying to import several generation of an item. In AML I can do it with <Item type='myItem' action='merge' where="[myItem]._title='123456'"> <_title>523556 </_title> <_start_date> 2019-09-30T00:00:00 </_start_date> <_end_date></_end_date…

How to use client to get sql View data? Can I use AML? Thank you.

Hi, I'm trying to update PART DOCUMENT relationship but facing issue: AML: <AML> <Item type="Part Document" action="edit" where="[Part_Document].id='C080331098D24F00B635418D823D97AC'"> <related_id>AFF14CBFFD074494B00E3D247D8D11FE</related_id> <…