USP_DALIST_CONFIGURABLESEARCHLISTS
Returns a list of all configurable search lists in the system
Definition
Copy
CREATE procedure dbo.USP_DALIST_CONFIGURABLESEARCHLISTS
as
set nocount on;
select
V_INSTALLED_SEARCHLISTCATALOG.ID,
V_INSTALLED_SEARCHLISTCATALOG.UINAME as NAME,
V_INSTALLED_SEARCHLISTCATALOG.DESCRIPTION,
(select [NAME] from dbo.RECORDTYPE where ID = V_INSTALLED_SEARCHLISTCATALOG.RECORDTYPEID) as 'Record Type'
from
dbo.V_INSTALLED_SEARCHLISTCATALOG
where
V_INSTALLED_SEARCHLISTCATALOG.SEARCHLISTSPEC.exist('declare namespace srch="bb_appfx_searchlist";/srch:SearchListSpec[1]/srch:OptionalFields') = 1
order by V_INSTALLED_SEARCHLISTCATALOG.UINAME