UFN_DATALIST_PRODUCTISDATALIST

Returns true if the datalist is valid for the installed products.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@DATALISTID uniqueidentifier IN

Definition

Copy


      create function dbo.UFN_DATALIST_PRODUCTISDATALIST(@DATALISTID uniqueidentifier)
      returns bit
      with execute as caller
      as begin
          declare @ISPRODUCT bit = 0;

          with xmlnamespaces(default 'bb_appfx_datalist', 'bb_appfx_commontypes' as common)
          select @ISPRODUCT = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(
                      DATALISTCATALOG.DATALISTSPEC.query('/DataListSpec/common:InstalledProductList')
                  )
          FROM dbo.DATALISTCATALOG
          WHERE ID = @DATALISTID;

          RETURN @ISPRODUCT;
      end