Ordering in categories
6 posts by 3 authors in: Forums > CMS Builder
Last Post: November 18, 2008 (RSS)
By andycal - October 15, 2008
I've got a setup using the category stuff with over 200 products through about 10 categories.
We've just tried to use the up/down links to order the products within a category and it doesn't do anything to the actual order.
When I hover over the 'up' link against a product, it gives me the following link:
admin.php?menu=products&action=categoryMove&direction=up&num=229
Looks fine. I click and it goes away, then comes back with the products in exactly the same order with no error displayed.
Any ideas?
Re: [andycal] Ordering in categories
By Dave - October 16, 2008
What is the sorting set to for that section? (Under Admin > Section Editors)
interactivetools.com
Re: [Dave] Ordering in categories
By andycal - October 16, 2008
Re: [Dave] Ordering in categories
I have lets say article. I create a "Section editor" for my article.
Each article are define with "category" (a list of choice), title, and content.
In order to display in a page only article of a specific category i do this :
'tableName' => 'article',
'orderBy' => 'category',
'where' => 'category="Sports"',
It works fine, but i want the page to list articles of "Sports" respecting the DragOrder in my admin.
So i try to do in Admin > Section Editors > Article >sorting this:
dragSortOrder DESC, category.
It doesn't work
I really need a page only with Sports Article (it works) but listed in the same order than in my admin .
Please help
Re: [willbegood] Ordering in categories
I simply modify on top of the page
'tableName' => 'article',
'orderBy' => 'category',
'where' => 'category="Sports"',
TO
'tableName' => 'article',
'orderBy' => 'category, dragSortOrder DESC',
'where' => 'category="Sports"',
It seems to work
Re: [willbegood] Ordering in categories
By Dave - November 18, 2008
Glad you got it working! That looks just fine. If you know you'll always be showing only one category type you don't even need to sort by category first since they will all be sorted the same, but that will work just fine the way it is.
interactivetools.com