Sorting Content

More
18 Jan 2011 06:06 #642 by schoolvideonews
When we are selecting articles for the current months campaign, it would be helpful to have the MOST RECENT ADDED articles first in the selection list. How can I make this happen?

New user and VERY IMPRESSED so far.

THANKS!

Please Log in or Create an account to join the conversation.

More
18 Jan 2011 11:29 #648 by pete
Replied by pete on topic Sorting Content
Hi,

The articles are ordered by section (first condition) and by joomla article ordering which you set in the article manager (second condition).
Currently it's not possible to change that from the user interface. To change it permanently to order by creation date you can edit the file /administrator/components/com_joomailermailchimpintegration/models/create.php at line 102 (where it says ' ORDER BY a.sectionid, a.ordering '; ):

Replace line 102 with:
' ORDER BY a.created DESC ';

We'll implement sorting functionality but I'm not sure if this will make it into the next version so you would have to do this modification again after you upgrade the extension.

Kind regards,
Pete

Please Log in or Create an account to join the conversation.

More
18 Jan 2011 15:43 #650 by schoolvideonews
Replied by schoolvideonews on topic Sorting Content
Thanks, Pete! Appreciate the quick response. You do have a great add-one and will really increase our productivity. Do you do custom work? Im really NOT code-savy and would gladly pay for an hours consulting to have you make the changes in our site? Please contact me offline for more info? johnc@buysvs.com

THANKS!

Please Log in or Create an account to join the conversation.