finished views for client DAO