• State Not Answered
  • Replies 5 replies
  • Subscribers 10 subscribers
  • Views 11930 views
  • Users 0 members are here
Options
Related

Error in AML

didonato
Offline
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. ==============================
Parents
  • 0 Offline
    Hi didonato, This error is occurring because the property tag needs to contain a comma delimited list of values when you're using condition="in". For example: 
    <AML>
  <Item type="User" action="get">
    <firstname condition="in">'Tom','Peter','Joe'</firstname>
  </Item>
</AML>
    The server won't automatically execute the SQL to build the value list. Eli
    Eli Donahue Aras Labs Software Engineer
Reply
  • 0 Offline
    Hi didonato, This error is occurring because the property tag needs to contain a comma delimited list of values when you're using condition="in". For example: 
    <AML>
  <Item type="User" action="get">
    <firstname condition="in">'Tom','Peter','Joe'</firstname>
  </Item>
</AML>
    The server won't automatically execute the SQL to build the value list. Eli
    Eli Donahue Aras Labs Software Engineer
Children
No Data