ipdated active groups to not show group if any field is NULL