Action – qry_ExecuteQueryDefinition

AML Query

<!-- SOAP_ACTION = ApplyAML or ApplyItem -->
<Item type='qry_QueryDefinition' action='qry_ExecuteQueryDefinition'>
  <name>Test</name>
  <Relationships>
    <Item type='qry_QueryItem'>
      <alias>Part</alias>
      <item_type>4F1AC04A2B484F3ABA4E20DB63808A88</item_type>
      <ref_id>07F0C59AA80743CAB3E7FBAAF2C8BEB2</ref_id>
      <Relationships>
        <Item type='qry_QueryItemSelectProperty'><property_name>item_number</property_name></Item>
        <Item type='qry_QueryItemSelectProperty'><property_name>name</property_name></Item>
        <Item type='qry_QueryItemSelectProperty'><property_name>generation</property_name></Item>
      </Relationships>
      <offset_fetch_xml><![CDATA[<configuration><option><offset>0</offset><fetch>100</fetch></option></configuration>]]></offset_fetch_xml>
    </Item>
    <Item type='qry_QueryReference'>
      <child_ref_id>07F0C59AA80743CAB3E7FBAAF2C8BEB2</child_ref_id>
      <start_query_reference_path>/</start_query_reference_path>
      <filter_xml>&lt;condition&gt;&lt;lt&gt;&lt;property name="created_on"/&gt;&lt;property name="modified_on"/&gt;&lt;/lt&gt;&lt;/condition&gt;</filter_xml>
    </Item>
  </Relationships>
</Item>

Example (Result):

<AML>
  <Item alias="Part">
    <generation>1</generation>
    <name>Assembly of components #1</name>
    <item_number>ASSY-01</item_number>
  </Item>
  <Item alias="Part">
    <generation>1</generation>
    <name>Component part #1</name>
    <item_number>COMP-01</item_number>
  </Item>
  <Item alias="Part">
    <generation>3</generation>
    <name>Component part #1</name>
    <item_number>COMP-01</item_number>
  </Item>
  <Item alias="Part">
    <generation>2</generation>
    <name>Component part #1</name>
    <item_number>COMP-01</item_number>
  </Item>
  <Item alias="Part">
    <generation>1</generation>
    <name>Component part #2</name>
    <item_number>COMP-02</item_number>
  </Item>
</AML>