Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to use SQL to get ...
Microsoft Dynamics AX (Archived)

How to use SQL to get the released product Name

(0) ShareShare
ReportReport
Posted on by ATMA-Jen 305

Hello All,

I use SQL to get the  released product Name , but the name is wrong or different with the name in AX Release Product.

SQL:

select IT.ITEMID , ET.NAME 
from ECORESPRODUCTTRANSLATION as ET left join INVENTTABLE as IT on IT.PRODUCT=ET.RECID
order by IT.ITEMID DESC

*This post is locked for comments

  • MATTGUO Profile Picture
    MATTGUO 22,306 on at
    RE: How to use SQL to get the released product Name

    Hi ATMA-Jen,

    In addition,do you check the translation name in AX if you use ECORESPRODUCTTRANSLATION table?

    5287.snipaste_5F00_20190103_5F00_103343.png

    You can add DATAAREAid field to help you find item quickly.

  • Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: How to use SQL to get the released product Name

    If your issue is solved mark answer(s) that helped you as verified to close this thread.

  • Suggested answer
    ATMA-Jen Profile Picture
    ATMA-Jen 305 on at
    RE: How to use SQL to get the released product Name

    Thanks a lot for help.

  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,278 on at
    RE: How to use SQL to get the released product Name

    Hi ATMA-Jen,

    You forgot to add range by language and has incorrect fields in the join, it should be:

    SELECT IT.ITEMID, ET.NAME 
FROM ECORESPRODUCTTRANSLATION as ET LEFT JOIN INVENTTABLE as IT ON IT.PRODUCT = ET.PRODUCT
AND ET.LANGUAGEID = 'en-us'
ORDER BY IT.ITEMID DESC


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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans