AML Script to Check for Two or More Released Revisions of the Same Document Number

Try this

<Item action='get' type='Document' select='item_number,keyed_name'>
  <config_id condition='in'>select CONFIG_ID from innovator.DOCUMENT where STATE='Released' group by CONFIG_ID having COUNT(*)>1</config_id>
</Item>

You need to temporary add  the

<operating_parameter key="parse_item" value="false"/>

to InnovatorServerConfig.xml to disable the AML secutity restrictions on the "condition='in'" expression.

Try this

<Item action='get' type='Document' select='item_number,keyed_name'>
  <config_id condition='in'>select CONFIG_ID from innovator.DOCUMENT where STATE='Released' group by CONFIG_ID having COUNT(*)>1</config_id>
</Item>

You need to temporary add  the

<operating_parameter key="parse_item" value="false"/>

to InnovatorServerConfig.xml to disable the AML secutity restrictions on the "condition='in'" expression.

I get this error...

<SOAP-ENV:Envelope xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../">
  <SOAP-ENV:Body>
    <SOAP-ENV:Fault xmlns:af="">www.aras.com/InnovatorFault">
      <faultcode>SOAP-ENV:Server.ItemAnalysisException</faultcode>
      <faultstring><![CDATA[Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.
Details:
Incorrect value: "<config_id condition="in">select CONFIG_ID from innovator.DOCUMENT where STATE='Released' group by CONFIG_ID having COUNT(*)&gt;1</config_id>". Incorrect value explanation: "select" forbidden in property condition.
]]></faultstring>
      <detail>
        <af:legacy_detail><![CDATA[Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.
Details:
Incorrect value: "<config_id condition="in">select CONFIG_ID from innovator.DOCUMENT where STATE='Released' group by CONFIG_ID having COUNT(*)&gt;1</config_id>". Incorrect value explanation: "select" forbidden in property condition.
]]></af:legacy_detail>
        <af:exception message="Item Analysis Error. Some Items have incorrect attribute/property values syntax. See details for more information.&#xD;&#xA;Details:&#xD;&#xA;Incorrect value: &quot;&lt;config_id condition=&quot;in&quot;&gt;select CONFIG_ID from innovator.DOCUMENT where STATE='Released' group by CONFIG_ID having COUNT(*)&amp;gt;1&lt;/config_id&gt;&quot;. Incorrect value explanation: &quot;select&quot; forbidden in property condition.&#xD;&#xA;" type="Aras.Server.Core.ItemAnalysisException" />
      </detail>
    </SOAP-ENV:Fault>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

dkinsley さんの発言:

Incorrect value explanation: "select" forbidden in property condition.

Add the 

<operating_parameter key="parse_item" value="false"/>

to InnovatorServerConfig.xml

Sorry, I don't have access to the Innovator Server Configuration.