Find if product forms part of a child /sub child category

(0) Share

Report

Posted on by Jason0810M

Hello,

I have a scenario where assuming we have EcoResCategory categories A which contains a child category B and B contains C as follows in terms of hierarchy:

I have an item 100000 which is found in the category C. I have a validation check to do as follows:

If ever some one selects category A and product 100000 on a new custom form, it should return true as technically the product 100000 is found in its sub child C. Same applies for B.
I am having trouble to do this. I tried using the methods getDescendants and getChildren. However, it is not performance friendly and it is not working properly.

Is it possible to do this in a single select statement?

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Martin Dráb 237,679 Most Valuable Professional on at

Like (0)

Report

Find if product forms part of a child /sub child category

Pay attention to fields called NestedSetLeft and NestedSetRight. If you want to know whether C is contained in A, check if the range of the nested set is contained.

For example, let's say that the range of A is <1, 100>, B has <30, 60> and C <40, 50>, while a node D not belonging under A has <120, 130>. You can easily say that <40, 50> is in <1, 100>, therefore C is a subcategory of A.

Does it makes sense?

I planned to write a blog post about it, but I keep postponing it... :-(

Was this reply helpful? Yes No
Verified answer

Jason0810M 8 on at

Like (0)

Report

Find if product forms part of a child /sub child category

Hello Martin,

I have followed your advice and implemented a method in EcoResProductCategory extensionn using the hierarchy structure.

It looks to be working. I am passing the item's productRecId and the category's ecoResCategory to be checked.

Let me know if it is okay. Thanks.

Was this reply helpful? Yes No
Martin Dráb 237,679 Most Valuable Professional on at

Like (0)

Report

Find if product forms part of a child /sub child category

Yes, it looks fine to me.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Find if product forms part of a child /sub child category

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Find if product forms part of a child /sub child category

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates