How to show "modified date" column in article manager backen

Need help with the Administration of your Joomla! 2.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
sleepyralph
Joomla! Intern
Joomla! Intern
Posts: 68
Joined: Sat Oct 24, 2009 5:54 pm

How to show "modified date" column in article manager backen

Post by sleepyralph » Fri Apr 12, 2013 8:01 am

I have a huge number of articles dating back to 2010 (imported from J1.5 website) which I am systematically going through to update them, check content etc. It would be a VERY much quicker job if I could see in the article manager which ones I have already modified, sort by modified date etc. Is it possible to get a column showing modified date in Article Manager? At the moment I have to open every article to see the date. Is there an setting, an extension even god forbid, a hack?

ta.

 
User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19986
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: How to show "modified date" column in article manager ba

Post by leolam » Fri Apr 12, 2013 8:31 am

You have no such plugin and it does not exist. I could be done with a hack but you have an easy way of checking the created and modified date.

If you go to PHPmyadmin and you go to the content table > browse that table you have the option to select on created date as well as modified date. So if you select on modified date and than export the table as csv for excel than you have your date in excel....You than delete the columns not needed and keep ID/created and modified as a table. This you keep next to your article manager and you can easy follow the modified dates already......

Makes sense?

Leo 8)
Joomla's #1 Professional Services Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27432
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: How to show "modified date" column in article manager ba

Post by imanickam » Fri Apr 12, 2013 8:49 am

What you want to do could be done by editing two core Joomla! files as shown below:

(a) File articles.php located in the directory \administrator\components\com_content\models

Note: This is a core Joomla! file that could not be overridden. So, the changes you are making may be overwritten in the future releases of Joomla! Take enough care to back up the original file and the modified file.

Change the file in two different places as shown below:

(ii) In the public function __construct

Code before change:

Code: Select all

				'created_by_alias', 'a.created_by_alias',
				'ordering', 'a.ordering',
Code after change:

Code: Select all

				'created_by_alias', 'a.created_by_alias',
				'modified', 'a.modified',
				'ordering', 'a.ordering',
(ii) In the protected function getListQuery()

Code before change:

Code: Select all

				', a.state, a.access, a.created, a.created_by, a.created_by_alias, a.ordering, a.featured, a.language, a.hits' .
Code after change:

Code: Select all

				', a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.ordering, a.featured, a.language, a.hits' .

(b) File default.php that is located in the directory \administrator\components\com_content\views\articles\tmpl.

Note: Being a core Joomla! file, suggest following the output html override technique as documented at http://docs.joomla.org/How_to_override_ ... omla!_core.

(i) In the header
Code before change:

Code: Select all

				<th width="5%">
					<?php echo JHtml::_('grid.sort', 'JDATE', 'a.created', $listDirn, $listOrder); ?>
				</th>
				<th width="5%">
					<?php echo JHtml::_('grid.sort', 'JGLOBAL_HITS', 'a.hits', $listDirn, $listOrder); ?>
				</th>
Code after change:

Code: Select all

				<th width="5%">
					<?php echo JHtml::_('grid.sort', 'JDATE', 'a.created', $listDirn, $listOrder); ?>
				</th>
				<th width="5%">
					<?php echo JHtml::_('grid.sort', 'JGLOBAL_FIELD_MODIFIED_LABEL', 'a.modified', $listDirn, $listOrder); ?>
				</th>
				<th width="5%">
					<?php echo JHtml::_('grid.sort', 'JGLOBAL_HITS', 'a.hits', $listDirn, $listOrder); ?>
				</th>
(ii) In the detail row
Code before change:

Code: Select all

				<td class="center nowrap">
					<?php echo JHtml::_('date', $item->created, JText::_('DATE_FORMAT_LC4')); ?>
				</td>
				<td class="center">
					<?php echo (int) $item->hits; ?>
				</td>
Code after change:

Code: Select all

				<td class="center nowrap">
					<?php echo JHtml::_('date', $item->created, JText::_('DATE_FORMAT_LC4')); ?>
				</td>
				<td class="center nowrap">
					<?php echo JHtml::_('date', $item->modified, JText::_('DATE_FORMAT_LC4')); ?>
				</td>
				<td class="center">
					<?php echo (int) $item->hits; ?>
				</td>
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19986
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: How to show "modified date" column in article manager ba

Post by leolam » Fri Apr 12, 2013 8:52 am

Nice one MIG!. User can do this, upgrade his articles and than replace with original file again. Did you actually think of posting this as a feature request? This would be a very nice addendum in the backend?

Leo 8)
Joomla's #1 Professional Services Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27432
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: How to show "modified date" column in article manager ba

Post by imanickam » Fri Apr 12, 2013 12:29 pm

Thanks Leo for the comments... I will create a patch and send it to the development team for including this feature...
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

User avatar
rowbygoren
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Wed Jun 19, 2013 1:03 pm
Contact:

Re: How to show "modified date" column in article manager ba

Post by rowbygoren » Fri Oct 25, 2013 12:38 am

Hi imanickam

This would be a great patch for Joomla. I have often wanted to be able to search for modified date, and will try your code.

I would strongly encourage this feature (really necessity) to be a part of the Joomla core.

Such a addition would receive much applause from Joomla users.

Thanks

Rowby

User avatar
Chamira Athauda
Joomla! Explorer
Joomla! Explorer
Posts: 440
Joined: Sat Apr 21, 2012 2:15 am
Location: Sri Lanka
Contact:

Re: How to show "modified date" column in article manager ba

Post by Chamira Athauda » Wed Jun 25, 2014 5:44 am

I am looking for exactly this.

We really need a way of adding/removing a set of properties columns in the Article manager area to help users to organize their content.

May be through the Article Manager Options section?

Did you send this as a feature request MIG?

User avatar
rowbygoren
Joomla! Intern
Joomla! Intern
Posts: 59
Joined: Wed Jun 19, 2013 1:03 pm
Contact:

Re: How to show "modified date" column in article manager ba

Post by rowbygoren » Wed Jun 25, 2014 12:18 pm

Hi coruja

I am not 100 percent how to make this a feature request. If you know where and how please let's get this going. It seems such an obvious need.

Rowby

User avatar
Chamira Athauda
Joomla! Explorer
Joomla! Explorer
Posts: 440
Joined: Sat Apr 21, 2012 2:15 am
Location: Sri Lanka
Contact:

Re: How to show "modified date" column in article manager ba

Post by Chamira Athauda » Wed Jun 25, 2014 5:26 pm

rowbygoren wrote:Hi coruja

I am not 100 percent how to make this a feature request. If you know where and how please let's get this going. It seems such an obvious need.

Rowby
I am not sure about this either, may be we should send a PM to imanickam and ask if he has requested this already.

User avatar
imanickam
Joomla! Master
Joomla! Master
Posts: 27432
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: How to show "modified date" column in article manager ba

Post by imanickam » Thu Jun 26, 2014 1:53 am

Good Morning!

I have not made a formal request for the feature request. Let me discuss with other developers and follow the procedure.

I will keep update this thread about what is transpiring.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Translations Coordination Team | Tamil (தமிழ்) Translation Team

Eegan - Support the poor and underprivileged

User avatar
infograf768
Joomla! Master
Joomla! Master
Posts: 18934
Joined: Fri Aug 12, 2005 3:47 pm
Location: **Translation Matters**

Re: How to show "modified date" column in article manager ba

Post by infograf768 » Thu Jun 26, 2014 5:37 am

If you propose the patch, do not forget to also update the file filter_articles.xml (specially in back-end) with the new Options.

Code: Select all

<option value="a.created ASC">JDATE_ASC</option>
<option value="a.created DESC">JDATE_DESC</option>
<option value="a.modifed ASC">JMODIFIED_DATE_ASC</option>
<option value="a.modifed DESC">JMODIFIED_DATE_DESC</option>
This will require 2 new strings in en-GB.ini:

Code: Select all

JMODIFIED_DATE_ASC="Modified date ascending"
JMODIFIED_DATE_DESC="Modified date descending"
Jean-Marie Simonet / infograf · http://www.info-graf.fr
---------------------------------
ex-Joomla Translation Coordination Team • ex-Joomla! Production Working Group

User avatar
TomT
Joomla! Ace
Joomla! Ace
Posts: 1270
Joined: Thu Aug 18, 2005 5:50 am
Location: Amsterdam
Contact:

Re: How to show "modified date" column in article manager ba

Post by TomT » Wed Aug 03, 2016 9:02 am

imanickam wrote:What you want to do could be done by editing two core Joomla! files as shown below:
It still works, great.
Thank you for this clear explanation, Tom

 

Locked

Return to “Administration Joomla! 2.5”