News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) get Item category in X++

Microsoft Dynamics AX (Archived)

get Item category in X++

(0) Share

Report

Report

Posted on by Zeeshan Adeel

335

private void getItemCategory(ItemId _itemid)
{
ItemId itemId = "ITEMNO-000000572";//"ITEMID-000104";
EcoResProductCategory EcoResProductCategory;
EcoResCategory EcoResCategory;
EcoResProduct EcoResProduct;
InventTable InventTable;
;

select EcoResCategory
join EcoResProductCategory
join EcoResProduct
join InventTable
where EcoResCategory.RecId == EcoResProductCategory.Category
&& EcoResProduct.RecId == EcoResProductCategory.Product
&& EcoResProduct.RecId == InventTable.Product
&& InventTable.ItemId== itemid ;

{
info(strFmt("%1",EcoResCategory.Name));
//return EcoResCategory.Name;

}
}

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: get Item category in X++

Hi,

You can get the Category name from the EcoResCategory table.

Here is the query.

select * from EcoResCategory
join EcoResProductCategory
join Inventtable
where EcoResCategory.RecId == EcoResProductCategory.Category
&& EcoResProductCategory.Product == Inventtable.Product
&& Inventtable.ItemId == 'ItemId';

info(strfmt('%1', EcoResCategory.CODE));

Let me know if you have any questions.
Martin Dráb 230,198 Most Valuable Professional on at

Like (0)

Report

RE: get Item category in X++

Why are you spamming this forum with code snippets without any explanation? What kind of help are you looking for here?

Also, please use </> button in the rich formatting view to paste source code.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans