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 correct in the first place, the id's for (for instance) properties in test and production don't always match the id's in our development environment. So, I wrote this AML:
<Item action="edit" type="Property" where="[Property].keyed_name = 'era_locked_by'">
  <data_source keyed_name="locked_by_id">
    <Item type="Property" action="get" select="id" where="[property].keyed_name = 'locked_by_id' and [property].source_id in (select it.ID from innovator.ITEMTYPE it where it.name = 'DOCUMENT')" />
  </data_source>
</Item>
but when I run in Innovator Admin for instance, it returns <af:exception message="Aras.Server.Core.AmbiguousCriteriaException" type="Aras.Server.Core.AmbiguousCriteriaException" /> This is probably because of the nested Properties where statement, but is there any to make this work, without using actual id's?
Parents
  • majorbyte, Good catch. Actually now I remember that I had this question to Aras support some time ago and they told me, not to use where condition for setting properties. So you right. One comment about "case sensitivity", you right it will work, but for my opinion it good idea to keep your code as cleaner and close to original names of ItemTypes as possible. It will be easier for you or other developer to read this code and understand what you wanted to do.
Reply
  • majorbyte, Good catch. Actually now I remember that I had this question to Aras support some time ago and they told me, not to use where condition for setting properties. So you right. One comment about "case sensitivity", you right it will work, but for my opinion it good idea to keep your code as cleaner and close to original names of ItemTypes as possible. It will be easier for you or other developer to read this code and understand what you wanted to do.
Children
No Data