Get XProperties through SQL

Hi Christopher

I want to do duplicate Part check based on xProperties values

Example: Part001 has xp-height :10 xp-length : 10. When user creates Part002 with same xp properties value, system should not allow.

My approach was trying to fetch the Part with xp-height and xp-length with particular value and if data exist prevent save.

When using below AML query, getting count '1' which already exist

<AML>

<Item action='get' type='Part' select='xp-*'>

<xp-height>10</xp-height>

<xp-length>10</xp-length>

</Item>

</AML>

when user filled only height then, AML query will be like below and also getting count '1'

<AML>

<Item action='get' type='Part' select='xp-*'>

<xp-height>10</xp-height>

</Item>

</AML>