3. Level Categories
3. Level Categories
Hi everybody, how can I get 3rd level Categories of a root category?
-
Logan Rhodehamel
- Developer
- Posts: 4116
- Joined: Wed Dec 10, 2003 5:26 pm
Re: 3. Level Categories
If you are comfortable doing some custom queries (http://wiki.ablecommerce.com/index.php/Custom_Queries) then you can get a list of 3rd level category IDs in a single query from the ac_CategoryParents table.
Code: Select all
SELECT CategoryId FROM ac_CategoryParents WHERE ParentId = @yourRootCategoryId AND ParentNumber = 2Cheers,
Logan
.com
If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.
Logan
.comIf I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.