get Item category in X++

(0) Share

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 (2)

Answers (0)

Suggested answer

Community Member 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 233,334 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.