Finance | Project Operations, Human Resources, ...

How to get Category Name of an ItemId of Level 3

(0) Share

Report

Posted on by premK6969

198

Hi there, we are developing Stock Analysis report for which there is a field Category Name which needs to populate EcoresCategory.Name value for an ItemId but the Level Should be 3. For exmaple Take ItemId: 12345 for which the Hierarchy Levels are (Level1 > Level2 > Level3 > Level4>Level5). We need to consider only Level 3 CategoryName and needs to print value accordingly for selected ItemId from InventTrans. Please suggest accordingly.

CategoryName = EcoresCategory.Name

Level = EcoresCategory.Level (We need to capture Level - 3)

ItemId = InventTrans.ItemId

Thanks,

Prem

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!

Hi premK6969,

You can find the category for the product with EcoResProductCategory: InventTable (use ItemId to find the record) -> EcoResProductCategory.Product = InventTable.Product ->EcoResCategory.RecId = EcoResProductCategory.Category

Then you need to check if the level is greater than 3, then find the parent category via the parent category field (EcoResCategory.RecId = EcoResCategory.ParentCategory) until the level is not equal to 3.

Also, you can cache the search result and store in map pairs "Item category" - "3rd level category" to speed the search process and first lookup 3rd level from the map and if it's not found in the map, search from tables and put the result to map.

Was this reply helpful? Yes No
premK6969 198 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergei, Can u please be more specific since am new to this .

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!
Hi premK6969,

You should get something like that in the end (without the caching part)

InventTable inventTable = InventTable::find(inventTrans.ItemId); EcoResCategory ecoResCategory = EcoResCategory::find(EcoResProductCategory::findCategoryByProduct(inventTable.Product).Category); while (ecoResCategory.Level > 3) //Create const or parameter in report for this value { ecoResCategory = ecoResCategory.getParent(); } info(ecoResCategory.Name); //Name of 3rd level category

Was this reply helpful? Yes No
premK6969 198 on at

Like (0)

Report
Copy link

Link copied!
Hi Sergei, i tried with the code you provided but cant able to see the expected result. Actually i need to place this code in a method and call it in report RDP class to get the catgegory name as per the ItemId. Please find the code attached
ItemId _itemid; _itemid = any2str(852012); InventTable inventTable = InventTable::find(_itemid); // For testing i tried it with ItemId = 852012 EcoResCategory ecoResCategory = EcoResCategory::find(EcoResProductCategory::findCategoryByProduct(inventTable.Product).CategoryHierarchy); // Here you mentioned Category which is throwing error so i changed to Categoryhierarchy while (any2Int(ecoResCategory) > 3) //Create const or parameter in report for this value { ecoResCategory = ecoResCategory.getParent(); // While debugging here it is throwing exception error } info(ecoResCategory.Name); //Name of 3rd level category

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,097 on at

Like (0)

Report
Copy link

Link copied!
Hi premK6969

FindCategoryByProduct already returns EcoResCategory and related line of code can be simplified

InventTable inventTable = InventTable::find(inventTrans.ItemId); EcoResCategory ecoResCategory = EcoResProductCategory::findCategoryByProduct(inventTable.Product); while (ecoResCategory.Level > 3) //Create const or parameter in report for this value { ecoResCategory = ecoResCategory.getParent(); } info(ecoResCategory.Name); //Name of 3rd level category

Was this reply helpful? Yes No