Forum Discussion

Aaba's avatar
Aaba
Ideator III
8 years ago

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 ty...
christopher_gillis's avatar
christopher_gillis
Community Manager
7 years ago

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