How to get product attribute values in AX 2012

public static void getProductAttributeValues(Args _args)
{
    ItemId                      itemId  = '0007';
    EcoResProductAttributeValue ecoResProductAttributeValue;
    AttributeValueText          attributeValueText;
    InventTable                 inventTable = InventTable::find(itemId);
    EcoResAttribute             ecoResAttribute;
    EcoResValue                 ecoResValue;
    ;

    while select ecoResProductAttributeValue
        where ecoResProductAttributeValue.Product == inventTable.Product
        join Name from ecoResAttribute
            where ecoResAttribute.RecId == ecoResProductAttributeValue.Attribute
        join ecoResValue
            where ecoResValue.RecId == ecoResProductAttributeValue.Value
    {
        attributeValueText = ecoResValue.value();
    }
}


 

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units.
Join us.

Blog Tags