• Home
  • Learn Joomla
    • Roadmap for New Users
    • Joomla Lingo
    • Joomla Installation
    • Joomla Administration
    • Joomla Documentation
    • Tutorials
  • How-to Videos
    • Index to Videos
    • Site Basics Videos
    • FAQ Videos
  • How Do I?
  • Links
    • Links Home
    • Template Sources
    • Sample Sites
    • General Joomla Sites
    • Official Joomla Sites
    • My Favorite Extensions
    • Joomla Documentation
    • Joomla Tutorial Sites
  • Site Showcase
  • Blog
  • Contact

How do I sort the articles in the admin content manager by date?

PDF | Print | E-mail

 
This applies to Joomla 1.0.13 only
 
If you've worked with Joomla much, you have noticed that the content manager sorts the articles by section, then by category, then by date.

Or, perhaps you didn't notice!

Anyway, while that is fine for many situations, it is terrible for other situations.

In those cases, you probably want the articles to be sorted by date, with the most recent article at the top of the list. 

Well, you can do this easily with a one line change in the Joomla source code.

Be sure to make a backup copy of the file before you change it in case something goes wrong!

 

The file that you want to edit is: administrator/components/com_content/admin.content.php

Look down around line 150 and you will see the following code:

$order = "\n ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering";

This is the line that determines the sort order for the items in the content manager.

Let's change that line so that it says this:

$order = "\n ORDER BY ORDER BY c.created DESC";

Save the file and upload it back to your server, and you are done!  It's a very simple code change that you might find helpful.

 

 

 
New? Start Here ...
  • Roadmap for New Users
  • Joomla Basics
  • How Do I Do This?
  • Free Templates
  • Joomla Tutorial Sites
  • Find the Joomla Documentation
  • Templates & Design Issues
  • FAQ Videos
  • Joomla Books
Quick Access
  • What's New / What's Hot
  • Recent Good Stuff
  • John's Joomla Toolbox
  • Template Sources
  • Recommended Joomla Tutorials
  • John's Real Job
  • Site Feedback / Contact
  • Site Credits
Recent "Good Stuff"
  • How to use the expanded user profiles in Joomla 1.7
  • A new template from JoomlaShine and an update to their slide show
  • 2 simple plug-ins for administrator approval of new users
  • A new version of the free template JA Purity - Wow!
  • A very nice, "lite" administrative template
  • A very easy way to keep your Joomla install up to date
  • Add new power to your administrative control panel
  • A couple of great modules for your site
  • A Great Free Template from JoomlaShack: Optimus
Featured Articles
  • Joomla Lingo
  • Why Should I Use Joomla?
  • How do I change the footer text in a template?
  • What is the difference between a component, a module and a mambot / plugin ?
Joomla 1.5 Featured Articles
Top "How Do I?" Articles
  • How do I create a quick "logout" button for users?
  • How to change the Joomla date format
  • How do I "move" a Joomla website from one folder to another?
  • Where does Joomla keep the articles?
  • Changing the text of messages in Joomla
  • How do I put a picture in an article?
  • Module Installation for Dummies
  • Making GIMP look like Photoshop
  • How to I create a custom page for a user to see after they submit a "contact us" message
  • Set up a demo site that allows many people to use the same login
home | site map | contact

Welcome to Joomla is an interesting side project by John Muehleisen.  Who is this guy, anyway?

The Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries.
WelcomeToJoomla.com is not affiliated with or endorsed by Open Source Matters or the Joomla! Project.