CREATE VIEW    dbo.MultiFilteredObjectView AS 

  SELECT APID.AllPositiveIDs ,
  UTO.UserTablesOnly,
  NLSP.NameLikeSP,

  AO.Name, AO.object_id, AO.Type, AO.type_desc FROM sys.all_objects AO 
  OUTER APPLY (
  SELECT  
    AllPositiveIDs = 1 
  FROM sys.all_objects O WHERE  O.Object_Id = AO.Object_Id 
  AND O.Object_id > 0 

  ) APID
  OUTER APPLY (
  SELECT  
    UserTablesOnly  = 1 
  FROM sys.all_objects O WHERE  O.Object_Id = AO.Object_Id 
  AND O.Type = 'U' 

  ) UTO 
  OUTER APPLY ( 
  SELECT  
    NameLikeSP  = 1 
  FROM sys.all_objects O WHERE  O.Object_Id = AO.Object_Id 
  AND O.Name LIKE 'SP%'

  ) NLSP 

GO

SELECT * FROM dbo.MultiFilteredObjectView  V WHERE NameLikeSP = 1 

SELECT * FROM dbo.MultiFilteredObjectView  V WHERE UserTablesOnly = 1   

  CREATE VIEW    dbo.MultiFilteredObjectView2 AS 

  SELECT 
    AO.Name
  , AO.object_id
  , AO.Type
  , AO.type_desc 
  , FilterName = 'NameLikeSP'
  FROM sys.all_objects AO 
  WHERE AO.Name LIKE 'SP%'
  
 UNION ALL 
  SELECT 
    AO.Name
  , AO.object_id
  , AO.Type
  , AO.type_desc 
  , FilterName = 'PositiveId'
  FROM sys.all_objects AO 
  WHERE AO.object_id > 0 

 UNION ALL 
  SELECT 
    AO.Name
  , AO.object_id
  , AO.Type
  , AO.type_desc 
  , FilterName = 'AllRecords'
  FROM sys.all_objects AO 
 


GO

SELECT * FROM dbo.MultiFilteredObjectView2  WHERE FilterName = 'PositiveId'

SELECT * FROM dbo.MultiFilteredObjectView2   WHERE FilterName = 'AllRecords'

select ... from ... where original_login() = 'domen\aaa'
union all
select ... from ... where original_login() = 'domen\bbb'
...