Forum Discussion

CCA's avatar
CCA
New Contributor
8 years ago

Record retention - need recommendations for deleting code reviews after x years

Our company is implementing record retention policies.  This means after X years, code reviews must be deleted.  Has anyone else faced this and if so, how are you handling it from both a process and technical perspective?  We have a couple options we are discussing from a process standpoint, but I'm trying to figure out how we can technically do this with Collaborator. One option is x years from when a project was closed, go find and delete all the associated code reviews.  Another option is x years from when an individual code review is completed (or created), delete the review.

 

We are using Collaborator, which stores data in both the SQL database and in flat files on the server that have hash names.  How can you delete a code review (no button to delete a completed review)?  Will this delete the hash file?  If not, how in the world do you locate the associated hash files (I know the path they are in, but with the hash names no idea how to tell what is what)?

 

I look forward to any information that can be shared or recommended on this.

 

Mine

3 Replies

Sort By
  • AndrewF's avatar
    AndrewF
    SmartBear Alumni (Retired)
    8 years ago

    Hello,

     

    Unfortunately, technically it's not possible to delete a review once it's moved from "Planning" phase.

    It's possible to delete materials from a review stored in your content cache folder.

    Please run ccollab admin review-xml <reviewID> --xpath //md5sum

    It will return md5sums for your material. The first six characters of the hexadecimal md5 hash are used, two each, to form the three subdirectories it is under (in sequence) under the content cache, so a file with md5 hash 123456abcde... would be in collaborator-content-cache/12/34/56/ named 123456abcde.., you have to delete this file.

     

    Regards,

    Andrew.

    • MaryConti's avatar
      MaryConti
      Occasional Contributor
      8 years ago

      This is definitely a needed capability.  It would be an admin function -- even server admin -- but need to be able to archive old records.  Please put this on the enhancement list.

       

      • AlexeyKryuchkov's avatar
        AlexeyKryuchkov
        Staff
        8 years ago

        Hi,

         

        The appropriate enhancement requests are already posted here and here - please feel free to vote for them and discuss them.

         

        Thanks!