UFN_SIMPLEDATALIST_PRODUCTISSIMPLEDATALIST

Evaluates a simple datalist for product flags.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@SIMPLEDATALISTID uniqueidentifier IN

Definition

Copy


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

          with xmlnamespaces(default 'bb_appfx_simpledatalist', 'bb_appfx_commontypes' as common)
          select @ISPRODUCT = dbo.UFN_INSTALLEDPRODUCTS_OPTIONALPRODUCTSINSTALLED(
                      SIMPLEDATALISTCATALOG.SIMPLEDATALISTSPECXML.query('/SimpleDataListSpec/common:InstalledProductList')
                  )
          FROM dbo.SIMPLEDATALISTCATALOG
          WHERE ID = @SIMPLEDATALISTID;

          RETURN @ISPRODUCT;
        end