changed dashboard view to query db @dahernan @colinbruce