Forum Discussion

majorbyte's avatar
majorbyte
Ideator III
9 years ago

AML throws Aras.Server.Core.AmbiguousCriteriaException

I'm trying to update the datasource of a property to the correct datasource in our test and production environments, but without the use of ID's because that's what caused the problem I'm trying to co...
AML
majorbyte's avatar
majorbyte
Ideator III
9 years ago
I managed to get it working by rewriting the inner where statement to a nested <Item action=get> 
<Item action="edit" type="Property" where="[Property].keyed_name = 'era_locked_by' and [Property].source_id = (select id from [ItemType] where name ='Document')">
    <data_source keyed_name="locked_by_id">
      <Item type="Property" action="get" select="id">
        <keyed_name>locked_by_id</keyed_name>
        <source_id>
          <Item type='ItemType' action='get'>
            <name>Document</name>
          </Item>
        </source_id>
      </Item>
    </data_source>
  </Item>
So my initial feeling was (probably?) right, that AML can't copy really well with nested where-statements.