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, HadrienAML 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, Hadrienbatchloader to import several generation
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> <_status>New</_status> </Item> This AML request works it gives : But in the batchloader I got an error since I could not make a aml like <Item type='myItem' action='merge' where="[myItem]._title='@2'"> Any Idea ? Thanks. Best regards Hadrien
AML Search Query - If name exists in any field, do not display in results
I am trying to look up work orders where the specified name is not anywhere on the distribution. Currently the way it is set up, it will display work orders where "John Doe" is included because there are more than one lines on distribution and while it finds the name on one line, it won't find it on another. So is there a way to create a search where it searches all names on distribution, if it shows up even once to not display that work order in results? Any help is welcomed! Thank you! <Relationships> <Item type="Work Order Distribution" action="get"> <_assigned> <Item type="Identity" action="get"> <NOT> <keyed_name condition="like">John Doe</keyed_name> </NOT> </Item> </_assigned> </Item> </Relationships>
