Hi,
There are 2 questions functional and technical.
1) We know that we can attach a product attribute via Procurement category form to a released product. The released product can be attach to a product category and it will inherit the attributes of that category.
Q : Can you assign attribute to any category or only procurement /Retail related category hierarchy.
My requirement is to attach Product to a custom category hierarchy Role which would have some attributes and we can attach the same to the products as done in procurement category..
Q: Is it possible to attach attribute to custom hierarchy group attach to a custom hierarchy role ?
Eg. Item is attached to below and it will show its attributes on click of Product attributes.
The product attributes form only shows procurement or retail related attributes as per my knowledge..
ITS OK if I dont see the product attributes for custom hierarchy on the product attributes form , I just want to confirm if it actually works
Technical side
I want to know how are the ecoresattribute and related tables etc are linked.
In case I assign a new attribute to a procurement or custom role then how do i check whether the record is actually created or not.
I am using below custom query in sql to check records
select inventtable.product,DATAAREAID from inventtable
join EcoResProductAttributeValue on inventtable.product = ecoResProductAttributeValue.product
join EcoResAttribute on EcoResAttribute.recid = ecoResProductAttributeValue.Attribute
where inventtable.product = 22565423870
Thanks,
VM