Question

Photo of Jon Morrissette

0

How do delete a group with "child group historicals"

7

I have some groups that cannot be deleted because they contain "child group historicals."  Could someone explain what this means, and more importantly, if there is a way to declutter my group viewer from these unneeded groups?

  • Photo of Tiffany Bunney

    0

    I can't explain what it means, but I will tell you we just tried to address this with group members this week. We actually had to go into the backend of the database and delete the group member from the group. There was no way to delete them in Rock. It is really frustrating, to say the least.

  • Photo of Jon Morrissette

    0

    Tiffany, there aren't any group members assigned to any of the groups I'm wanting to delete. Are you saying that there is "historical group member" ghost information still tied to the groups even after a person has been deleted?

  • Photo of Tiffany Bunney

    0

    Maybe not. Do you have a checkin set up for it. I think attendance is tied to this.

  • Photo of Gordon Arber

    0

    Tiffany, can you explain how you removed members from those groups through the backend?

  • Photo of Tiffany Bunney

    0

    We looked up the person id associated with the Group Member, then ran a sequel statement to find them in the Group and then deleted them. 

  • Photo of Jon Morrissette

    0

    For reasons I cannot discern, there are groups that cannot be deleted or archived.  At an earlier date, whatever related child groups connected to the groups I want to delete, were either deleted or archived and are non existent from the front end application.  I think initially my mistake was making groups of 'small group' type children of others groups of 'small group' type


    So I went into SQL backend and I manually updated the "IsArchived" column from 0 to 1 on all those groups that I couldn't delete, archive, or make disappear from the front end application.


    Here was the SQL code:

    UPDATE [Group]

    SET IsArchived=1

    WHERE Id=#####


  • Photo of Nelson Chan

    0

    There is basically an orphaned entry in the table [grouphistorical] that you need to delete.

    select * FROM [GroupHistorical] where parentgroupid = <group id>

    and run a manual delete on the results using SQL (be 110% you are doing the delete correctly).

    The IsArchive is technically archiving the group, but functionally it shouldn't affect standard ROCK operations, but it may show up in other queries if you don't check for IsArchived.