I keep getting an error with my AML code.
<Item type="MIN_DCP" action="get"
select="id(item_number)">
<system condition="in">(select id from innovator.MIN_SYSTEM where customer = 'F7783E44C97442EDB36286E7B8F89471') </system>
</Item>
==============================
CDATA[Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.
Details:
Incorrect value: "<system condition="in">(select id from innovator.MIN_SYSTEM where customer = 'F7783E44C97442EDB36286E7B8F89471') </system>". Incorrect value explanation: "select" forbidden in property condition.
==============================
Eli,
If I change the syntax from "(select id from innovator.MIN_SYSTEM where CUSTOMER= ‘F7783E44C97442EDB36286E7B8F89471’) " to
(select id from innovator.MIN_SYSTEM where PRODUCT= ‘ABCDE44C97442EDB36286E7B8F89471’)it works fine, actually all fields that are related work fine except customer and I'm not sure why.
Eli,
If I change the syntax from "(select id from innovator.MIN_SYSTEM where CUSTOMER= ‘F7783E44C97442EDB36286E7B8F89471’) " to
(select id from innovator.MIN_SYSTEM where PRODUCT= ‘ABCDE44C97442EDB36286E7B8F89471’)it works fine, actually all fields that are related work fine except customer and I'm not sure why.