AML = SQL Where (IN)

Question

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.

AngelaIp · Answer

So your structure is the following: s_TDP --- s_TDP_Document ------ s_Document / Polysources And you have the id of s_TDP? Than it´s comparable to a regular Part/Part AML/Manufacturer Part ("let´s look downwards") query: ; Not sure about the PolyItem. For testing you can also start with the upper levels and then add the additional levels downwards until the query works. I personally wouldn´t use loadAML. It´s possible to rewrite the Method so it basically does the same, but without having one large string. Check out the structure shown in these blog articles: https://community.aras.com/b/english/posts/server-side-best-practices-part-3 https://community.aras.com/b/english/posts/server-side-best-practices-part-2