Archived Flocks

In the database there is a column in the groups table called is archived.  All flocks that have a 1 instead of a 0 is archived.  Once archived flocks are removed from showing up in the applications flock list and from reporting until restored from Archive.  There is no form in the application to do this and needs to be completed in the database.

use [LIVE_XXXX_Prod_User]

update g
set g.isarchived = 1
from placement p
inner join [group] g on g.groupid = p.groupid
where placementdate < '2017-12-31' and g.statusid in (2,3,4)

Open