moved js into child view
added a view with nothing in it
added view-based reporting capacity
added views to sql