Rewrite Hotwire3 views for Research Groups with group_status to use new is_research_group_active() function
Take the existing hotwire3 view definition for https://chemdb.ch.cam.ac.uk/hotwire3/chemistry/list.php?_view=10_View/Groups/Research_Groups_Computing
and rewrite to use the function.
Also search for other views with a ro_group_status
column in the information schema and update those if they exist.