[Feature] get the breacrumb for a category

[ghost]

Hi @griffinqiu ,

Hope you are all well !

I am stuck while trying to get the breadcrumb for a category.
Do you have an idea of how I can do that ?

Thanks for any insights or inputs on that

Cheers,
Luc Michalski

[griffinqiu]

What is the maximum level of your scene?
Usually there are fewer levels.(Such as less than 5 levels). I will find by parent_id level by level.

[mgsmus]

@lucmichalski Breadcrumb for a category means you have to query the anchestors of the given category

SET @categoryId= 8;

SELECT 
  parent.id
FROM 
  categories AS category, 
  categories AS parent 
WHERE 
  category.lft BETWEEN parent.lft 
  AND parent.rgt 
  AND category.id = @categoryId
ORDER BY 
  parent.lft;