UFN_SEARCHLIST_ISCONFIGURABLE
Returns a bit value indicating whether or not a search list is configurable
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEARCHLISTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_SEARCHLIST_ISCONFIGURABLE](@SEARCHLISTID uniqueidentifier) returns bit
as begin
declare @isConfigurable bit;
set @isConfigurable = 0;
select @isConfigurable = SEARCHLISTSPEC.exist('declare namespace srch="bb_appfx_searchlist";/srch:SearchListSpec[1]/srch:OptionalFields')
from dbo.SEARCHLISTCATALOG where ID = @SEARCHLISTID;
return @isConfigurable;
end