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?

All responses (3)

Answers (2)

Sort by

Verified answer

Martin Dráb 240,744 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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... :-(
Verified answer

Jason0810M 8 on at

Like (0)

Report
Copy link

Link copied!

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.
Martin Dráb 240,744 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, it looks fine to me.