Get all property of item type and their data type

Hi Guys, I am trying to get the list of all properties in the Aras Item and their Data Type like String, boolean, Integer, date E.g. Part Item type is having property as item_number and it's data type is "String". Is there any way to get these datatypes in aras or any AML script for this? Thanks.
Parents
  • Hello,

    Angela's suggestion of using the ItemType Definition Report is probably the best approach since it filters out all of the system properties that are automatically created. However if you need all of the properties on the ItemType, then you can use a query like the one below.

    <AML>
    <Item type="ItemType" action="get" select="name" where="ItemType.name = 'Part'">
    <Relationships>
    <Item type="Property" action="get" select="name,data_type"/>
    </Relationships>
    </Item>
    </AML>

    Chris

    Christopher Gillis

    Aras Labs Software Engineer

Reply
  • Hello,

    Angela's suggestion of using the ItemType Definition Report is probably the best approach since it filters out all of the system properties that are automatically created. However if you need all of the properties on the ItemType, then you can use a query like the one below.

    <AML>
    <Item type="ItemType" action="get" select="name" where="ItemType.name = 'Part'">
    <Relationships>
    <Item type="Property" action="get" select="name,data_type"/>
    </Relationships>
    </Item>
    </AML>

    Chris

    Christopher Gillis

    Aras Labs Software Engineer

Children