 |
getpchelp
Novice
May 19, 2008, 11:12 AM
Post #1 of 11
(1745 views)
Shortcut
|
|
Sorting of Articles
|
Can't Post
|
|
Is there a way to sort the articles in the Admin area just like you can as with the categories or do I have to write the code to do it?
I know it displays the articles on the site by date and time. Our customer would like to be able to move them around from the admin site.
Thank you,
John
|
|
| |
|
Jake
Staff
/ Moderator
May 19, 2008, 9:11 PM
Post #2 of 11
(1733 views)
Shortcut
|
|
Re: [getpchelp] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hi John,
Thanks for your post!
You can customize the sorting of the articles on the admin side of Article Manager by going to Admin -> Database Editor and clicking the "edit table & fields" link for db_article. On this page, there's a text field called "Default Sort Fields". Just make the required adjustments here and click "Save Table".
Let us know if you need anything else. 
-----------------------------------------------------------
Cheers,
Jake Swanson - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
aussierewards
User
May 20, 2008, 2:56 PM
Post #3 of 11
(1658 views)
Shortcut
|
|
Re: [Jake] Sorting of Articles
[In reply to]
|
Can't Post
|
|
HI Jake, Can you give some options ? For instance, could you put "category" as a fieldname ? or are we able to only re-order the default fieldnames ? IE (-featured, -date, title). What other fieldnames could be used ?.
Thanks Jake
|
|
| |
|
Jake
Staff
/ Moderator
May 20, 2008, 9:08 PM
Post #4 of 11
(1628 views)
Shortcut
|
|
Re: [aussierewards] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hi aussierewards,
You can use every single one of the article fields used in your article database for sorting - even custom ones you create. So you wouldn't be able to sort by "category", because there's no field for that in the article database normally, however you could add it if you wanted to. You aren't limited to the default ones, so the sorting possibilities are pretty much endless.
Feel free to contact us if you have any other questions.
-----------------------------------------------------------
Cheers,
Jake Swanson - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
getpchelp
Novice
Jun 16, 2008, 5:41 AM
Post #5 of 11
(937 views)
Shortcut
|
|
Re: [Jake] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Thank you very much. That was easy. I created a new db field called display_order. Set as an integer with a max field length of 3 characters limited to numberic values only. Allow duplicate values allowing us to set the same value so they are sorted based on category then display_order.
Now when creating articles we just have to input the order in which we want it displayed on the site. IE: 1 first 2 second and so forth.
The only downside is that we have to keep track of the last number used but not a huge deal.
I set the sort order of the articles to use this new field and works like a charm!
Thank you for your help.
John
|
|
| |
|
Jake
Staff
/ Moderator
Jun 16, 2008, 12:04 PM
Post #6 of 11
(916 views)
Shortcut
|
|
Re: [getpchelp] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hi John,
Thanks for the update - I'm glad to hear that you were able to come up with a solution that works for you.
-----------------------------------------------------------
Cheers,
Jake Swanson - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
getpchelp
Novice
Jun 30, 2008, 6:02 AM
Post #7 of 11
(597 views)
Shortcut
|
|
Re: [Jake] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hello,
As in my previous posts we created an additional field for sorting that is simply a numeric value. IE: 1 2 etc.
The articles are displayed on the site in the order determined by this new field. Article 1 displays first and so on.
When creating new articles and we see the list of existing articles in AM. Is there a way to show the value of this sort field next to the existing articles in the list without having to remember the last number we used on the previous article?
Thank you,
John
|
|
| |
|
Jake
Staff
/ Moderator
Jun 30, 2008, 12:18 PM
Post #8 of 11
(577 views)
Shortcut
|
|
Re: [getpchelp] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hi John,
It is possible to show extra fields on the article list page, but this does require modifying Article Manager's administrative template files. For more information on how to do this, take a look at this forum post by Mike:
http://www.interactivetools.com/iforum/gforum.cgi?post=57451;search_string=article%20editor%20field%20admin;t=search_engine#57451
Let us know if you have any further questions about that.
-----------------------------------------------------------
Cheers,
Jake Swanson - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
getpchelp
Novice
Jul 6, 2008, 10:45 AM
Post #9 of 11
(449 views)
Shortcut
|
|
Re: [Jake] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hi Jake,
Thank you again for your help. That works out well.
The only problem is that in order for sorting of the records using a integer prevents us from inserting an article using for example article 9.5. If we store as a string then the sorting field "display_order" handles it as a string and once we are at article number 10 and goto 11 it sorts based on the first character then the second. Any way around this? Hope I made this clear.
Not a huge deal if we can't insert between existing articles without rearranging the entire sort order. Just be nice to be able to do as it would make it easier.
Thank you,
John
|
|
| |
|
Jake
Staff
/ Moderator
Jul 6, 2008, 1:43 PM
Post #10 of 11
(439 views)
Shortcut
|
|
Re: [getpchelp] Sorting of Articles
[In reply to]
|
Can't Post
|
|
Hi John,
There isn't really a way around that problem, however what I could suggest instead is that instead of using an integer like "9" for your sort order, you use something like "900". That way if you need to insert something inbetween, you can use a number like "950" without disrupting the existing order. You could set up your field restriction to ensure that users enter a three digit number for this field.
I hope that helps.
-----------------------------------------------------------
Cheers,
Jake Swanson - Product Specialist
support@interactivetools.com
Hire me!
Save time by getting our experts to help with your project. Template changes, advanced features, full integration, whatever you need. Whether you need one hour or fifty, get it done fast with Priority Consulting.
|
|
| |
|
getpchelp
Novice
Jul 6, 2008, 10:07 PM
Post #11 of 11
(386 views)
Shortcut
|
|
Re: [Jake] Sorting of Articles
[In reply to]
|
Can't Post
|
|
That's a great idea! Thank you again for all your help!
John
|
|
| |
|
