Home | Products | Consulting | Forums | Support | Order | 1-800-752-0455
  Main
Index
Search
Posts
Who's
Online
Log
In

Home: Products: CMS Builder:
Ordering in categories

 

 


andycal
User

Oct 15, 2008, 9:52 AM

Post #1 of 6 (766 views)
Shortcut
Ordering in categories Can't Post

Hi,

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?


Dave
Staff / Moderator


Oct 15, 2008, 10:35 PM

Post #2 of 6 (733 views)
Shortcut
Re: [andycal] Ordering in categories [In reply to] Can't Post

Hi andycal,

What is the sorting set to for that section? (Under Admin > Section Editors)

Dave Edis - Senior Developer
interactivetools.com


andycal
User

Oct 15, 2008, 10:58 PM

Post #3 of 6 (730 views)
Shortcut
Re: [Dave] Ordering in categories [In reply to] Can't Post

Ahh! That'll be it! It wasn't set. Now set it to : "globalOrder, siblingOrder" and it seems to be working fine.


willbegood
User

Nov 18, 2008, 9:40 AM

Post #4 of 6 (577 views)
Shortcut
Re: [Dave] Ordering in categories [In reply to] Can't Post

Hello, i think i have a similar problem, but impossible to solve it.
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


willbegood
User

Nov 18, 2008, 9:50 AM

Post #5 of 6 (576 views)
Shortcut
Re: [willbegood] Ordering in categories [In reply to] Can't Post

i found the solution i think :

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


Dave
Staff / Moderator


Nov 18, 2008, 2:06 PM

Post #6 of 6 (572 views)
Shortcut
Re: [willbegood] Ordering in categories [In reply to] Can't Post

willbegood,

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.

Dave Edis - Senior Developer
interactivetools.com

 
 
 


Search for (options)
Products
CMS Builder
Article Manager
Realty Manager
Listings Manager
Order Now
Services
Priority Consulting
Support
Online Documentation
Support Forums
Support Homepage
Company Info
12 reasons to choose us!
Meet the team
Monthly newsletter
Contact Us
Toll Free: 1-800-752-0455
Phone: (604) 689-3347
Sales | Support
Conditions of Use | Privacy Policy | Copyright © interactivetools.com 2008
#201 - 2730 Commercial Drive, Vancouver BC Canada V5N 5P4