added single quote view with db/wview/and template changes