UFN_MKTNETCOMMUNITYINTEGRATION_LINKESTABLISHED

Returns true if the Blackbaud Internet Solutions Integration feature has been installed and a link established between Blackbaud Internet Solutions and Blackbaud Direct Marketing.

Return

Return Type
bit

Definition

Copy



CREATE function dbo.[UFN_MKTNETCOMMUNITYINTEGRATION_LINKESTABLISHED]()
returns bit
as 
  begin
    declare @ESTABLISHED bit;

    if exists (select top 1 1 from dbo.[TASKCATALOG] where [ID] = '17d3a2c1-8645-4c10-bc00-f9aac5760c38')
      set @ESTABLISHED = convert(bit, case when (select top 1 len([URL]) from dbo.[NETCOMMUNITYINTEGRATION]) > 0 then 1 else 0 end);
    else
      set @ESTABLISHED = 0;

    return @ESTABLISHED;
  end