Get XProperties through SQL
Hi
How to get the extended classification properties and its values using SQL. I'm able to get it through AML
Forum Discussion
4 Replies
Hello,
We typically recommend against using SQL to either get or edit data as it bypasses the Aras permission model. Could you clarify your use case for getting the extended classification properties through SQL?
Chris
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>
Hi,
Can someone give some hint on how to achieve this
