T_Keyword/ List Criteria Cleanup

Does anyone have any tips for cleaning up T_Keyword?

I noticed this week that we have like 10 different list criteria that have to do with birthdate, many of which are old/unused.

Unfortunately, I don't see an inactive option on T_Keyword. I'm not necessarily ready to commit to deleting them yet, but I would like to get them off the List Manager screen.

Thoughts?

Parents
  • What Gawain said. I was literally typing nearly the same thing in a reply when Gawain's answer popped up. 

    We do the same thing with our keywords, using an "Archive" access control group that is configured to allow only Administrators to have access.

  • Thirded.  And the 'Archive" control group is just all around good in general for MANY things.  Ideally everything out have both the active/inactive flag AND control grouping, but sometimes that is not the case.  At any rate, the way we have always divided things is more or less like this:

    • Active - these things are actively in use.
      • Either currently in use, or used every other fiscal year, etc... often enough that it is worth having them as choices to regularly see.
      • These items do not have the inactive flag set.
    • Inactive - these things are not actively in use but are good for reference.
      • Prime example are things like recent seasons.  Sometimes you need to go back and reference this data, but it also does not need to be at the top of the list.
      • These items have the inactive flag set.
    • Archive - these things are not actively used, and in fact outdated for one reason or another and really should not be used again.
      • These are likely things that really should no longer exist as options but you do not want to (because database people often do not like deleting anything) or cannot delete.
      • Things like outdated facilities for venues you no longer control or keywords or elements that have been usurped by newer keywords or elements for newer versions or newer business practices.

    The system administrator would still be able to see everything should there be a question of re-using something again.  But this has never really happened for us.  (In fact, I probably need to take another look at things and archive some more stuff.)

  • Thanks for the great layout of the logic JAM 2.0. I appreciate distilled logic. Getting it down to that level is the hard part.

Reply Children
No Data