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 R...
Forum Discussion
I assume it´s possible to rewrite this one, but I assume most people are not very good in reading SQL from others.
Can you describe how your s_Document and s_TDP_Document ItemTypes are linked together?
Are both of them independent ItemTypes or is a s_TDP_Document a relationship of your s_Document?
Are additional ItemTypes involved?
Which one of the two document itemTypes is linked to your "this.getID()"?
Maybe you can provide a simple structure like
Part <--- I want to get this one
--> Part AML
-----> Manufacturer Part <--- I start from here. this.getID() contains the id of this Item
Angela,
Good day. I guess a bit more information would be helpful. [emoticon:c28b2e4cc20f4ba28d1befdba6bed29c] s_TDP_Document is a Relationship tab to s_TDP (Technical Data Package). s_Document is a Poly Source of six different document ItemTypes (previous caretakers didn't use any of the OOTB ItemTypes). The TDP allows the gathering of documents and then the Method will search for the most current version of Released and download them into a zip file.
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:
<AML><Item type='Part' action='get' select='item_number' id='" + myID + "'><Relationships><Item type='Part AML' action='get' select='related_id(item_number)'/><related_id><Item type='Manufacturer Part' select='item_number'></Item></related_id></Relationships></Item></AML>;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
I have tried that in the code, but it is not generating the list correctly. The code I supplied creates a list of the s_Documents. Using code like you stated creates a list using s_TDP. Using the list the rest of the Method (written in JavaScript) looks at each entry and determines if there are attached documents. Then it bundles everything up and downloads the documents.
My code sample was based on how I understood your description. :)
Does "bundle everything up" mean you use the "build a zip package" community project? This uses the file id´s of related files. I would try to get a proper list of these ids first before caring about the export.
Some questions:
1. Where do you start your Method (grid/form/cui)? From which item (s_TDP?)?
2. Where are your files in the items? Do you use a File relationship grid or File property?
3. What result do you want to use from the query. You don´t have a select filter so it´s hard to tell.
