• Replies 4 replies
  • Subscribers 342 subscribers
  • Views 65 views
  • Users 0 members are here
Options
Related

T_Keyword/ List Criteria Cleanup

Shelly Binkley (she/her)
$organization

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 Reply Children
  • $organization in reply to Phillip Parks

    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.)

  • $organization in reply to John A. Moskal II

    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.