AML Incorrect syntax near

Hi ! This AML got ERROR "Incorrect syntax near 'Mold' ". www.dropbox.com/.../2017-08-14_11h47_44.png   <Item isNew="1" isTemp="1" type="iq Mold Acceptance" action="edit" where="iq Mold Acceptance.id='2A4871E1511241E19E300EF92DD5B0C1'"> <Relationships> <Item isNew="1" isTemp="1" type="MOLDAPPLICATION_MOLDACCEPTANCE" action="add" id="7F0D3613FB6742B6AE7D5B60DF03ED3D"> <related_id> <Item isNew="1" isTemp="1" type="iq Mold application" action="get"> <id>0AEE07126DD3487AA51152ED8CD73F83</id> </Item> </related_id> </Item> </Relationships> </Item> We guess the answer is space . But not sure ! Replace iq Mold Acceptance with iq_Mold_Acceptance. The error message is : Failed to get the iq_Mold_Acceptance ItemType. We are not able to execute this AML ... any suggestions ? thank you !
  • Jerry, I have 2 options for you to make your code to work:
    1. If you know the ID for the item you can use id attribute and not where attribute, so your code will look like:
      <Item isNew="1"  type="iq Mold Acceptance" action="edit" id='2A4871E1511241E19E300EF92DD5B0C1'>
    2. If you want to use where attribute, you need to change the way you write it, so the name of the item will be between square brackets and spaces replaced with underline:
      <Item isNew="1"  type="iq Mold Acceptance" action="edit" where="[iq_Mold_Acceptance].id='2A4871E1511241E19E300EF92DD5B0C1'">
  • Thank you for your kind assistance.