Forum Discussion

didonato's avatar
didonato
Creator II
8 years ago

Error in AML

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 = 'F7783E44C97442EDB36...
eli_donahue's avatar
eli_donahue
Community Manager
8 years ago
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