Retroactive Parents



3rd Party (Commercial)

EE Version Support

  • ExpressionEngine 1.x


If an item is crossed out, it might be untested, not applicable or incompatible. Contact the developer to be sure.

  • Updater
  • Multi Site Manager
  • Stand Alone Entry Form
  • Low Variables
  • Content Elements
  • Better Workflow
  • Matrix
  • Grid
  • Webservice
  • Publisher


  • jQuery for the Control Panel

Add-On Type(s)



This extension enables to make selected parent categories retroactive.

In one case exp_category_posts table is not updated when one would expect it to be updated. Say you have a category which has category id 260. Then you post into that category an entry, which has entry id 3377. Then if you run the code

{exp:query sql="SELECT cat_id FROM exp_category_posts WHERE entry_id = '3377'"}

the category id of the entry will be displayed.

Now say you create a category which has category id 261 and after that you make this category the parent of the category 260.

Having made such changes you would expect that the code above will display both category ids - 260 and 261. But instead it will display only 260 as earlier.

Both category ids will be displayed only in case the entry 3377 will be updated after category 261 was made the parent of the category 260.

I think that such behavior is not good since it goes against the principle that all entries posted into child category are considered to be entries posted into its parent category. I even thought that this behavior might be considered a bug, but Robin disagreed

Bug or not, it seems that after some category was made a parent of some other category, the table exp_category_posts should be updated accordingly to reflect the change.

As it is, when you make this kind of category relationship change the change doesn’t “take” in individual entries unless you go through and update every single one.

Now using Retroactive Parents extension you have a means to make your changes retroactive if you choose, that is this extension will make what is needed that for selected parent categories all entries posted into any child category will also be posted into relevant parent category.

Retroactive Parents Links

Hooks Used

If the add-on is an extension, and ties into ExpressionEngine's core files, it will use ExpressionEngine hooks. We are listing any hooks the add-on uses for developers to have an easier time locating other add-ons that they can reference for their own work.

  1. show_full_control_panel_end

This entry was created December 4, 2009, 11:56 am.
This entry was last updated November 2, 2010, 3:08 am.

Disclaimer: Information about ExpressionEngine add-ons is provided as a service to you, the user, and every member of the ExpressionEngine community. devot:ee is not responsible if you hose, mangle, wreck, or otherwise destroy your EE website by installing an add-on that you found out about at this site, regardless of its rating, Favorites status, commercial or free status, or general popularity. Caveat EEmptor!

Returns: devot:ee has a 30-day return policy on all commercial add-ons sold through If you need to return an add-on, do not go to the developer or the developer's site, but rather visit our returns page at to initiate your return. If you have questions, email

1 Review:

Todd D. 12.28.09

Todd D.
Rating - {addon_rating_average}

This extension really plugs a hole in using parent and child categories. If you parent/child cats on your sites, this is a good extension to have waiting in the arsenal.