web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Product Attributes
Microsoft Dynamics AX (Archived)

Product Attributes

(0) ShareShare
ReportReport
Posted on by Community Member

I would like to pull a table from the AOT that would give the values associated with the Product Attributes.  I have looked at EcoResAttribute Value, EcoREs Atrribute etc.  I am able to find a table that gives me the code for the attribute but not necessarily the attribute that has been specified against it - for instance, if Storage is an attribute, I would like to see Ambient or Frozen etc. I have looked at the below table which shows the attribute and the value in code but can't find a table telling what the value is ??? Please help

Attribute Product Value recVersion Partition RecId
5637144576 5637145614 5637144800 5637144576 5637144576
5637144599 5637145614 5637144801 5637144576 5637144577
5637144596 5637145614 5637144802 5637144576 5637144578
5637144585 5637145614 5637144803 5637144576 5637144579
5637144622 5637145614 5637144804 5637144576 5637144580
5637144599 5637145615 5637144805 5637144576 5637144581
5637144618 5637145615 5637144806 5637144576 5637144582
5637144585 5637145615 5637144807 5637144576 5637144583
5637144622 5637145615 5637144808 5637144576 5637144584
5637144599 5637145616 5637144809 5637144576 5637144585

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 48,920 User Group Leader on at
    RE: Product Attributes

    I am not sure any easy way to it using user interface. Might be DIXF, help in this case.

    Otherwise you may use below code script of x++.

    Note:

    I am going to add range for 1 product, for testing purpose, you may modify that as per need.

    public static void ProductAttributes_SC()
{
    EcoResProductAttributeValue ecoResProductAttributeValue;
    EcoResAttribute             ecoResAttribute;
    EcoResValue                 ecoResValue;
    RefRecId                    varProduct;
    EcoResProduct               EcoResProduct;
    ;


    varProduct = 22565429825;//you may remove or modify this range
    
    while select ecoResProductAttributeValue
        where ecoResProductAttributeValue.Product == varProduct
            join Name from ecoResAttribute
            where ecoResProductAttributeValue.Attribute ==    ecoResAttribute.RecId
                join ecoResValue where ecoResValue.RecId == ecoResProductAttributeValue.Value
    {
        EcoResProduct = EcoResProduct::find(varProduct);
        setPrefix('Product: '+EcoResProduct.DisplayProductNumber+' '+EcoResProduct.SearchName);
        
        info(strFmt("Attribute Name %1 ;  Attribute Value:  %2",ecoResAttribute.Name,ecoResValue.value()));
    }

    
}


  • Suggested answer
    ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    RE: Product Attributes

    Expose the query EcoResProductAttributeValue through Document Data Sources and then pull it down in Excel, you'll get all the attributes assigned to the product and their values.

  • Community Member Profile Picture
    Community Member on at
    RE: Product Attributes

    Not sure I understand what you  mean by "expose it"...Can you please clarify? Thanks!

  • Suggested answer
    ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    RE: Product Attributes

    Organization Administration -> Setup -> Document Management -> Document Data Source ->  New

    Module does not matter, just pick one.

    Data Source Type will be Query Reference

    Data Source Name will be  EcoResProductAttributeValue

    Click Activate.

    Then in Excel on Dynamics AX tab on ribbon, make sure you are connect to the same environment via the Options button, then do Add-Data -> Add-Data and you should see EcoResProductAttributeValue.  

  • Community Member Profile Picture
    Community Member on at
    RE: Product Attributes

    And this will give me a different set of info than if I just grab the table from the AOT?

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    RE: Product Attributes

    Their are multiple tables supporting the product attribute data in the AOT, so there's no one table to grab, hence the query / view.  The human readable of the data is all display methods, which wont show in a table browse. If you need this for a report, join into the dependent EcoResProductAttributeValue view that exists.  If you just want to browse what's created, viewing in Excel is the easiest way i've found.

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    RE: Product Attributes

    http://imgur.com/zP1179m  

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Product Attributes

    Hi,

    Not sure If I understand this correctly. If you're trying to get the attribute descriptions or names along with their backend values :

    You can get the description of attributes from "EcoResAttributeTranslation" table by joining it to "EcoResAttribute" table

  • Community Member Profile Picture
    Community Member on at
    RE: Product Attributes

    No actually I am looking to get the actual values associated with the attributes.  For instance, if the attribute is storage for item X then I want to see what value was actually specified whether it is frozen or refrigerated etc.

  • ColbyGallagher Profile Picture
    ColbyGallagher 3,666 on at
    RE: Product Attributes

    Right, see the screenshot I sent.  That's what you'll get in Excel.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans