A little background, I'm trying to do a custom Category listing, but at the moment it seems the Category not being sort as I seen on Admin.
Here's the code that I've done so far
$current_store = $this->_storeManager->getStore(); $root_category_id = $this->_storeManager->getStore()->getRootCategoryId(); $collection = $this->_categoryCollectionFactory->create() ->addAttributeToSelect('*') ->addAttributeToFilter('is_active', 1) ->setStore($current_store); return $collection->addAttributeToFilter('entity_id', array('nin' => $root_category_id)) ->setOrder('position','ASC');
And the result, when I tried to echo its ID is like below
3 10 4 11 5 7 12 8 15 9 13 14 16 6
The problem that I realize is, that, I have sub category, I tried to echo the query from above code, and then copy-paste it into sql GUI, and I realize, the position is kinda weird but, it does make-sense, because it's a sub category.
Here's the result when I execute the query on sql GUI
So, what I tried to achieve is to sort above result, to reflecting what I set on Admin. Is there anything that I missed? I'm not sure where to look, since I've been stuck around 1-2 days, not sure what's the proper keyword, almost all keyword I did will arrive to product sort or kind of that, not category sort
Thanks in Advance!