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

[sleepyralph]

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.

[leolam]

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

[imanickam]

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>

[leolam]

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

[imanickam]

Thanks Leo for the comments... I will create a patch and send it to the development team for including this feature...

[rowbygoren]

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

[Chamira Athauda]

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?

[rowbygoren]

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

[Chamira Athauda]

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.

[imanickam]

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.

[infograf768]

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"

[TomT]

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