ReverseItemsGrid

Hello, The format of the AML query provided isn't quite correct. Instead, you will need to format the query to look like the example below.

<AML>
<Item type="MIN_SCO" action="get" where="min_sco.id in (select id from innovator.MIN_SYSTEM where CUSTOMER = 'MY_ID')">
</Item>
</AML>

Please note however, that in recent service packs, Innovator no longer directly supports using a SQL query like above inside of a where clause through AML. This was a change made for security reasons. If you are an Aras subscriber, you can learn about a way to exclude specific SQL queries from this security check by looking at the AML Security Settings.pdf in the Documentation folder of the CD Image. Alternatively, you could run this AML from within a Method. This would allow you to first perform a get of all of the MIN_SYSTEM items in your database which you can use to build a list of IDs. You can then pass that in as a comma separated string into the idlist attribute of the query you perform to get the MIN_SCO items. Chris

---

Christopher Gillis Aras Labs Software Engineer

Hello, The format of the AML query provided isn't quite correct. Instead, you will need to format the query to look like the example below.

<AML>
<Item type="MIN_SCO" action="get" where="min_sco.id in (select id from innovator.MIN_SYSTEM where CUSTOMER = 'MY_ID')">
</Item>
</AML>

Please note however, that in recent service packs, Innovator no longer directly supports using a SQL query like above inside of a where clause through AML. This was a change made for security reasons. If you are an Aras subscriber, you can learn about a way to exclude specific SQL queries from this security check by looking at the AML Security Settings.pdf in the Documentation folder of the CD Image. Alternatively, you could run this AML from within a Method. This would allow you to first perform a get of all of the MIN_SYSTEM items in your database which you can use to build a list of IDs. You can then pass that in as a comma separated string into the idlist attribute of the query you perform to get the MIN_SCO items. Chris

---

Christopher Gillis Aras Labs Software Engineer