• Replies 2 replies
  • Subscribers 40 subscribers
  • Views 4911 views
  • Users 0 members are here
Options
Related

AML Studio Query

dkinsley
Offline

I created a query in AML Studio to return if the affected item is a Part or a Document. Unfortunately, it returns the list value instead of the list label. How do I modify the following to return the list label "Part" or "Document"?

<AML>
<Item type="a_CN" action="get" page="1" select="a_businessunit,cn_number,date_completed" pagesize="" maxRecords="">
  <date_completed condition= "ge">2018-10-01</date_completed>
  <Relationships>
    <Item type="a_CN_Affected_Item" action="get" select= "action,effectivity_date,new_type"></Item>
  </Relationships>
</Item>
</AML>

Parents Reply Children
  • Offline in reply to Skyler Crossman

    <SOAP-ENV:Envelope
      xmlns:SOAP-ENV="">schemas.xmlsoap.org/.../">
      <SOAP-ENV:Body>
        <Result>
          <Item type="a_CN" typeId="4301258ECE5F4A759530A5E57833C8E1" id="F1359938368640B59A308F8D465EDDA1">
            <date_completed>2019-08-15T00:00:00</date_completed>
            <id keyed_name="CN-001227" type="a_CN">F1359938368640B59A308F8D465EDDA1</id>
            <cn_number>CN-001227</cn_number>
            <a_businessunit>TFC</a_businessunit>
            <Relationships>
              <Item type="a_CN_Affected_Item" typeId="26A661BCAABA4958BDFFC4D1E1E7E0DA" id="FCF7C3FC036B437B8BCF9D23ADA00E7B">
                <action>Revise</action>
                <effectivity_date>2013-10-31T00:00:00</effectivity_date>
                <id keyed_name="FCF7C3FC036B437B8BCF9D23ADA00E7B" type="a_CN_Affected_Item">FCF7C3FC036B437B8BCF9D23ADA00E7B</id>
                <new_type>4F1AC04A2B484F3ABA4E20DB63808A88</new_type>
                <source_id keyed_name="CN-001227" type="a_CN">F1359938368640B59A308F8D465EDDA1</source_id>
              </Item>
              <Item type="a_CN_Affected_Item" typeId="26A661BCAABA4958BDFFC4D1E1E7E0DA" id="A55F8219AA924EF298FDBCACDA516D67">
                <action>Revise</action>
                <effectivity_date>2013-10-31T00:00:00</effectivity_date>
                <id keyed_name="A55F8219AA924EF298FDBCACDA516D67" type="a_CN_Affected_Item">A55F8219AA924EF298FDBCACDA516D67</id>
                <new_type>B88C14B99EF449828C5D926E39EE8B89</new_type>
                <source_id keyed_name="CN-001227" type="a_CN">F1359938368640B59A308F8D465EDDA1</source_id>
              </Item>
            </Relationships>
          </Item>