Friday, 5 February 2016

Get item CHARACTERISTIC values of an Item


select * from innovator.PART where keyed_name='P00001'

-- Get ID from above results and use in the below query...


select  * from innovator.PART_ITEM_CHARACTERISTIC_VALUE where SOURCE_ID='36A093C8325A44698684354FAF6E3425'

--Above query will give all item characteristic values of P00001. This result will have "Display_Value" and "Text_value"