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,,,
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='get' type='PERSON' select ='address_id'> <id>'abcdxyz'</id> </Item> I want to add some AML code to get Address Item with the id provided in above statement, something likes: <Item action='get' type='ADDRESS'> <id>The (*) query that returns an address id</id> </Item> I know that we can achieve the goal by writing a server method, but I just curious is there any way to get that within AML query? Many thanks,
Search Parameter with date time
I have condition parameter search for ItemType Part like this (modified_on > 2019-04-11T00:00:00 and modified_on <= 2019-04-20T00:00:00) Case 1. When I new item AML to search <Item type="Part" action="get" select="*" where="[Part].modified_on > '2019-04-11T00:00:00' AND [Part].modified_on <='2019-04-20T00:00:00' >". ----> it will return list Part with Part modified on 2019:04:05T00:00:00 -> Wrong, I dont know why the result is wrong Case 2. So I change code to create new AML <Item type="Part" action="get" select="*"> <modified_on condition="gt">2019-04-11T00:00:00 </modified_on> <modified_on condition="le">2019-04-20T00:00:00</modified_on> </Item> ----> It will return true results. So please help to find error in this case 1. Thanks so much[Part Classification] How to create AML to add classification for Part
Hi everyone, As my picture above, I want to use AML to edit Part and set value Item Class, Class Path and some value like m_Capacitance Uni, etc. I'm just a newbie in Aras. So please help me or let me know some keywords to resovle this issue. Thanks a lot.
