AML search to return only the count of object corresponding
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 from a tab. For example I want to get the number of the Parts with status = Draft Best regards, Hadrien
How to fetch details of nested relationships using AML query?
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 also.AML problem using action='update' (in order to modify an item without changing generation)
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</keyed_name> </Item> </myItemProperty> </AML> That AML works with edit but it changes the generation... I get that error whatever my item is locked or unlocked... <SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../"> <SOAP-ENV:Body> <SOAP-ENV:Fault xmlns:af="">www.aras.com/InnovatorFault"> <faultcode>SOAP-ENV:Server.ItemIsNotLockedException</faultcode> <faultstring><![CDATA[Aras.Server.Core.ItemIsNotLockedException]]></faultstring> <detail> <af:legacy_detail><![CDATA[Aras.Server.Core.ItemIsNotLockedException]]></af:legacy_detail> <af:exception message="Aras.Server.Core.ItemIsNotLockedException" type="Aras.Server.Core.ItemIsNotLockedException" /> <af:item type="myItem" id="5CC09554029A4E76AD0601C9F8C2AC33" /> </detail> </SOAP-ENV:Fault> </SOAP-ENV:Body> </SOAP-ENV:Envelope> Any idea ? Best regards, Hadrien
Uploading a local file to Innovator using the Batch Loader
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> <filename>@1</filename> </Item> This currently fails. I had to search to find out the <actual_filename> tag is used for the fully qualified path of the file, yet it is not present in the File Item when inspecting it through Innovator Client. Any help with this would be appreciated.
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 = \'' + this.getID() + '\')))"><generation condition="gt">0</generation></Item>'); tdpList = tdpList.apply(); I need to reuse this Method for another ItemType. I have discovered that using Where and In causes an error because of a security update in 11 SP9. Aras 11.0 - AML Security Settings 2017-04-28 mentions that you can create an exception to allow specific statements, but recommends changing the code to something else. I remember reading that this exception is supposed to be phased out in 12. How can I change this statement to correctly return the list I need? I can get the information by using a Get and Relationships, but it will not create the proper list. I think this is do to the information returned since it includes the ItemType and Relationship ItemType information. Thank you for any help you can provide.
How to convert an item to List ?
Hello, I'm working with ARAS for few years now. I'm sending AML queries and receiving ITEMS back. Every case requires a new method of deciphering the data using getProperty or getPropertyItem calls. Is there any way to convert any item to array or list? Regards OCohenUse multiple "like" conditions in AML query?
Hi, I have: setType("Part"); setProperty("permission_name", "New %"); setPropertyAttribute("permission_name", "condition", "like"); var item = apply(); How do I change this to use multiple "like" conditions? I want to express something like: "permission_name LIKE 'New %' OR permission_name LIKE 'In Work %'" Thanks,,,
