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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Get list of products b...
Microsoft Dynamics AX (Archived)

Get list of products by attribute

(0) ShareShare
ReportReport
Posted on by tturney 605

 I need to populate a grid with a query that displays a list of products that have a certain product attribute and attribute value.  For example we have items that have a Boolean product attribute of “Molds used”.  I want to display a grid that lists all the items that have a product attribute of “Molds used” with a true value.

 I have found samples that show how to get the attributes for a given product, but not the other way around.  I can get a list of products with the "Molds used" attribute, but it fails when I try to get the attribute value.

 Is anyone doing anything like this or have an idea of how I should set this query up?

Tom T.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    dolee Profile Picture
    dolee 11,279 on at

    Hi,

    There is a view named EcoResProductAttributeValue. Using that view, you can link to:

    - EcoResProduct

    - EcoResAttribute

    - EcoResValue

    Then, use the EcoResValue.value() method to get the text representation of the attribute value.

    If you need the actual data type, you'll have to do some extra work to find the correct derived table. Check this link (msdn.microsoft.com/.../gg881064.aspx) for an example of selecting data from table inheritance hierarchy.

  • tturney Profile Picture
    tturney 605 on at

    Dolee,

     Thanks for your answer and the link.  I can see that the ecoResValue table consists of many other tables and I can link to the right one.

    Tom T.

  • Ax tech Profile Picture
    Ax tech 220 on at

    Hi tom,

    i found this conversation quite interesting, were u able to create the populate the grid with all the product.

    If you could share your solution it will help me

    Ax tech

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans