View: dbo.Filter_Base_Type_View | |||
View definition | |||
create view dbo.Filter_Base_Type_View as select filter_base_type_KEY = FBT.filter_base_type_KEY , filter_type_KEY = FBT.filter_type_KEY , filter_line_type_KEY = FBT.filter_line_type_KEY , filter_line_type__description = FLT.description , filter_line_type__subfilter__filter_type_KEY = FLT.subfilter__filter_type_KEY , description = FBT.description , filter_column = FBT.filter_column , update__staff_KEY = FBT.update__staff_KEY , update__staff__staff_id = S.staff_id , update_date = FBT.update_date from dbo.Filter_Base_Type FBT left outer join dbo.Filter_Type FT on FT.filter_type_KEY = FBT.filter_type_KEY left outer join dbo.Filter_Line_Type FLT on FLT.filter_line_type_KEY = FBT.filter_line_type_KEY left outer join dbo.Staff S on S.staff_KEY = FBT.update__staff_KEY cross join (select property_value from dbo.Database_Property DP where property_name = N'Database Configuration') DP where -- Exclude the Service base type record for the Client filter when running SBPR. SBPR doesn't support services. not (DP.property_value = N'SBPR' and FBT.filter_base_type_KEY = 664) and -- Exclude the Client Services base type record for the Client filter when running ACS. ACS handles those in a different way. not (DP.property_value <> N'SBPR' and FBT.filter_base_type_KEY = 766) | |||